CREATE TRIGGER new1 AFTER INSERT ON xs FOR EACH ROW SELECT ‘product added’#CREATE TRIGGER创建触发器语句的方法#new1为新触发器的名字#在操作AFTER INSERT命令成功后执行触发器#触发器指定FOR EACH ROW#插入文本打印DROP TRIGGER new1#删除触发器CREATE TRIGGER new1 BEFORE DELETE ON cc FOR EACH ROW BEGIN INSERT INT

delimiter //              #解释符号CREATE PROCEDURE one()    #储存为one的方法beginselect avg(nl) from xs;   #求nl列的平均数，从xs表中end //delimiter ;          #模式转换，分号有空格call one();   

alter table eisc add xb char(10); 动态#新建一个xb的列#-----------------------------------------alter table eisc drop column xb;#删除一个xb的列#----------------------------------------update eisc set xb =999 where id =1;#更新eisc表中的xb的列的id为1的数据alter table js add cons

update xs#更新xs的表set xh = '000000' ,#修改xh的列为6个0（要修改多个数据用逗号隔开）name = 'qqqqqq'#继续修改,修改namewhere id = 1;#指定修改id为1的xh列===========================================#删除id为1的整行的数据，从xs表中-----delete from xs where id =1;===========================================trunc

https://www.cnblogs.com/zwhbk/p/6722205.html       #脚本=========================================================================select * from eisccn,ccn;     #合并数据表==========================================

修改mysql密码：update user set authentication_string=password('root') where user='root' ;-----------------------------------------------------------------------------------------------------cd C:\xampp\mysql\binmysql -uroot -pcreate database eisc;#创建