Anvilon
Eric | Links | Kids | Talks | Software | Contact
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 );

Copyright ©1998-2008
Eric Hammond
Credits