On Monday 17 December 2001 02:02, Didier Brisebourg wrote:
> Hi,
>
> Can anybody help me ?
>
> In MySQL documentation, it is said that table name can use any character
> allowed in filename except '/' and '.'.
>
> On my Linux, i can create a file with this name "'w4-1".
>
> But, i can't create the table with this name. The request is rejected.
>
> Has anybody an explanation ?
>
You need to enclose the table name with backticks, eg:
CREATE TABLE `w4-1` (
name varchar(10) NOT NULL default '',
email varchar(30) NOT NULL default ''
);
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Hoffer's Discovery:
The grand act of a dying institution is to issue a newly
revised, enlarged edition of the policies and procedures manual.
*/
---------------------------------------------------------------------
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
