美文网首页
表school.student2(了解)

表school.student2(了解)

作者: name_cc2f | 来源:发表于2019-01-15 19:21 被阅读0次

1、要求

![image.png](https://img.haomeiwen.com/i15572377/6a5aa11987f73b37.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)

2、示例:

1)创建表

mysql> create table student2(

  id int,

    name varchar(50),       

    born_year year,

  birthday date,

  class_time time,

    reg_time datetime

    );

2)插入数据

mysql> desc student2;

mysql> insert into student2 values(1,'tom',now(),now(),now(),now());

mysql> insert into student2 values(2,'jack',1982,19821120,123000,20140415162545);

相关文章

网友评论

      本文标题:表school.student2(了解)

      本文链接:https://www.haomeiwen.com/subject/hkfudqtx.html