论坛 › MySQL运维 › MySQL常见错误问答(2)

cxg518 发表于 2018-10-2 06:57:50

MySQL常见错误问答(2)

mysql> INSERT INTO tbl_name (idate) VALUES (19970505);　　mysql> INSERT INTO tbl_name (idate) VALUES ('19970505');
　　mysql> INSERT INTO tbl_name (idate) VALUES ('97-05-05');
　　mysql> INSERT INTO tbl_name (idate) VALUES ('1997.05.05');
　　mysql> INSERT INTO tbl_name (idate) VALUES ('1997 05 05');
　　mysql> INSERT INTO tbl_name (idate) VALUES ('0000-00-00');

　　mysql> SELECT>
　　mysql> SELECT>
　　mysql> SELECT mod(idate,100) FROM tbl_name WHERE>
　　mysql> SELECT>

查看完整版本: MySQL常见错误问答(2)