Assume that we want to add a column ‘number’ after ‘pass’ column on table ‘test’:
ALTER TABLE test ADD number INT(12) NOT NULL AFTER pass;
Home
>
Add a Column After a Specific Column On a Table Add a Column After a Specific Column On a Table
No Comments »
No comments yet.
RSS feed for comments on this post. TrackBack URL
Leave a comment
Back To Top
Back To Previous Page
Author Bio
Hamid Alipour is a partner in Codehead, LLP with his wife, Tess. Hamid speaks 12 markup and programming languages [Yes, 12: PHP, CSS, Ajax, JavaScript, HTML/XHTML, Java, Python, C/C++, ASP, Visual Basic, Scheme and Action Script]; has a penchant for solving the unsolvable; an affinity for clean, hand-written code and is a Zend Certified 
Services
Blog
Tools
About
Contact
Blog Home