Hi All,

While going through my project work, I just came across a situation, where I needed to alter my table. I needed to add a column at the beginning of the table, i.e. the first column of the table. We have syntax for appending a column to a table by simple "ALTER TABLE.." syntax, or we can append a column after any particular row by using "AFTER" key word. But my need is to add the column right at the beginning of the table.
Hope fully I have explained my issue properly, now I am expecting somebody to answer my question. Any effort to fix the issue is appreciable.

Thanks

Dipak

Recommended Answers

Add "FIRST" after the column name.
http://dev.mysql.com/doc/refman/5.1/de/alter-table.html

ALTER TABLE mytable ADD COLUMN xyz(text) FIRST;
Jump to Post

All 3 Replies

Thanks friend for the solution. Enjoy your time. :)

DE SINTAX TO ADD email a de start of de table contact is:
ALTER TABLE contacts ADD email VARCHAR(60) FIRST;

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.