SQL/create table

create table テーブル名(
	id int(11) not null auto_increment,
	name varchar(255) default null,
	email varchar(255) default null,
	password varchar(255) default null,
	age integer,
	height real,
	created datetime default null,
	primary key(id)
)CHARSET"utf8mb4", ENGINE=InnoDB;



create table テーブル名(
	id int(11) not null auto_increment,
	name varchar(255) default null,
	email varchar(255) default null,
	password varchar(255) default null,
	age integer,
	height real,
	created datetime default null,
	primary key(id)
)engine=InnoDB default character set utf8 collate utf8_bin;



try {
	$dbh = new PDO("mysql:host=localhost; dbname=test; charset=utf8", 'root', '');
	$sql = 'CREATE TABLE user (
		id int(11) not null auto_increment,
		name varchar(255) default null,
		email varchar(255) default null,
		password varchar(255) default null,
		age integer,
		height real,
		created datetime default null,
		primary key(id)
	)engine=innodb default charset=utf8';
	$res = $dbh->query($sql);
} catch(PDOException $e) {
	echo $e->getMessage();
	exit();
}
$dbh = null;