Cacher is the code snippet organizer for pro developers

-- Create the database wishes_db and specified it for use.
CREATE DATABASE wishes_db;
USE wishes_db;

-- Create the table wishes.
CREATE TABLE wishes
(
id int NOT NULL AUTO_INCREMENT,
wish varchar(255) NOT NULL,
PRIMARY KEY (id)
);

-- Insert a set of records.
INSERT INTO wishes (wish) VALUES ('Shawn wants to read minds.');
INSERT INTO wishes (wish) VALUES ('John wins the lottery.');
INSERT INTO wishes (wish) VALUES ('Kelly wishes for a room full of kittens.');