DATETIME DEFAULT CURRENT_TIMESTAMP

[tithonus163]

DATETIME DEFAULT CURRENT_TIMESTAMP

mysql> select version(); +------------+ | version() | +------------+ | 5.7.34-log | +------------+ 1 row in set (0.00 sec)

mysql>

mysql> CREATE TABLE example ( -> id INT AUTO_INCREMENT PRIMARY KEY, -> name VARCHAR(50), -> created_at DATETIME DEFAULT sysdate -> ); ERROR 1064 (42000): 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 'sysdate )' at line 4 mysql> CREATE TABLE example ( -> id INT AUTO_INCREMENT PRIMARY KEY, -> name VARCHAR(50), -> created_at DATETIME DEFAULT now -> ); ERROR 1064 (42000): 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 'now )' at line 4 mysql> CREATE TABLE example ( -> id INT AUTO_INCREMENT PRIMARY KEY, -> name VARCHAR(50), -> created_at DATETIME DEFAULT CURRENT_TIMESTAMP -> ); Query OK, 0 rows affected (0.05 sec)

mysql>

[iverycd]

Hello,please upload something like error info then I can help you.