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>
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
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
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
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