摘要:
using System; using System.Collections.Generic; using System.Diagnostics; using System.Linq; using System.Text; using System.Threading.Tasks; namespace listTst { class Program { stat... 阅读全文
摘要:
update table_name1 aset a.name= (select b.name from table_name2 b where a.oid= b.id)where exists (select 1 from table_name2 c where a.oid= c.id); 阅读全文
摘要:
1、查询是否锁表 show OPEN TABLES where In_use > 0; 2、查询进程 show processlist 查询到相对应的进程 然后 kill id 补充: 查看正在锁的事务 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 查 阅读全文