MySQLメモ。

gistfile1.txt

http://dev.mysql.com/downloads/mysql/

community server 5.1.xxxがおすすめ。

MySQLは大文字小文字区別されない模様。
create database sampledb character set utf8;
use sampledb;
create table sampletb (id integer, name varchar(64));
show tables;
insert into sampletb(id, name) value(1, "hello");
insert into sampletb(id, name) value(2, "bye");
select * from sampletb;

//tbの中身を消去
delete from sampletb;
//tbそのものを消去

drop table sampletb;
drop database sampledb;