 |
MySQL schema
First page Back Continue Last page Overview Graphics
MySQL schema
Set up database, user, and table with two columns:
01 CREATE DATABASE reallyshort;
02 USE reallyshort;
03 GRANT DELETE, INSERT, SELECT, UPDATE
04 ON reallyshort.* TO reallyshort@localhost
05 IDENTIFIED BY 'password';
06 CREATE TABLE reallyshort.link (
07 link_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
08 long_url TEXT NOT NULL
09 );
|
 |
 |