mysql&&check the manual that corresponds to your MySQL server version

datetime相关

问题现象:

mysql> CREATE TABLE `django_session` (
    ->   `session_key` varchar(40) NOT NULL,
    ->   `session_data` longtext NOT NULL,
    ->   `expire_date` datetime(6) NOT NULL,
    ->    PRIMARY KEY (`session_key`),
    ->    KEY `django_session_expire_date_a5c62663` (`expire_date`)
    -> ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
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 '(6)',
   PRIMARY KEY (`session_key`),
   KEY `django_session_expire_da' at line 4

问题分析：
问题产生的根本原因是由于mysql版本的不同，mysql5.5版本不支持"datetime(6)"的写法，改成“datetime”就可以了。
解决方法：

mysql> CREATE TABLE `django_session` (
    ->   `session_key` varchar(40) NOT NULL,
    ->   `session_data` longtext NOT NULL,
    ->   `expire_date` datetime NOT NULL,
    ->    PRIMARY KEY (`session_key`),
    ->    KEY `django_session_expire_date_a5c62663` (`expire_date`)
    -> ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
Query OK, 0 rows affected (0.02 sec)

参考链接：
https://blog.csdn.net/qq_39625079/article/details/87865956