PHP Classes

File: create.sql

Recommend this page to a friend!
  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: 15 years ago
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;