How To Add A New Column To An Existing Table In Mysql?

1.	How To Add A New Column To An Existing Table In Mysql?
Answer» ALTER TABLE tip ADD COLUMN author VARCHAR(40); Query OK, 1 ROW AFFECTED (0.18 sec) Records: 1 Duplicates: 0 WARNINGS: 0 ALTER TABLE tip ADD COLUMN author VARCHAR(40); Query OK, 1 row affected (0.18 sec) Records: 1 Duplicates: 0 Warnings: 0

Answer»

ALTER TABLE tip ADD COLUMN author VARCHAR(40);
Query OK, 1 ROW AFFECTED (0.18 sec)
Records: 1 Duplicates: 0 WARNINGS: 0

ALTER TABLE tip ADD COLUMN author VARCHAR(40);
Query OK, 1 row affected (0.18 sec)
Records: 1 Duplicates: 0 Warnings: 0

Discussion