如何写这个脚本?
create database quote_hk;
create database quote_sh;
create database quote_sz;
use quote_hk;
create table `total` (
`code` char(6),
`date` int(8),
`open` decimal(8,3),
`high` decimal(8,3),
`low` decimal(8,3),
`close` decimal(8,3),
`vol` decimal(14,2),
`turnover` decimal(14,2));
create table `ccode` (
`code` char(6));
use quote_sh;
create table `total` (
`code` char(6),
`date` int(8),
`open` decimal(8,3),
`high` decimal(8,3),
`low` decimal(8,3),
`close` decimal(8,3),
`vol` decimal(14,2),
`turnover` decimal(14,2));
create table `ccode` (
`code` char(6));
use quote_sz;
create table `total` (
`code` char(6),
`date` int(8),
`open` decimal(8,3),
`high` decimal(8,3),
`low` decimal(8,3),
`close` decimal(8,3),
`vol` decimal(14,2),
`turnover` decimal(14,2));
create table `ccode` (
`code` char(6));
上面一大串的东西,可否做成一个脚本,让它一次执行,免得一次一个mysql命令浪费时间?