然后show databases; 提示Ignoring query to other database
仔细对比,原来登录少个-u 我是直接mysql root -p登录进去的。
错误就在少了-u 。。。
1.设计张数据表
dn_user: username,password,IP地址,creatdate
dn_friend: username friendname createdata
dn_friend_msg: fromuser touser createtime msg(记录每次通话记录)
dn_file: filename username createdata addr touser
2. 创建数据表 dn_friend
create table dn_friend(username VARCHAR(20),
friendname VARCHAR(20),
createdata datetime
)
3. 设置数据表的主键与时间的默认值
mysql> alter table dn_friend modify column createdate datetime default CURRENT_TIMESTAMP;
alter table dn_friend add primary key(username,friendname);
触发器
https://www.jb51.net/article/169065.htm
创建一个触发器(触发器不好使,又删除了)
CREATE TRIGGER dn_friend_tri AFTER DELETE ON dn_user for EACH ROW delete from dn_friend where dn_user.username = dn_friend.username;
mysql> DROP TRIGGER dn_friend_tri;
delete from dn_user where username='mqy';
4(创建表)dn_msg
mysql> create table dn_msg(
-> fromname VARCHAR(20),
-> toname VARCHAR(20),
-> createdata datetime default CURRENT_TIMESTAMP,
-> msg VARCHAR(1024));
mysql> insert into dn_msg(fromname,toname,msg) value('mqy','dn','you are beautiful');
mysql> alter table dn_msg add primary key(fromname,toname);
5.存msg的表需主键设置的不对 遂取消主键
mysql> alter table dn_msg drop primary key;
6.dn_file 创建表
mysql> create table dn_file ( filename VARCHAR(256), username VARCHAR(20), createdate datetime default CURRENT_TIMESTAMP, addr VARCHAR(256), touser VARCHAR(256));
alter table dn_file add primary key(filename,username,touser);