readout.sql

create table readout(id int(100) not null ,msg varchar(255)  ,sender varchar(255) ,receiver varchar(255) ,color varchar(30) ,biaoqing varchar(30) ,add_time varchar(100) not null ,primary key(id));insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(1,'这是一条聊天信息','mark','jenny','#453400','苦笑','2016-08-16 08:14:28');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(2,'这是一条聊天信息','mark','jenny','#453400','苦笑','2016-08-16 08:14:28');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(3,'这是一条聊天回复信息','jenny','mark','#6e6e6e','微笑','2016-08-16 08:15:10');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(4,'这个聊天室做的还行哈','Tom','Mark','#321234','哈哈大笑','2016-08-16 08:17:22');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(5,'这个聊天室做不赖','Tom','Mark','#321234','哈哈大笑','2016-08-16 08:18:10');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(6,'谢谢','mark','jenny','green','大笑','2016-08-16 09:22:18');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(7,'大舍大得','Mark','小郭','#ffff80','猥琐地','2016-08-16 10:23:01');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(8,'阿斯顿撒','Mark','','#80ff00','微笑地','2016-08-16 10:23:21');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(9,'大','Mark','','#ff80ff','微笑地','2016-08-16 10:24:24');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(10,'阿斯顿','Mark','','#ff0080','微笑地','2016-08-16 10:25:34');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(11,'','Mark','','','','2016-08-16 10:28:07');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(12,'chatroom_insert.php','Mark','小郭','#00ff00','猥琐地','2016-08-16 10:29:30');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(13,'hahhahah','Mark','大郭','#8000ff','猥琐地','2016-08-16 10:30:29');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(14,'看来还得优化一下！','Mark','小郭','#f8f807','猥琐地','2016-08-16 10:33:58');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(15,'是的啊，需要优化一下了！','Mark','小郭','#ffff00','和蔼地','2016-08-16 10:34:59');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(16,'嘻嘻','Mark','老郭','#ffffff','微笑地','2016-08-16 10:35:32');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(17,'呵呵','Mark','','#00ffff','微笑地','2016-08-16 10:41:28');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(18,'真的假的啊？','Mark','小郭','#ff8000','猥琐地','2016-08-16 10:43:47');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(19,'老郭，你好啊','Mark','老郭','#00ff00','猥琐地','2016-08-16 11:00:55');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(20,'小郭，今天的作业是什么？','Mark','小郭','#ff00ff','猥琐地','2016-08-16 11:03:45');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(21,'哈哈哈啊哈哈哈吧
','Mark','老郭','','猥琐地','2016-08-16 12:53:19');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(22,'不喜欢西红柿上班','Mark','大郭','#12345','目不转睛地','2016-08-16 12:54:16');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(23,'Ajax实现的小小聊天室','Mark','小郭','#804040','和蔼地','2016-08-16 14:48:38');insert into readout(id,msg,sender,receiver,color,biaoqing,add_time) values(24,'嘻嘻嘻','Mark','老郭','#0000ff','猥琐地','2016-08-16 15:21:46');