adding another field to a table

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
psychotomus
Forum Contributor
Posts: 487
Joined: Fri Jul 11, 2003 1:59 am

adding another field to a table

Post by psychotomus »

how do I add another field to a table?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

huh? Do you mean add a field to a table in a database?

http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

in mysql

Code: Select all

ALTER TABLE `tablename` ADD `column` TEXT NOT NULL ;
TEXT being the column type..
Post Reply