mysql建库建表插入数据
#!/bin/bash user="root" password="123456" mycmd="mysql -u$user -p$password" for dbname in tec stu do $mycmd -e "create database $dbname;" $mycmd -e "use $dbname;create table test(id int,name varchar(18));insert into test values(1,‘rainman‘);" done
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/21280.html
