sql常用命令
工具/原料
1
数据库mysql或者oracle
2
连接数据库工具
方法/步骤
1
1.查看锁表 SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#, l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID;
2
2、删除表记录DELETE FROM tablename;
3
3、修改为当前时间戳update tablename set vc_timestamp = to_char(systimestamp, 'yyyymmddhh24missff6');
4
4、表之间关联删除delete Afrom A ,Bwhere A.CID=B.CID and B.cp = 2;ordelete Afrom A inner join Bon A.CID=B.CID where B.cp = 2;
5
5、设置表字段值update 表名 set 字段='要修改后的值' where 定位字段='值'