Hi, I suppose that what you want would be something like: Mysql> create table test(ID int(4), Name varchar(20), Sex varchar(1)); Mysql> alter table test change Name FullName varchar(40);
You should read this for more information about ALTER TABLE: http://www.mysql.com/doc/A/L/ALTER_TABLE.html On Thu, 2002-07-25 at 23:45, Nitesh Divecha wrote: > Hello All, > > I need help with tables. I have created my table with some attributes in > it. > > I need to modify my table attributes, can any one help me with the > modify command or can give me the short cut to the web. > > Example: > Mysql> create table test(ID int(4), Name varchar(20), Sex varchar(1)); > > Now I need to change the attribute NAME TO Full name, HOW? > > Please help, Thanking in Advance. > > Regards > Nitesh -- Diana Soares --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php