【无标题】
emp
CREATE TABLE t1(age INT(5)ZEROFILL);
INSERT INTO t1 VALUES(18);
SELECT * FROM t1;
CREATE TABLE t2(price DOUBLE(5,3));
INSERT INTO t2 VALUES(54.324);
INSERT INTO t2 VALUES(51.324);
#插入时间
CREATE TABLE t3(t1 DATE ,t2 TIME,t3 DATETIME,t4 TIMESTAMP);
INSERT
原创
2022-03-14 19:42:51 ·
48 阅读 ·
0 评论