MySQL Creating temporary table syntax error

Question

I am getting a syntax error when I run a MySQL statement.

I know backticks can be added to the tablename to make it work but was wondering why it happens in the first place.

Create temporary table 6514202534e1b20f0d6331 (user_id INT (10)) ENGINE=HEAP;

If I put this in Mysql Query Browser it treats the table name as two seperate words - 6514202534e1 and b20f0d6331.

The table name is generated dynamically and I haven't had a problem with this before, so I was wondering why it stopped working all of a sudden.

Rolice · Accepted Answer · 2011-07-11 17:06:00Z

3

I think this is because the server (mysql) understands it in this case as 6514202534*e^1 INT.

Using the ` character:

CREATE TEMPORARY TABLE `6514202534e1b20f0d6331` (user_id INT (10)) ENGINE=HEAP;

In this way the MySQL Server understands (explicitly) that the whole phrase is database, table or field not a value or function, etc.

For example `order` is legal while just order will rise an error for invalid order clause.

edited Jul 11, 2011 at 17:06

answered Jul 11, 2011 at 16:55

Rolice

3,1133 gold badges26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dirk Over a year ago

Read his question carefully: "I know backticks can be added to the tablename to make it work but was wondering why it happens in the first place."

ssin Over a year ago

Thanks for the answer, 'e1' was indeed the problem. The error can be fixed by using backticks or starting the table name with a letter rather than a number.

Collectives™ on Stack Overflow

MySQL Creating temporary table syntax error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related