sinat_18132365的专栏

order by 后可以跟很多条件；只要有

delete   from  crm_member m USING  etl.bk_member em where em.member_id=m.id;

 博客 --查询是否锁表了select oid from pg_class where relname='可能锁表了的表'select pid from pg_locks where relation='上面查出的oid'--如果查询到了结果，表示该表被锁 则需要释放锁定select pg_cancel_backend(上面查到的pid)...

d:cd D:\mysql-5.7.19-winx64\binset week=%DATE:~-1%if %week%==日 mysqldump -hlocalhost -uroot -parvato@321 king table> BackupName.sqlif %week%==日 mysql  -hlocalhost  -uroot  -parvato@321  burger_king...