MySQL throwing error on create table. No idea why

Question

$invited = "CREATE TABLE invited (id NOT NULL AUTO_INCREMENT, PRIMARY KEY (id), name VARCHAR(255), email VARCHAR(255), permissions VARCHAR(255))";
mysqli_query($dbc, $invited) or die ('Error creating invited');

What is wrong with this code? Keeps giving me "Error creating invited"

Instead of just die() output the error message using mysqli_error( $dbc )! — Sirko
– Sirko, Commented Nov 15, 2012 at 10:20

juergen d · Accepted Answer · 2012-11-15 10:21:32Z

4

You forgot the ID data type

CREATE TABLE invited 
(
    id INT NOT NULL AUTO_INCREMENT, ...
        ^--------------------------------------here

answered Nov 15, 2012 at 10:21

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

Comments

Abhishek Saha · Accepted Answer · 2012-11-15 10:23:14Z

1

Use this.

CREATE TABLE `invited` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

answered Nov 15, 2012 at 10:23

Abhishek Saha

2,5641 gold badge20 silver badges29 bronze badges

1 Comment

Useless Code Over a year ago

You can even have it in this multi-line format so it is easy to read by using a heredoc or a nowdoc.

Collectives™ on Stack Overflow

MySQL throwing error on create table. No idea why

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related