4.查看所有用户信息 mysql select host,user,authentication_string from user;
5.为root用户重置密码 mysql update user set authentication_string=password('newPassword') where user='root';
触发器
修改命令结束符 mysql delimiter /
创建触发器 mysql create trigger triggerName before|after insert|update|delete on tableName for each row begin if(new.age>200) then insert into tableName values(value1,value2,...); end if; end /
约束设置默认值采用modify alter table [tableName] modify [columnName] [typeName] default [value];采用alter column alter table [tableName] alter column [columnName] set default [value];modify必须加类型名、而alter col