MySQL query, syntax error i cannot locate

Question

mysql_query(), query = CREATE TABLE hhh ( Bdate DATE, 6 INT(11) DEFAULT (3) )

the 6 is the name of the column, not a value.

delphist · Accepted Answer · 2011-02-28 18:57:24Z

3

CREATE TABLE hhh (
`Bdate` DATE,
`6` INT(11) DEFAULT 3
)

answered Feb 28, 2011 at 18:57

delphist

4,5591 gold badge24 silver badges22 bronze badges

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

Comments

Neil Knight · Accepted Answer · 2011-02-28 18:58:05Z

1

Put it in apostrophes (or backticks) to see if that helps.

mysql_query(), query = CREATE TABLE hhh ( Bdate DATE, `6` INT(11) DEFAULT 3 )

answered Feb 28, 2011 at 18:58

Neil Knight

48.8k26 gold badges136 silver badges193 bronze badges

@delphist: I thought I'd amended that as well. Good spot. Will update my answer.