List:General Discussion« Previous MessageNext Message »
From:John Lodge Date:January 14 2002 3:14pm
Subject:RE: alter table example.
View as plain text  
Hello,

Your query could use text or varchar(30) or char(30) but not text(30).

John L

-----Original Message-----
From: Gerald Clark [mailto:gerald_clark@stripped]
Sent: Monday, January 14, 2002 3:08 PM
To: matthew@stripped
Cc: mysql@stripped
Subject: Re: alter table example.


Because TEXT does not take a size.

Matthew Darcy wrote:

>I figured out the problem in the book, I have no idea why my mail has not
>come through.
>
>I am stuck on why this is not working though
>
>ALTER TABLE account_details ADD account_name TEXT(30)  NOT NULL
>
>-----Original Message-----
>From: Gerald Clark [mailto:gerald_clark@stripped]
>Sent: 10 January 2002 14:56
>To: matthew@stripped
>Cc: mysql@stripped
>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
>>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.
>>
>>
>>---------------------------------------------------------------------
>>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 <mysql-thread95965@stripped>
>>To unsubscribe, e-mail
>>
><mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread96002@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-comp226=21cn.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



---------------------------------------------------------------------
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 <mysql-thread96299@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-JML=redwoodtech.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
Fwd: Bug#128473: [patch] the mysql crashes on the -D optionChristian Hammers10 Jan
  • alter table example.Matthew Darcy10 Jan
    • Re: alter table example.Gerald Clark10 Jan
      • RE: alter table example.Matthew Darcy10 Jan
        • RE: alter table example.Roger Baklund10 Jan
        • Re: alter table example.Gerald Clark14 Jan
    • Re: alter table example.John Barton10 Jan
    • Upgrade Problem (Mysqlbug)Mazur10 Jan
RE: alter table example.Simon Green10 Jan
RE: alter table example.Amer Neely10 Jan
RE: alter table example.John Lodge14 Jan