可以用如下语句:
insert into music values(null,'天涯',now());
insert into music values(null,'心太软',now());
insert into music values(null,'桔子香水',now());
insert into music values(null,'天涯',now());
insert into music values(null,'心太软',now());
insert into music values(null,'桔子香水',now());
create table music (
id int(5) auto_increment,
song varchar(20),
author varchar(12),
songtime datetime,
primary key (id)
);
再用如下语句插入:
insert into music values(null,'天涯','任贤齐',now());
insert into music values(null,'心太软','任贤齐',now());
insert into music values(null,'桔子香水','任贤齐',now());
insert into music values(null,'只要为你活一天','谢霆锋',now());
如果数据库不是正常退出,会不会寻坏数据库
因为我昨天遇到一个问题,本来我写的程序,用的是mysql数据库,
昨天可以运行,但最后我关的时候不是正常退出,但今天在运行同样的程序说
500 Servlet Exception
java.sql.SQLException: Communication link failure: java.net.SocketException
at org.gjt.mm.mysql.MysqlIO.init(Compiled Code)
at java.lang.Thread.run(Thread.java:479)
我想是不是wait_timeout过期 mysqld自动停止,但实在是不解,望指点
wait_timeout应该如何修改其值??
一定给分的,谢谢!