Home >Database >Mysql Tutorial >mysql-创建含有日期的表的时候报错，以至于无法创建成功
mysql-创建含有日期的表的时候报错，以至于无法创建成功
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-06 09:33:011144browse
mysql
我创建表test，有两个字段id，ctime；
CREATE TABLE test(
id INT PRIMARY KEY,
ctime DATETIME NOT NULL DEFAULT CURDATE()
);
错误码: 1064
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 'curdate()
)' at line 3
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mac-在Mac下安装了mysql，密码无法登陆Next article：mysql-关于MySQL问题，求大神协助