--添加视图： CREATE VIEW V_TABLENAME AS SELECT * FROM TABLE; --修改视图 CREATE OR REPLACE VIEW V_TABLENAME AS SELECT * FROM TABLE; 或 ALTER VIEW V_TABLENAME AS SELECT * FROM TABLE; --查看视图 DESC V_TABLENAME; 或 SHOW CREATE VIEW V_TABLENAME; --查询视图 SELECT * FROM V_TABLENAME --删除视图 DROP VIEW V1_TABLENAME,V2_TABLENAME,V3_TABLENAME;
--查看autocommit的状态
SHOW VARIABLES LIKE ‘autocommit‘;
事务提交
set autocommit=0; --开启事务，
START TRANSACTION;--可要可不要
delete from 表1 where id =1;
delete from 表2 where id =2;
COMMIT;--提交
事务回滚
set autocommit=0; --开启事务，
START TRANSACTION;--可要可不要
delete from 表1 where id =1;
SAVEPOINT a;--设置保存点
delete from 表2 where id =2;
ROLLBACK TO a;--回滚事务
原文：https://www.cnblogs.com/-zzc/p/13855126.html