诗闵

努力 坚持 终有回报

导航

2011年5月17日 #

Alter用法

摘要: The ALTER TABLE command allows you to add, modify, or drop a column from an existing table. Adding column(s) to a table Syntax #1 To add a column to a 阅读全文

posted @ 2011-05-17 13:31 诗闵 阅读(437) 评论(0) 推荐(0)

SQL语句中ALTER的用法

摘要: The ALTER TABLE command allows you to add, modify, or drop a column from an existing table.Adding column(s) to a tableSyntax #1To add a column to an existing table, the ALTER TABLE syntax is:ALTER TABLE table_nameADD column_name column-definition;For example:ALTER TABLE supplierADD supplier_name var 阅读全文

posted @ 2011-05-17 12:47 诗闵 阅读(1328) 评论(0) 推荐(0)