What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-02 18:35:05
mysql add column after another
-- ALTER TABLE tbl_name ADD COLUMN column_name column_definition -- [FIRST|AFTER existing_column]; ALTER TABLE office ADD COLUMN phone VARCHAR(200) DEFAULT '000' AFTER name; ALTER TABLE office ADD COLUMN flag INT(1) FIRST; ALTER TABLE office ADD COLUMN ... Add solution -
SQL 2022-01-24 23:22:01
add column to all tables after first column mysql
-- ALTER TABLE tbl_name ADD COLUMN column_name column_definition -- [FIRST|AFTER existing_column]; ALTER TABLE office ADD COLUMN phone VARCHAR(200) DEFAULT '000' AFTER name; ALTER TABLE office ADD COLUMN flag INT(1) FIRST; ALTER TABLE office ADD COLUMN ... Add solution