Syntax error on CREATE TABLE SQL query

Question

What is wrong with the sql? I don't know what is wrong. It keeps giving me syntax errors.

$dbh->exec ("CREATE TABLE 'test'
             (col1 CHAR (64) PRIMARY KEY,
             col2 CHAR (64),
             col3 CHAR (64),
             col4 CHAR (64))") or die (print_r ($dbh->errorInfo (), true));

I'm using EasyPHP, just installed it. I'm trying to create a table using the code above. This is the error it returning. I tried correcting the syntax many times. I honestly think the syntax is correct. Is something to do with the configuration of my EasyPHP installation like maybe mysql configured incorrectly.

Array ( [0] => 42000 [1] => 1064 [2] => 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 '' at line 1 )

Edit: Here is the code i'm using to connect:

function dbConnect ($dbname) {
    $user = "root";
    $pass = "";
    $db = new PDO ("mysql:host=127.0.0.1;dbname=$dbname", $user, $pass);
    if ($db) {
        //echo "Connected to database." . "</br>";
    }

    return $db;
}

Can you also post the code you are using to connect to the database? — Tim Biegeleisen
– Tim Biegeleisen, Commented Mar 5, 2015 at 5:33
you got some advance, see the answers, don't forget check one as correct ;-) — Adrian Cid Almaguer
– Adrian Cid Almaguer, Commented Mar 16, 2015 at 17:48

Adrian Cid Almaguer · Accepted Answer · 2015-03-05 05:38:14Z

2

Change your SQL to:

CREATE TABLE test
             (col1 CHAR (64) PRIMARY KEY,
             col2 CHAR (64),
             col3 CHAR (64),
             col4 CHAR (64))

Try with:

$dbh->exec ("CREATE TABLE test
             (col1 CHAR (64) PRIMARY KEY,
             col2 CHAR (64),
             col3 CHAR (64),
             col4 CHAR (64))") or die (print_r ($dbh->errorInfo (), true));

answered Mar 5, 2015 at 5:38

Adrian Cid Almaguer

7,79113 gold badges44 silver badges66 bronze badges

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

7 Comments

jax Over a year ago

It got rid of the error message. But when I check the database in phpadmin, the table is nonexistent.

Adrian Cid Almaguer Over a year ago

@agentNil try to execute the query in phpmyadmin and see what happens

Adrian Cid Almaguer Over a year ago

@agentNil do you got some advance?

jax Over a year ago

What do you mean got some advance?

jax Over a year ago

No, still don;t know why? Does this normally work? I'm not doing something i'm not suppose to am I? If that is the case, it should narrow down the possible problems to configuration and not the code itself.

|

Hanky Panky · Accepted Answer · 2015-03-05 05:37:39Z

2

Table names don't go inside quotes, change

CREATE TABLE 'test'
             ^    ^

To

CREATE TABLE `test`  // don't even need back ticks usually

answered Mar 5, 2015 at 5:37

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

3 Comments

jax Over a year ago

That's what I had before.

Hanky Panky Over a year ago

If you had that before then there would not be any syntax error, with that change your query works just fine.

jax Over a year ago

I've tried playing around with the quotes, backticsk, but doesn't work.

Collectives™ on Stack Overflow

Syntax error on CREATE TABLE SQL query

2 Answers 2

7 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related