SQL 備忘録

• create.sql

CREATE DATABASE db_name;

USE db_name;

CREATE TABLE books (
  id int NOT NULL auto_increment,
  asin varchar(50) NOT NULL,
  title varchar(255),
  author varchar(255),
  review text,
  reg_date datetime,
  PRIMARY KEY (id)
);  

• create.sql からデータベースを作成

C:\xampp\mysql\bin> mysql < C:\create.sql -u root -p

• rogin

C:\xampp\mysql\bin> mysql -u root -p

• use

mysql> use db_name;
mysql> show databases;
mysql> show tables;
mysql> describe books;
mysql> select * from books;
mysql> insert into books (asin, title, author) values ('479733245X', 'PHP SuperSample', 'nishizawa');