サンプル作成

sakila database突っ込んだMySQLで各コマンドを打ったサンプルを作成する

show databases;

use sakila

show tables;

select * from city order by city_id desc limit 3;

insert into city (city, country_id) values ('Tokyo', 50);

select * from city where city like 'Hokkaido';

select * from not_exist_table;

select * fr syntax_err;

update city set last_update = NOW() where city_id = 601;

delete from city where city_id = 601;

alter table city add index city_idx (city);