From: Arno Coetzee (arnoflashmedia.co.za)
Date: Thu Oct 06 2005 - 03:58:32 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

s. keeling wrote:

>Incoming from s. keeling:
>
>
>>Incoming from Pooly:
>>
>>
>>>2005/10/3, s. keeling <keelingspots.ab.ca>:
>>>
>>>
>>>>I'd like to add a bit of history data to a table (who changed a record
>>>>last, and when it was last changed). Is this the way to do it?
>>>>[snip]
>>>> alter table MEMBERS
>>>> alter CHG_DATE set default CURRENT_DATE
>>>>
>>>>
>>>btw, you could do :
>>>
>>>
>
>Grr. Please, what's wrong with this?!?
>
> alter table MEMBERS
> alter MEMBER_INFO varchar(160);
>
>ERROR 1064: You have an error in your SQL syntax. Check the manual \
> that corresponds to your MySQL server version for the right \
> syntax to use near 'varchar(160)' at line 2
>
>The field exists, but I'd like it to accept more chars.
>
>Debian/Gnu Linux Testing/Etch, MySQL 4.0
>
>
>
>
http://dev.mysql.com/doc/mysql/en/alter-table.html

--
Arno Coetzee
Developer
Flash Media Group
Office : 2712 342 7595
Mobile : 2782 693 6180

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]