ALTER TABLE customer
ADD customer_description varchar(255),
ADD established_date datetime,
ADD salesforce_id varchar(18)
It's a bit different with SQL Server, we need to use ADD for each column.
Monday, December 28, 2009
Add multiple columns to a table in MySQL
at 9:53 PM
Labels: MySQL, MySQL Query
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment