mysql add field question..
mysql add field question..
- Started
- Last post
- 2 Responses
- kinetic
i know this was discussed before but i can't find it
i need to add a field to an existing table and i cant seem to do it through the phpMyAdmin interface.
could someone hook up the sql necessary to do this.
thanks :)
- unfittoprint0
Personally i use eskuel:
http://www.phptools4u.com/script…
the interface is more user friendly, more intuitive than phpmyadmin, never failed me once.
Beware: sometimes when you have problem isserting a table/field is because you have to refresh your database/server.
- thirtytwo0
ALTER TABLE tablename ADD COLUMN NewColumnName type()
this will place it at the bottom of the table.ALTER TABLE tablename ADD COLUMN NewColumnName type() AFTER ExistingColumnName;
Will place it in a certain place.You can email me if you need more help...
32