use insertdb;
drop database insertdb;
SET FOREIGN_KEY_CHECKS=0;
CREATE DATABASE `insertdb`
CHARACTER SET 'gbk'
COLLATE 'gbk_chinese_ci';
USE `insertdb`;
#
# Structure for the `tableinsert` table :
#
CREATE TABLE `tableinsert` (
`id` int(11) NOT NULL,
`name` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# Data for the `table` table (LIMIT 0,500)
#
INSERT INTO `tableinsert` (`id`, `name`) VALUES
(1,'测试1'),
(2,'测试2');
COMMIT;
评论0