急!mysql 数据库文件导入出现问题

来源:百度知道 编辑:UC知道 时间:2024/05/16 04:05:42
# MySQL-Front Dump 2.4
#
# Host: localhost Database: 503roomdata
#--------------------------------------------------------
# Server version 3.23.40
#
# Table structure for table 'shop_admin'
#
CREATE TABLE `shop_admin` (
`aid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pwd` varchar(40) NOT NULL default '',
`level` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`aid`)
) TYPE=MyISAM;
#
# Dumping data for table 'shop_admin'
#
INSERT INTO shop_admin VALUES("1", "admin", "21232F297A57A5A743894A0E4A801FC3", "1");
INSERT INTO shop_admin VALUES("8", "aa", "4124BC0A9335C27F086F24BA207A4912", "0");
INSERT INTO shop_admin VALUES("7", "qq", "D41D8CD98F00B204E9800998ECF8427E", "1");<

# MySQL-Front Dump 2.4
#
# Host: localhost Database: 503roomdata
#--------------------------------------------------------
# Server version 3.23.40
#
# Table structure for table 'shop_admin'
#

user `你的数据库名- -`
CREATE TABLE `shop_admin` (
`aid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pwd` varchar(40) NOT NULL default '',
`level` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`aid`)
) TYPE=MyISAM;
#
# Dumping data for table 'shop_admin'
#
INSERT INTO shop_admin VALUES("1", "admin", "21232F297A57A5A743894A0E4A801FC3", "1");
INSERT INTO shop_admin VALUES("8", "aa", "4124BC0A9335C27F086F24BA207A4912", "0");
INSERT INTO shop_admin VALUES("7", "qq", "D41D8CD98F00B204E9