MySQL 基本的なテーブル作成コマンド（おぼえがき）

create table posts(
id int not null auto_increment primary key,
name varchar(255),
email varchar(255),
password char(32),
score double,
sex enum('male','female') default 'male',
memo text,
createed datetime
);

+----------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | YES | | NULL | |
| email | varchar(255) | YES | | NULL | |
| password | char(32) | YES | | NULL | |
| score | double | YES | | NULL | |
| sex | enum('male','female') | YES | | male | |
| memo | text | YES | | NULL | |
| createed | datetime | YES | | NULL | |
+----------+-----------------------+------+-----+---------+----------------+

//ユーザ一覧
$sql = "select * from users";
$stmt = $dbh->query($sql);
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $user){
var_dump($user['name']);
}

//レコード追加
$stmt = $dbh->prepare("insert into users(name,email, password) values (?,?,?)");
$stmt->execute(array("n", "e", "p"));
echo "done";

//レコード追加2
$stmt = $dbh->prepare("insert into users(name,email, password) values
(:name, :email, :password)" );
$stmt->execute(array(":name"=>"n2", ":email"=>"e2",":password"=>"p2"));

echo "done";