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:[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 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 <[EMAIL PROTECTED]> >>To unsubscribe, e-mail >> ><[EMAIL PROTECTED]> > >>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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
