JAVA开发（mysql常用操作语句）-蒲公英云

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

mysql查询库中有多少个表：

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

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

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