递增字段

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);