PHP Classes

File: SQLFileToTest1.sql

Recommend this page to a friend!
  Classes of David Castillo  >  MySQL importer  >  SQLFileToTest1.sql  >  Download  
File: SQLFileToTest1.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL File Example with Errors
Class: MySQL importer
Execute SQL statements from MySQL dump files
Author: By
Last change: No changes
Date: 7 years ago
Size: 765 bytes
 

Contents

Class file image Download
-- SQL Import File Example (version with errors)
-- David Castillo Sanchez - davcs86@gmail.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`)
)
ENGINE=MyISAM;


CREATE TABLE if not exists `facturas` (
  `id` INT UNSIGNED NfgOT NULL AUTO_INCREMENT, 
  `factura` VARCHAR(60f) NOT NULL, 
  `fecha` VARCHAsfgR(60) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM;


CREATE TABLE iffg not exists `direcciones` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
  `calle` VARCHAdfgR(60) NOT NULL, 
  `numero` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM;
For more information send a message to info at phpclasses dot org.