mysql - 如何用mysql制作一个一次性数据库？

Question

我正在寻找相当于:

pg_ctl init -D ~/throw-away-database
pg_ctl start -D ~/throw-away-database
……… work work ………
pg_ctl stop -D ~/throw-away-database
rm -rf ~/throw-away-database

在 MySQL 社区服务器 5.7.4 中。

Answer 1

怎么样

create schema my_throw_away001; -- creates a database synonym schema
use my_throw_away001; -- set this as the current to use

-- Do stuff like

create table myTable
(  id int auto_increment primary key,
   thing varchar(100) not null
);

insert myTable(thing) values ('frog'),('cat');

select * from myTable;

-- Cleanup:

drop schema my_throw_away001; -- drops database, poof gone