【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“db_database20.sql”一文,供大家参考学习!
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.1.40-community
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema db_database20
--
CREATE DATABASE IF NOT EXISTS db_database20;
USE db_database20;
--
-- Definition of table `tb_databasetoexcel`
--
DROP TABLE IF EXISTS `tb_databasetoexcel`;
CREATE TABLE `tb_databasetoexcel` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ISBN` varchar(45) DEFAULT NULL,
`bookName` varchar(45) DEFAULT NULL,
`price` float DEFAULT NULL,
`publishing` varchar(45) DEFAULT NULL,
`writer` varchar(45) DEFAULT NULL,
`date` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_databasetoexcel`
--
/*!40000 ALTER TABLE `tb_databasetoexcel` DISABLE KEYS */;
INSERT INTO `tb_databasetoexcel` (`id`,`ISBN`,`bookName`,`price`,`publishing`,`writer`,`date`) VALUES
(1,'7-115-16380-6','Spring搴旂敤寮鍙戝畬鍏ㄦ墜鍐?,59,'浜烘皯閭數鍑虹増绀?,'鏉庝腑灏?,'2007-09-01 00:00:00'),
(2,'7-111-15984-5','
JSP宸ョ▼搴旂敤涓庨」鐩疄鎴?,38,'鏈烘宸ヤ笟鍑虹増绀?,'鐧戒紵鏄?,'2005-02-01 00:00:00'),
(3,'7-111-16490-4','
VB淇℃伅绯荤粺寮鍙戝疄渚嬬簿閫?,44,'鏈烘宸ヤ笟鍑虹増绀?,'楂樻槬鑹?,'2005-07-01 00:00:00');
/*!40000 ALTER TABLE `tb_databasetoexcel` ENABLE KEYS */;
--
-- Definition of table `tb_word`
--
DROP TABLE IF EXISTS `tb_word`;
CREATE TABLE `tb_word` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(45) DEFAULT NULL,
`sex` varchar(45) DEFAULT NULL,
`age` int(10) unsigned DEFAULT NULL,
`profession` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_
word`
--
/*!40000 ALTER TABLE `tb_word` DISABLE KEYS */;
INSERT INTO `tb_word` (`id`,`name`,`sex`,`age`,`profession`) VALUES
(1,'寮犱笁','鐢?,22,'缃戦〉璁捐甯?),
(2,'鏉庡洓','鐢?,23,'涓氬姟鍛?),
(3,'鐜嬩簩','濂?,24,'浼氳'),
(4,'鍒樻祻','濂?,22,'缃戦〉璁捐甯?),
(5,'鍛ㄤ笁','鐢?,28,'杞欢宸ョ▼甯?),
(6,'璧靛洓','鐢?,29,'杞欢宸ョ▼甯?);
/*!40000 ALTER TABLE `tb_word` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;