Sqlite

Tags / Sqlite

I found a fast way to add a new column to a table.

MySQL

Create the new table like the old table (foo), but with the new column you want in it. Make the new table with a different name (foo_new):

Add the records from the old table into the new table:

 INSERT INTO foo_new (col1, col2, col3)
      SELECT col1, col2, col3 FROM foo