Assume that we want to add a column ‘id’ in the beginning of the table ‘test’:
ALTER TABLE test ADD id INT NOT NULL FIRST;
Home
>
Add a Column To The Beginning Of a Table Add a Column To The Beginning Of 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