jilingxf的个人博客分享 http://blog.sciencenet.cn/u/jilingxf

博文

mysql删除数据库中的所有表

已有 6452 次阅读 2019-5-11 10:37 |个人分类:数据库|系统分类:科研笔记| mysql, 删除, 所有表, 数据

在工作中使用的一些数据库基本操作,不是经常使用,容易忘记,放到这里做个笔记


image.png

    -- 从结果集中拷贝---------------------------------------

    --------------------------------------------------------

    -- DELETE FROM ndg_czxx WHERE 1=1;

    -- DELETE FROM t_cjmxb WHERE 1=1;

    -- DELETE FROM t_czxx WHERE 1=1;

    -- DELETE FROM t_dnxx WHERE 1=1;

    -- DELETE FROM t_fqrjxx WHERE 1=1;

    -- DELETE FROM t_gilts_begin_month WHERE 1=1;

    -- DELETE FROM t_gilts_begin_month12 WHERE 1=1;

    -- DELETE FROM t_gilts_end_month WHERE 1=1;

    -- DELETE FROM t_gzgmxx WHERE 1=1;

    -- DELETE FROM t_gzrqxx WHERE 1=1;

    -- DELETE FROM t_gzswfaxx WHERE 1=1;

    -- DELETE FROM t_gzswxx WHERE 1=1;

    -- DELETE FROM t_gztj WHERE 1=1;

    -- DELETE FROM t_gzxsxx WHERE 1=1;

    -- DELETE FROM t_gzzcxx WHERE 1=1;

    -- DELETE FROM t_gzzrxx WHERE 1=1;

    -- DELETE FROM t_jbxx WHERE 1=1;

    -- DELETE FROM t_lcxx WHERE 1=1;

    -- DELETE FROM t_lcxx_copy1 WHERE 1=1;

    -- DELETE FROM t_mzswxx WHERE 1=1;

    -- DELETE FROM t_mzxsxx WHERE 1=1;

    -- DELETE FROM t_mzztb WHERE 1=1;

    -- DELETE FROM t_pzmx WHERE 1=1;

    -- DELETE FROM t_pzxx WHERE 1=1;

    -- DELETE FROM t_pzxx2 WHERE 1=1;

    -- DELETE FROM t_zzswxx WHERE 1=1;

    -- DELETE FROM temp_addpzid2czxx WHERE 1=1;

    -- DELETE FROM temp_gilts_use WHERE 1=1;

    -- DELETE FROM temp_mzscsy WHERE 1=1;




https://blog.sciencenet.cn/blog-853805-1178364.html

上一篇:利用R GENLIB 计算近交系数
下一篇:python 读取失去了server数据库并写入到excel
收藏 IP: 221.195.40.*| 热度|

0

该博文允许注册用户评论 请点击登录 评论 (0 个评论)

数据加载中...
扫一扫,分享此博文

Archiver|手机版|科学网 ( 京ICP备07017567号-12 )

GMT+8, 2024-12-14 16:00

Powered by ScienceNet.cn

Copyright © 2007- 中国科学报社

返回顶部