MySQL
车家大少爷
Hello World
展开
-
MySQL 循环执行100次,随机0~10
BEGIN declare i int; set i = 0; while i <100 do INSERT INTO test (test1) VALUES (FLOOR(RAND() * 11)); set i = i+1; end while;END转载 2019-04-29 18:38:29 · 4198 阅读 · 0 评论 -
CentOS安装MySQL
1.创建mysql数据存储目录2.获取mysql资源3.安装4.配置5.迁移6.启动mysql-设置开机自启7.初始化配置8.测试mysql1.创建mysql数据存储目录mkdir -p /test/mysql/data2.获取mysql资源rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.no...转载 2019-05-15 15:21:55 · 102 阅读 · 0 评论