【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供demo.sql参考,解决您在demo.sql学习中工作中的难题,参考学习。
# SQL-Front 4.1 (Build 2.26)
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
# Host: localhost Database: demo
# ------------------------------------------------------
# Server version 5.0.45-community-nt
DROP DATABASE IF EXISTS `demo`;
CREATE DATABASE `demo` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `demo`;
#
# Table structure for table address
#
CREATE TABLE `address` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`sex` varchar(10) default NULL,
`mobile` varchar(20) default NULL,
`email` varchar(50) default NULL,
`qq` varchar(20) default NULL,
`company` varchar(100) default NULL,
`address` varchar(100) default NULL,
`postcode` varchar(10) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ID` (`id`),
KEY `ID_2` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8;
#
# Dumping data for table address
#
INSERT INTO `address` VALUES (1,'admin','admin','mail','','abc@163.com','12345678','IBM','北京','100085');
INSERT INTO `address` VALUES (6,'admin','admin','mail','','abc@163.com','12345678','IBM','北京','100085');
INSERT INTO `address` VALUES (9,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (10,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (11,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (12,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (13,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (14,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (15,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (16,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (17,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (18,'admin','test','','','','','','','');
INSERT INTO `address` VALUES (20,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (21,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (22,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (23,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (24,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (25,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (26,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (27,'admin','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (28,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (29,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (30,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (31,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (32,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (33,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (34,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (35,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (36,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (37,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (38,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (39,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (40,'admin','test2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (41,'admin','test3',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `address` VALUES (42,'admin','test3',NULL,NULL