Error creating mysql table using php

Question

$createtable=mysql_query("CREATE TABLE IF NOT EXISTS users(username VARCHAR(20),password VARCHAR(20),read TINYINT(1),write TINYINT(1),search TINYINT(1))");

I get the following error when trying to create the table using the above query: Error creating user table: 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 'read TINYINT(1),write TINYINT(1),search TINYINT(1))' at line 1

how do i successfully create the table?thanks in advance.

read is a mysql reserved word, so you'd need to wrap it in backticks to get it working (ditto for write). You should look at changing the field names if at all possible instead. — andrewsi
– andrewsi, Commented Jun 19, 2013 at 17:50

echo_Me · Accepted Answer · 2013-06-19 17:52:35Z

1

try this

 $createtable=mysql_query("CREATE TABLE IF NOT EXISTS users(username VARCHAR(20),password VARCHAR(20),`read` TINYINT(1),`write` TINYINT(1),search TINYINT(1))");

you have read and write are mysql reserved keywords , so you should around them by backticks

answered Jun 19, 2013 at 17:52

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

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

Comments

Astrid · Accepted Answer · 2013-06-19 17:50:59Z

0

Try:

$createtable=mysql_query("CREATE TABLE IF NOT EXISTS users(`username` VARCHAR(20),`password` VARCHAR(20),`read` TINYINT(1),`write` TINYINT(1),`search` TINYINT(1))");

answered Jun 19, 2013 at 17:50

Astrid

1,3124 gold badges24 silver badges49 bronze badges

2 Comments

keithhatfield Over a year ago

While this will work, it's generally bad practice to use reserved words as column names.

amigura Over a year ago

should be write reserved-words

Collectives™ on Stack Overflow

Error creating mysql table using php

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related