Login   Register  
PHP Classes
elePHPant
Icontem

File: SQLTest.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ruben Crespo  >  SQL Import  >  SQLTest.sql  >  Download  
File: SQLTest.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL File Example
Class: SQL Import
Execute MySQL queries imported from a file
Author: By
Last change: add explanatory comments to the file
Date: 2008-10-23 23:46
Size: 766 bytes
 

Contents

Class file image Download
-- SQL Import File Example
-- Tested on MySQL 5.0.67
-- Ruben Crespo Álvarez - http://peachep.wordpress.com

create database if not exists prueba;
use prueba;

CREATE TABLE if not exists `nombre` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
  `nombre` VARCHAR(60) NOT NULL, 
  `apellidos` VARCHAR(60) NOT NULL,
  PRIMARY KEY (`id`)
)
TYPE = myisam;


CREATE TABLE if not exists `facturas` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
  `factura` VARCHAR(60) NOT NULL, 
  `fecha` VARCHAR(60) NOT NULL,
  PRIMARY KEY (`id`)
)
TYPE = myisam;


CREATE TABLE if not exists `direcciones` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
  `calle` VARCHAR(60) NOT NULL, 
  `numero` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
TYPE = myisam;