Login   Register  
PHP Classes
elePHPant
Icontem

File: create.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Bimal Poudel  >  MySQL access class  >  create.sql  >  Download  
File: create.sql
Role: Auxiliary data
Content type: text/plain
Description: How I created the sample database - example only
Class: MySQL access class
MySQL database access wrapper
Author: By
Last change:
Date: 2009-01-24 05:19
Size: 488 bytes
 

Contents

Class file image Download 
GRANT ALL ON class_database.* TO 'class'@'localhost' IDENTIFIED BY 'classpassword';

CREATE DATABASE class_database;

DROP TABLE IF EXISTS class_database.domains;

CREATE TABLE class_database.domains
SELECT
	domain_name, domain_server, domain_comments
FROM syndicate_domains
WHERE
	is_active='Y'
;

USE class_database;

SHOW TABLES;

SELECT
	IF(domain_name != '', CONCAT(domain_name, '.', domain_server), domain_server) domain,
	domain_comments comments
FROM domains;