在研究MySQL数据库的查询优化时,需要先有一个测试环境,然后再进行分析。
自己在生产环境上测试了一个可以顺利执行的mysql数据库脚本,内容如下:
# The sql script is used to create a test mysql database.
# Begtin the sql script.
# Create test database;
create databases test;
use test;
show tables;
select now() as Systemtime;
# Create 5 test tables in test database;
DROP TABLE IF EXISTS `t1`;
DROP TABLE IF EXISTS `t2`;
DROP TABLE IF EXISTS `t3`;
DROP TABLE IF EXISTS `t4`;
DROP TABLE IF EXISTS `t5`;
CREATE TABLE t1(id1 INT,a1 INT,b1 INT,PRIMARY KEY(id1));
CREATE TABLE t2(id2 INT,a2 INT,b2 INT);
CREATE TABLE t3(id3 INT UNIQUE,a3 INT,b3 INT);
CREATE TABLE t4(id4 INT,a4 INT,b4 INT);
CREATE TABLE t5(id5 INT UNIQUE,a5 INT,b5 INT);
show tables;
select now() as Systemtime;
# Create procedure to insert test data into test tables.
select name from mysql.proc where db='test';
show procedure status