MySQL query, syntax error i cannot locate

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

the 6 is the name of the column, not a 开发者_运维技巧value.

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

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

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