沐晨~的博客

mysql批量创建测试数据 -- 批量插入脚本 DELIMITER $$ DROP PROCEDURE IF EXISTS proc_batch_insert $$ CREATE PROCEDURE proc_batch_insert() BEGIN DECLARE i INT; SET i=1; WHILE i < 1000 DO INSERT INTO 表('OBJECT_ID','字段1') VALUES(UUID_SHORT(),'值1'); SET i=i+1; END WHILE; END

1、查看磁盘空间情况： # df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup-lv_root 50G 46G 1.6G 97% / tmpfs 1.9G 92K 1.9G 1% /dev/shm /dev/sda1 485M 39M 421M 9% /boot

CentOS 7 64位 安装 MySQL5.7 的详细步骤 1、 配置YUM源 在[MySQL]官网中下载YUM源rpm安装包：http://dev.mysql.com/downloads/repo/yum/ 下载mysql源安装包 wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 安装mysql源 yum localinstall mysql57-community-release-el7-8.noarch