MySQLi CREATE Table query not working

Question

$sql = "CREATE TABLE comments 
(
ID INT NOT NULL AUTO_INCREMENT,
PosterName VARCHAR(32),
Title VARCHAR(32),
Content VARCHAR(500)
)";
$con->query($sql);

No errors, connection to database is successful. Does anyone know why it doesnt work?

The $con->query() method would've returned false if there was an error, and you would then need to output $con->error to see the error message. — Nick Rolando
– Nick Rolando, Commented Aug 8, 2013 at 22:09

Sylvain Leroux · Accepted Answer · 2013-08-08 22:03:06Z

6

You should have seen that error with that statement:

Incorrect table definition; there can be only one auto column and it must be defined as a key:

auto_increment column must have an UNIQUEindex on them, or more generally being the PRIMARY KEY:

$sql = "CREATE TABLE comments 
(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
PosterName VARCHAR(32),
Title VARCHAR(32),
Content VARCHAR(500)
)";

answered Aug 8, 2013 at 22:03

Sylvain Leroux

52.4k8 gold badges114 silver badges136 bronze badges

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

1 Comment

Martin Kolarov Over a year ago

Thank you. I guess that was the problem. Weird how no errors were appearing for me :o Marking as best answer

Collectives™ on Stack Overflow

MySQLi CREATE Table query not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related