I am trying to understand how to UPDATE multiple rows with different values and I just don’t get it. The solution is everywhere but to me it looks difficult to understand. For instance, three updates into 1 query: UPDATE table_users SET cod_user=”622057″ , date=”12082014″ WHERE user_rol=”student” AND cod_office=”17389551″; UPDATE table_users SET cod_user=”2913659″ , date=”12082014″ WHERE … Read more
Looking through the documentation for the Postgres 9.4 datatype JSONB, it is not immediately obvious to me how to do updates on JSONB columns. Documentation for JSONB types and functions: http://www.postgresql.org/docs/9.4/static/functions-json.html http://www.postgresql.org/docs/9.4/static/datatype-json.html As an examples, I have this basic table structure: CREATE TABLE test(id serial, data jsonb); Inserting is easy, as in: INSERT INTO test(data) … Read more
UPDATE dbo.TestStudents SET LASTNAME = ( CASE WHEN (LASTNAME = ‘AAA’) THEN ‘BBB’ WHEN (LASTNAME = ‘CCC’) THEN ‘DDD’ WHEN (LASTNAME = ‘EEE’) THEN ‘FFF’ ELSE (LASTNAME) END ) The statement work for the purpose but the else condition scan through every record in the table. Is there any way I can leave the unaffected … Read more
I have a very basic UPDATE SQL – UPDATE HOLD_TABLE Q SET Q.TITLE = ‘TEST’ WHERE Q.ID = 101; This query runs fine in Oracle, Derby, MySQL – but it fails in SQL server 2008 with following error: “Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ‘Q’.” If I remove all occurrences … Read more
I have two tables, both looking like id name value =================== 1 Joe 22 2 Derk 30 I need to copy the value of value from tableA to tableB based on check name in each table. Any tips for this UPDATE statement? 8 Answers 8
Table 1: id name desc ———————– 1 a abc 2 b def 3 c adf Table 2: id name desc ———————– 1 x 123 2 y 345 In oracle SQL, how do I run an sql update query that can update Table 1 with Table 2’s name and desc using the same id? So the … Read more
What is the correct SQL syntax to insert a value with an apostrophe in it? Insert into Person (First, Last) Values ‘Joe’, ‘O’Brien’ I keep getting an error as I think the apostrophe after the O is the ending tag for the value. 12 Answers 12
I know that you can insert multiple rows at once, is there a way to update multiple rows at once (as in, in one query) in MySQL? Edit: For example I have the following Name id Col1 Col2 Row1 1 6 1 Row2 2 2 3 Row3 3 9 5 Row4 4 16 8 I … Read more
Using postgres 8.4, My goal is to update existing table: CREATE TABLE public.dummy ( address_id SERIAL, addr1 character(40), addr2 character(40), city character(25), state character(2), zip character(5), customer boolean, supplier boolean, partner boolean ) WITH ( OIDS=FALSE ); Initially i tested my query using insert statement: insert into address customer,supplier,partner SELECT case when cust.addr1 is not … Read more
I want to update the top 100 records in SQL Server. I have a table T1 with fields F1 and F2. T1 has 200 records. I want to update the F1 field in the top 100 records. How can I update based on TOP 100 in SQL Server? 9 Answers 9 Note, the parentheses are … Read more
