SQL DATETIME in create table causes parsing error

Question

When attempting to run this query in Node.JS/Express using MySQL, I get an error.

Without the line "created DATETIME,\n" the code works perfectly. When including that line, or any variation of it (such as trying to attempt to put a default date of the current time), it also says the exact same error.

"You have an error in your SQL syntax; check the ... (redacted) ... for the right syntax to use near '' at line 4"

var create_elements = 
    "CREATE TABLE elements(\n" +
    "id          INT NOT NULL AUTO_INCREMENT,\n" +
    "googleID    VARCHAR(60),\n"  +
    "created     DATETIME,\n"
    "title       VARCHAR(300),\n" +
    "body        TEXT,\n"         +
    "type        ENUM('blog', 'issue'),\n" +
    "PRIMARY KEY (id)\n"          +
    ");";

You're missing a + after "created DATETIME,\n", is that a typo? — mscdex
– mscdex, Commented Aug 29, 2015 at 0:57

Tom · Accepted Answer · 2015-08-29 00:59:04Z

1

There is no plus sign after your new string snippet containing the DATETIME line, so the resulting string does not contain the remaining elements or closing parenthesis and is syntactically invalid.

answered Aug 29, 2015 at 0:59

Tom

9795 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

SQL DATETIME in create table causes parsing error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related