faqts : Education : By Country

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

0 of 4 people (0%) answered Yes
Recently 0 of 4 people (0%) answered Yes

Entry

How can I add fields to a table I've already created in MySQL?

Aug 29th, 2006 05:08
Deepak Sharma, Geoff Smith,


To add a field in the existing table, you have to run this SQL 
statement.
The Format is:
ALTER TABLE <Table_Name> ADD <Field_Name> <Field_Type> (Limit of 
Characters or Digits)
For ex:
ALTER TABLE EMPLOYEE ADD COUNTRY_CODE VARCHAR (3);
Hope this helps!
Deepak
http://www.blueappleonline.com http://www.lmswizdom.com