JAVA开发（mysql常用操作语句）

浅浅的花香味﹌ 2024-03-30 14:07 85阅读 0赞

1.  mysql查询库中有多少个表：

SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES  WHERE table_schema = '库名';

![cab96ff9fce54bd8a01bf377ccf5241d.png][]

1.  mysql批量插入数据脚本：

CREATE PROCEDURE batchInsert()
    
    BEGIN
    DECLARE i INT ;
    SET i = 1 ;
    WHILE i < 10005 DO
        INSERT INTO `hz002_mms`.`p2p_record` (
            `GUID`,
            `CINDEX`,
            `CCODE`,
            `CNAME`,
            `CALL_ID`,
            `CALLED`,
            `CALLED_NODE`,
            `CALLER`,
            `CALLER_NODE`,
            `MSG_TYPE`,
            `RESULT`,
            `REASON`,
            `CDESCRIPTION`,
            `CREATE_TIME`,
            `UPDATE_TIME`,
            `CREATE_USER`,
            `UPDATE_USER`,
            `STATE`
        )
    VALUES
        (
            UUID(),
            '1',
            NULL,
            NULL,
            'A-MgZl7HcMCuaToaEf-nZGzIZ9L5Fn66',
            '0446897205',
            '',
            '0446890026',
            '',
            '0',
            '0',
            NULL,
            NULL,
            '2020-01-13 17:41:14',
            '2020-01-13 17:41:14',
            'system',
            'system',
            '0'
        ) ;
    SET i = i + 1 ;
    END WHILE ; 
    END

1.  mysql导入导出命令

D:\MySQL\MySQL Server 5.5\MySQL Server 5.5\bin>
    mysqldump -h 192.168.18.193 -u root -p hs018 >C:\Users\byroot\Desktop\111\hs018.sql
    
    mysql -h 192.168.18.192 -u root -p -f hs018 <C:\Users\byroot\Desktop\111\hs018.sql
    
    =======================================================================================
    mysqldump -h 192.168.18.193 -u root -p hx012 >C:\Users\byroot\Desktop\111\hx012.sql
    
    mysql -h 192.168.18.192 -u root -p -f hx012 <C:\Users\byroot\Desktop\111\hx012.sql
    
    =======================================================================================
    mysqldump -h 192.168.18.193 -u root -p hx012n >C:\Users\byroot\Desktop\111\hx012n.sql
    
    mysql -h 192.168.18.192 -u root -p -f hx012n <C:\Users\byroot\Desktop\111\hx012n.sql

[cab96ff9fce54bd8a01bf377ccf5241d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/9e3eba1f623749d1850b199ccaf3e367.png