mysql建表时总是出错

[肥老]

CREATE TABLE member(

mid VARCHAR(50) PRIMARY KEY,
password VARCHAR(32) NOT NULL,
name VARCHAR(30) NOT NULL,
address VARCHAR(200) NOT NULL,
telephone VARCHAR(100) NOT NULL,
zipcode VARCHAR(6) NOT NULL,
lastdate DATE DEFAULT NOW(),
lockflag INT(1) DEFAULT 1
);

phpmyadmin总是在lastdate DATE DEFAULT NOW(),的NOW的左括号上显示红波浪线：A comma or a closing bracket was expected.

[尼古拉斯-全蛋]

name password 两个是关键字吧

[qq_23566645]

lastdate timestamp DEFAULT CURRENT_TIMESTAMP 用这种方式

[sinat_34914192]

兄弟 sql里面不能这样来获取时间的 把时间类型设置为timestamp