Bug #4175 MySQL 4.1.3 requires space after table name in CREATE TABLE

• Submitted: 17 Jun 2004 0:27
• Modified: 17 Jun 2004 9:39
• Reporter: Peter Zaitsev (Basic Quality Contributor)
• Status: Won't fix
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.3
• OS: Any (all)
• CPU Architecture: Any

[17 Jun 2004 0:27] Peter Zaitsev

Description:
mysql> create table y(i int unsigned not null primary key, c char(20) not null);
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 'y(i int unsigned not nul

If you will add space after table name the statement will work. 

How to repeat:
create table y(i int unsigned not null primary key, c char(20) not null);

[17 Jun 2004 9:39] Guilhem Bichot

Hello Peter,
I also experienced that - duplicate of http://bugs.mysql.com/bug.php?id=2038
Guilhem