PDA

View Full Version : Mysql tables???



DarkCoder
07-08-2007, 11:47 PM
I'm totally new to mysql but was wondering if it was possible to add columns to tables with existing data. e.g. u forgot a contact field in ur contacts data but u already have data in the table can u add a new field or have u got to create a brand new table and if so can you transfer all the old data to the new table?

thetestingsite
07-08-2007, 11:49 PM
You can add on to the existing table by using the ALTER (http://dev.mysql.com/doc/en/ALTER_TABLE.html) command.

DarkCoder
07-09-2007, 07:18 PM
thank you so much for ur help :)