Login   Register  
PHP Classes
elePHPant
Icontem

File: localhost.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ihab Abu Afia  >  basic_db  >  localhost.sql  >  Download  
File: localhost.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL Sample
Class: basic_db
Manipulate MySQL table records programmatically
Author: By
Last change:
Date: 2007-08-21 14:01
Size: 596 bytes
 

Contents

Class file image Download
CREATE TABLE `accounts` (
  `user_id` int(11) NOT NULL auto_increment,
  `firstname` varchar(20) NOT NULL,
  `lastname` varchar(20) NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `accounts`
-- 

INSERT INTO `accounts` (`user_id`, `firstname`, `lastname`) VALUES 
(1, 'John', 'Smith'),
(2, 'Michel', 'Soli'),
(3, 'Tony', 'Tomas'),
(4, 'Steve', 'Roa'),
(5, 'Ana Maria', 'Song'),
(6, 'Peter', 'Johns'),
(7, 'Michel', 'Jacky'),
(8, 'Edward', 'Richy'),
(9, 'Susan', 'Chaker'),
(10, 'Dian', 'Peter');