sqltest.sql

来自「类可以被用来执行MySQL数据库查询的进口文件。 它开辟了一个特定的文件并读」· SQL 代码 · 共 32 行

-- SQL Import File Example
-- Tested on MySQL 5.0.67
-- Ruben Crespo 羖varez - 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;