MySQL–AddaColumnatParticularOrdinalPositioninTabl_MySQL

Sometimes you may need to add a column at a particular ordinal position in the table. In SQL Server there is no option to do it via SQL although you can use Designer from SQL Server Management Studio. In MySQL you can do it as part ofALTER TABLE statement.

Let us consider the following table

Suppose you want to add another column named modified_date between item_id and sales_date, you can use the following command

Now the new column named modified_date will be added after item_id. You can check this using the following command

Field	Type	Null	Key	Default	Extra--------------------------------------------------------------sales_id	int(11)	NO	PRI	auto_incrementitem_id	int(11)	YES	modified_date	datetime	YES	sales_date	datetime	YES	sales_amount	decimal(12,2)	YES

This is sometimes useful. In relational database the order of column in a table should not matter. The database design and modeling should be such that there should not be any dependency on the order the columns are createdinsideMySQL table. This is the reason, in SQL Server we can’t do this operation via T-SQL and when we do with the help of SSMS, it practically creates and drop the entire table in the background – (a very bad thing).

Reference:Pinal Dave (http://blog.sqlauthority.com)

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com