Dominique, On Sun, Jan 20, 2002 at 12:18:45PM -0800, Dominique Plante wrote: > The following fails (after selecting a database): > > mysql> create table test (key varchar(255), value > varchar(255)); >
You should be able to do this by using back-quotes around the column name: create table test (`key` varchar(255), value varchar(255)); You might want to reconsider using reserved names like this because you will need to use the back-quotes in all your queries. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands --------------------------------------------------------------------- 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
