Shell Script: Create 8 Databases with 128 Tables Each
#!/bin/bash\n\nfor i in {1..8}; do\n for j in {0..127}; do\n table_name=$((($i-1)*128 + $j))\n mysql -u root -p -e "CREATE DATABASE IF NOT EXISTS mydb$i;"\n mysql -u root -p -e "USE mydb$i; CREATE TABLE IF NOT EXISTS mytable$table_name (id INT AUTO_INCREMENT PRIMARY KEY);"\n done\ndone\n\necho "Tables created successfully!"\n
原文地址: https://www.cveoy.top/t/topic/pxiB 著作权归作者所有。请勿转载和采集!