Skip to content

Instantly share code, notes, and snippets.

@vincent178

vincent178/mysql.md

Created June 15, 2014 05:37
Show Gist options
  • Save vincent178/f43f42ecd706b69d4d34 to your computer and use it in GitHub Desktop.
Save vincent178/f43f42ecd706b69d4d34 to your computer and use it in GitHub Desktop.
Download ZIP
mysql
Raw
mysql.md

Create a Database

mysql> CREATE DATABASE php_app;

Create a table

Create a Database

CREATE TABLE admin ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(30) UNIQUE, passcode VARCHAR(30) );

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment