Re: Need help with Tables/Attributes

2002-07-27 Thread Victoria Reznichenko
Nitesh, Friday, July 26, 2002, 1:45:35 AM, you wrote: ND> I need help with tables. I have created my table with some attributes in ND> it. ND> I need to modify my table attributes, can any one help me with the ND> modify command or can give me the short cut to the web. ND> Example: ND> mysql>

Re: Need help with Tables/Attributes

2002-07-27 Thread Diana Soares
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

Need help with Tables/Attributes

2002-07-27 Thread Nitesh Divecha
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)); No

Re: Need help with Tables/Attributes

2002-07-27 Thread Francisco Reinaldo
Hello Nitesh, You can find that and more at... http://www.mysql.com/doc/A/L/ALTER_TABLE.html Good Luck, --- Nitesh Divecha <[EMAIL PROTECTED]> 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, ca

Re: Need help with Tables/Attributes

2002-07-26 Thread Ralf Narozny
Hello! 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