Insert the same fixed value into multiple rows

Question

I ve got a table with a column  lets call it table column that is currently null for all rows of the table   I d like to insert the value  test  into that column for all rows   Can someone give me the SQL for this   I ve tried  INSERT INTO table  table column  VALUES   test    but that only populates that last row   How do I do all of the rows at once

User · Answer

To create a new empty column and fill it with the same value  here 100  for every row  in Toad for Oracle    ALTER TABLE my table ADD new column INT  UPDATE my table SET new column   100

User · Answer

You re looking for UPDATE not insert   UPDATE mytable SET    table column    test     UPDATE will change the values of existing rows  and can include a WHERE to make it only affect specific rows   whereas INSERT is adding a new row  which makes it look like it changed only the last row  but in effect is adding a new row with that value

User · Answer

What you re actually doing is adding rows  To update the content of existing rows use the UPDATE statement   UPDATE table SET table column    test

User · Answer

To update the content of existing rows use the UPDATE statement   UPDATE table name SET table column    test

User · Answer

UPDATE  table  SET table column  test

User · Answer

This is because in relational database terminology  what you want to do is not called  inserting   but  UPDATING  - you are updating an existing row s field from one value  NULL in your case  to  test   UPDATE your table SET table column    test   WHERE table column   NULL    You don t need the second line if you want to update 100  of rows

User · Answer

The SQL you need is   Update table set table column    test     The SQL you posted creates a new row rather than updating existing rows

[mysql] Insert the same fixed value into multiple rows

Examples related to mysql

Examples related to sql

Examples related to sql-update

Examples related to sql-insert