示例Table
create table tb_demo(
id int unsigned auto_increment primary key,
title varchar(50) not null default '',
contents text,
add_time int unsigned default 0
);
插入测试数据
insert into tb_demo (title,contents,add_time) values
('#1 title 001','CONTENT 001 ABCD 1111',unix_timestamp()),
('#2 title 002','CONTENT 002 ABCD 2222',unix_timestamp()),
('#3 title 003','CONTENT 003 ABCD 3333',unix_timestamp()),
('#4 title 004','CONTENT 004 ABCD 4444',unix_timestamp());
预览:\