Hello,
Your query could use text or varchar(30) or char(30) but not text(30).
John L
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 3:08 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: alter table example.
Because TEXT does
gt;-Original Message-
>From: Gerald Clark [mailto:[EMAIL PROTECTED]]
>Sent: 10 January 2002 14:56
>To: [EMAIL PROTECTED]
>Cc: [EMAIL PROTECTED]
>Subject: Re: alter table example.
>
>
>Why don't you give us an example of what does not work, so someone can
>tell yo
* Matthew Darcy
> I am stuck on why this is not working though
>
> ALTER TABLE account_details ADD account_name TEXT(30) NOT NULL
TEXT is a special field type for larger text elements, up to 65535 bytes.
You can not set a max length on this field type. Use VARCHAR, or drop the
size restriction.
> ALTER TABLE member
> ADD member_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMERY KEY;
> ALTER TABEL president DROP suffix
>
> Simon
>
> Note:From MySQL by Paul DuBois
Those statments will surely cause errors, since you've not spelled TABLE
or PRIMARY correctly. Are these your actually workin
:56
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: alter table example.
Why don't you give us an example of what does not work, so someone can
tell you why?
Matthew Darcy wrote:
>
>Can anyone give me an example of an alter table syntax that.
>
>1.) adds a column
>
Matt,
alter table table_name add column column_name column_decriptions;
alter table table_name drop column column_name;
Try checking documentation for more details:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Hope this helps!
>
>
> Can anyone give me an example of an alter table syntax th
table example.
Can anyone give me an example of an alter table syntax that.
1.) adds a column
2.) deletes a column.
I am reading the examples in the oreilly book, and it does not work
also the Oracle or Infomix syntax doesn't work.
can someone give me a clue please.
Thanks,
Why don't you give us an example of what does not work, so someone can
tell you why?
Matthew Darcy wrote:
>
>Can anyone give me an example of an alter table syntax that.
>
>1.) adds a column
>2.) deletes a column.
>
>I am reading the examples in the oreilly book, and it does not work
>also
Can anyone give me an example of an alter table syntax that.
1.) adds a column
2.) deletes a column.
I am reading the examples in the oreilly book, and it does not work
also the Oracle or Infomix syntax doesn't work.
can someone give me a clue please.
Thanks,
Matt.
--
