mysql

作者: SongLiang | 来源:发表于2017-11-04 20:45 被阅读0次

递增字段

create table article
(
id int primary key auto_increment,
title varchar(255)
);
insert into article values (null, 'a');
insert into article (title) value ('c');
select * from article;

日期处理

select now();
select date_format(now(), '%y-%m-%d %h:%i:%s');
insert into emp values (9999, 'test', 'clerk', 7369, '1981-12-23 12:23:23', 8000, 80, 10);

相关文章

网友评论

      本文标题:mysql

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