s. keeling wrote:
Incoming from Arno Coetzee:
s. keeling wrote:
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
Yes, I've read it. Your point? Specifically?
I am encoutering error 1064, surrounding table names and column names
with backticks solves nothing.
Is there something _specific_ on that page I'm missing?
Thanks for trying.
sorry ... bit busy on this side... had a quick look...
give this a go...
alter table MEMBERS
MODIFY MEMBER_INFO varchar(160);
hope this works
--
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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
