【求助】MySQL5.7.10安装完成后导入以前的数据库会出现无法编辑数据表的情况呢? 我只是想把这个字段默认值改为null而已,只是一个普通的字段有时候还经常出现这个警告,百度也没搜到什么意思求教大神支个招,这是哪里出了问题呢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 -- phpMyAdmin SQL Dump-- version 3.5.0-- http://www.phpmyadmin.net---- 主机: localhost-- 生成日期: 2015 年 10 月 18 日 23:28-- 服务器版本: 5.1.28-rc-community-- PHP 版本: 5.3.5SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!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 */;---- 数据库: `domainseo`---- ------------------------------------------------------------ 表的结构 `m9_customer`--CREATE TABLE IF NOT EXISTS `m9_customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `domain_id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_bin NOT NULL, `contact` varchar(50) COLLATE utf8_bin NOT NULL, `offer` int(11) NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;-- ------------------------------------------------------------ 表的结构 `m9_domain_category`--CREATE TABLE IF NOT EXISTS `m9_domain_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8_bin NOT NULL, `parent` int(11) NOT NULL DEFAULT '0', `keyword` varchar(100) COLLATE utf8_bin NOT NULL, `desc` text COLLATE utf8_bin NOT NULL, `sort` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=12 ;---- 转存表中的数据 `m9_domain_category`--INSERT INTO `m9_domain_category` (`id`, `name`, `parent`, `keyword`, `desc`, `sort`, `time`) VALUES(2, '英文域名133', 0, '英文,域名', '英文域名接介绍', 2, 1415997387),(1, '英文域名13', 0, '英文,域名', '英文域名接介绍', 1, 1415197387),(3, '新建分类', 2, '新分类11', '新分类介绍', 1, 0),(4, '子分类', 3, '子分类,', '子分类介绍', 1, 0),(8, '顶级分类', 0, '', '', 0, 1415371735),(9, '子分类', 8, '子分类,。,。,。,。,。', '子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,', 2, 1415372802),(10, '子分类2', 2, '', '', 2, 1415372838),(11, '孙分类', 4, '', '', 0, 1415623718);-- ------------------------------------------------------------ 表的结构 `m9_domain_my`--CREATE TABLE IF NOT EXISTS `m9_domain_my` ( `id` int(11) NOT NULL AUTO_INCREMENT, `domain` varchar(50) COLLATE utf8_bin NOT NULL, `category` varchar(50) COLLATE utf8_bin NOT NULL, `pic` text COLLATE utf8_bin NOT NULL, `desc` longtext COLLATE utf8_bin NOT NULL, `keyword` text COLLATE utf8_bin NOT NULL, `label` varchar(100) COLLATE utf8_bin NOT NULL, `price` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=48 ;---- 转存表中的数据 `m9_domain_my`--INSERT INTO `m9_domain_my` (`id`, `domain`, `category`, `pic`, `desc`, `keyword`, `label`, `price`, `time`) VALUES(14, 'hao12333333.com', '8,4', '/Public/Upload/2014-11-12/5462ed49ddc13.jpg', '好123', 'hao123', '', 0, 1415028634),(12, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),(16, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),(15, 'hao123.com', '2', '/Public/Upload/2015-04-18/5531e80030d3a.jpg', '好123', 'hao123', '', 0, 1415028634),(17, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),(18, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),(20, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),(21, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),(24, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),(25, 'hao123.com', '2', '/Public/Upload/2015-04-18/5531e99b88671.jpg', '好123', 'hao123', '', 0, 1415028634),(45, '111', '', '', '1', '', '', 0, 1417959870),(44, '\r\n222', '', '', '2', '', '', 0, 1417959860),(43, '111', '', '', '1', '', '', 0, 1417959860);-- ------------------------------------------------------------ 表的结构 `m9_domain_unadd`--CREATE TABLE IF NOT EXISTS `m9_domain_unadd` ( `id` int(11) NOT NULL AUTO_INCREMENT, `domain` varchar(50) COLLATE utf8_bin NOT NULL, `time` int(11) NOT NULL, `ip` varchar(20) COLLATE utf8_bin NOT NULL, `num` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;-- ------------------------------------------------------------ 表的结构 `m9_seo_category`--CREATE TABLE IF NOT EXISTS `m9_seo_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `keyword` text COLLATE utf8_bin NOT NULL, `layout` varchar(5) COLLATE utf8_bin NOT NULL, `other_category` tinyint(4) NOT NULL DEFAULT '1', `page` int(5) NOT NULL DEFAULT '20', `page_type` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT 'ajax', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;---- 转存表中的数据 `m9_seo_category`--INSERT INTO `m9_seo_category` (`id`, `keyword`, `layout`, `other_category`, `page`, `page_type`) VALUES(1, '111,222', '0.5', 1, 40, 'num');-- ------------------------------------------------------------ 表的结构 `m9_seo_common`--CREATE TABLE IF NOT EXISTS `m9_seo_common` ( `id` int(11) NOT NULL AUTO_INCREMENT, `keyword` text COLLATE utf8_bin NOT NULL, `mult_domain` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '.com', `redirect` tinyint(4) NOT NULL DEFAULT '1', `url_mode` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT 'pathinfo', `rewrite` tinyint(4) NOT NULL DEFAULT '0', `sitemap` tinyint(4) NOT NULL DEFAULT '1', `sitemap_compress` tinyint(4) NOT NULL DEFAULT '0', `sitemap_nohtml` tinyint(4) NOT NULL DEFAULT '0', `sitemap_priority` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '0', `sitemap_changefreq` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT 'weeekly', `nofollow` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;---- 转存表中的数据 `m9_seo_common`--INSERT INTO `m9_seo_common` (`id`, `keyword`, `mult_domain`, `redirect`, `url_mode`, `rewrite`, `sitemap`, `sitemap_compress`, `sitemap_nohtml`, `sitemap_priority`, `sitemap_changefreq`, `nofollow`) VALUES(1, '111,222', 'xxx.com', 0, 'compatible', 0, 0, 1, 1, '0', 'weekly', 1);-- ------------------------------------------------------------ 表的结构 `m9_seo_home`--CREATE TABLE IF NOT EXISTS `m9_seo_home` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(60) COLLATE utf8_bin NOT NULL, `keyword` text COLLATE utf8_bin NOT NULL, `meta_desc` text COLLATE utf8_bin NOT NULL, `layout` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '7', `category` varchar(50) COLLATE utf8_bin NOT NULL, `category_num` int(5) NOT NULL, `sitemap` tinyint(4) NOT NULL DEFAULT '1', `contact_protect` tinyint(4) NOT NULL DEFAULT '1', `link` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;---- 转存表中的数据 `m9_seo_home`--INSERT INTO `m9_seo_home` (`id`, `title`, `keyword`, `meta_desc`, `layout`, `category`, `category_num`, `sitemap`, `contact_protect`, `link`) VALUES(1, '猫咪米店', '域名出售,流量域名,域名交易', '猫猫米店为您提供最优惠的价格购买心仪的域名,海量高品质域名值得您来选择,高权重域名,高流量域名应有尽有', '3', '2,3,11', 15, 1, 1, 1);-- ------------------------------------------------------------ 表的结构 `m9_seo_sell_page`--CREATE TABLE IF NOT EXISTS `m9_seo_sell_page` ( `id` int(11) NOT NULL AUTO_INCREMENT, `keyword` text COLLATE utf8_bin NOT NULL, `simple_url` tinyint(4) NOT NULL DEFAULT '1', `url_keyword` tinyint(4) NOT NULL DEFAULT '1', `clear_url` tinyint(4) NOT NULL DEFAULT '1', `redirect` tinyint(4) NOT NULL DEFAULT '1', `domain_link` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;---- 转存表中的数据 `m9_seo_sell_page`--INSERT INTO `m9_seo_sell_page` (`id`, `keyword`, `simple_url`, `url_keyword`, `clear_url`, `redirect`, `domain_link`) VALUES(1, '222.333', 0, 1, 0, 1, 0);-- ------------------------------------------------------------ 表的结构 `m9_setting_admin`--CREATE TABLE IF NOT EXISTS `m9_setting_admin` ( `id` int(11) NOT NULL, `username` varchar(20) COLLATE utf8_bin NOT NULL, `password` varchar(50) COLLATE utf8_bin NOT NULL, `logintime` int(11) NOT NULL, `loginip` varchar(20) COLLATE utf8_bin NOT NULL, `lock` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;/*!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 */; 为什么看这个提示,给我的感觉是:你改的不是默认值为NULL,而是字段是否允许为空,麻烦你再确认一下。另外你也可以试试修改其他东西,比如字段长度,确定该数据库是否不能编辑。另外你可以在你的建表语句里改,完了再执行。 换个客户端试试,我试了你的语句没有问题,可以修改表结构。我本地是Windows 7(64bit) + MySQL 5.7.10(64bit) 我用的是HeidiSQL 9.1 列出不存在的条目 特特特简单一个问题 你不知道的常识 ant脚本导入mysql存储过程、函数,delimiter参数报错 系统究竟允许存在多少个内存表 表的统计问题 MySQL触发器中如何抛出自定义异常? 这条语句到底是什么意思??---全篇都是这样的语法 mysql 频繁的1226怎么办 c++ 【连接】【mysql】 帮忙写一条语句,大侠们进来喝茶指点指点! 请教mysql统计每天平均值进行运算问题 请问MySQL如何从服务器A往服务器B数据库中复制数据?
-- version 3.5.0
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2015 年 10 月 18 日 23:28
-- 服务器版本: 5.1.28-rc-community
-- PHP 版本: 5.3.5SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;--
-- 数据库: `domainseo`
---- ----------------------------------------------------------
-- 表的结构 `m9_customer`
--CREATE TABLE IF NOT EXISTS `m9_customer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain_id` int(11) NOT NULL,
`name` varchar(50) COLLATE utf8_bin NOT NULL,
`contact` varchar(50) COLLATE utf8_bin NOT NULL,
`offer` int(11) NOT NULL,
`content` text COLLATE utf8_bin NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;-- ----------------------------------------------------------
-- 表的结构 `m9_domain_category`
--CREATE TABLE IF NOT EXISTS `m9_domain_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8_bin NOT NULL,
`parent` int(11) NOT NULL DEFAULT '0',
`keyword` varchar(100) COLLATE utf8_bin NOT NULL,
`desc` text COLLATE utf8_bin NOT NULL,
`sort` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=12 ;--
-- 转存表中的数据 `m9_domain_category`
--INSERT INTO `m9_domain_category` (`id`, `name`, `parent`, `keyword`, `desc`, `sort`, `time`) VALUES
(2, '英文域名133', 0, '英文,域名', '英文域名接介绍', 2, 1415997387),
(1, '英文域名13', 0, '英文,域名', '英文域名接介绍', 1, 1415197387),
(3, '新建分类', 2, '新分类11', '新分类介绍', 1, 0),
(4, '子分类', 3, '子分类,', '子分类介绍', 1, 0),
(8, '顶级分类', 0, '', '', 0, 1415371735),
(9, '子分类', 8, '子分类,。,。,。,。,。', '子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,子分类,,,,,,...,,', 2, 1415372802),
(10, '子分类2', 2, '', '', 2, 1415372838),
(11, '孙分类', 4, '', '', 0, 1415623718);-- ----------------------------------------------------------
-- 表的结构 `m9_domain_my`
--CREATE TABLE IF NOT EXISTS `m9_domain_my` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(50) COLLATE utf8_bin NOT NULL,
`category` varchar(50) COLLATE utf8_bin NOT NULL,
`pic` text COLLATE utf8_bin NOT NULL,
`desc` longtext COLLATE utf8_bin NOT NULL,
`keyword` text COLLATE utf8_bin NOT NULL,
`label` varchar(100) COLLATE utf8_bin NOT NULL,
`price` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=48 ;--
-- 转存表中的数据 `m9_domain_my`
--INSERT INTO `m9_domain_my` (`id`, `domain`, `category`, `pic`, `desc`, `keyword`, `label`, `price`, `time`) VALUES
(14, 'hao12333333.com', '8,4', '/Public/Upload/2014-11-12/5462ed49ddc13.jpg', '好123', 'hao123', '', 0, 1415028634),
(12, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),
(16, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),
(15, 'hao123.com', '2', '/Public/Upload/2015-04-18/5531e80030d3a.jpg', '好123', 'hao123', '', 0, 1415028634),
(17, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),
(18, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),
(20, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),
(21, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),
(24, 'hao123.com', '2', '', '好123', 'hao123', '', 0, 1415028634),
(25, 'hao123.com', '2', '/Public/Upload/2015-04-18/5531e99b88671.jpg', '好123', 'hao123', '', 0, 1415028634),
(45, '111', '', '', '1', '', '', 0, 1417959870),
(44, '\r\n222', '', '', '2', '', '', 0, 1417959860),
(43, '111', '', '', '1', '', '', 0, 1417959860);-- ----------------------------------------------------------
-- 表的结构 `m9_domain_unadd`
--CREATE TABLE IF NOT EXISTS `m9_domain_unadd` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(50) COLLATE utf8_bin NOT NULL,
`time` int(11) NOT NULL,
`ip` varchar(20) COLLATE utf8_bin NOT NULL,
`num` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;-- ----------------------------------------------------------
-- 表的结构 `m9_seo_category`
--CREATE TABLE IF NOT EXISTS `m9_seo_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`keyword` text COLLATE utf8_bin NOT NULL,
`layout` varchar(5) COLLATE utf8_bin NOT NULL,
`other_category` tinyint(4) NOT NULL DEFAULT '1',
`page` int(5) NOT NULL DEFAULT '20',
`page_type` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT 'ajax',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;--
-- 转存表中的数据 `m9_seo_category`
--INSERT INTO `m9_seo_category` (`id`, `keyword`, `layout`, `other_category`, `page`, `page_type`) VALUES
(1, '111,222', '0.5', 1, 40, 'num');-- ----------------------------------------------------------
-- 表的结构 `m9_seo_common`
--CREATE TABLE IF NOT EXISTS `m9_seo_common` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`keyword` text COLLATE utf8_bin NOT NULL,
`mult_domain` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '.com',
`redirect` tinyint(4) NOT NULL DEFAULT '1',
`url_mode` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT 'pathinfo',
`rewrite` tinyint(4) NOT NULL DEFAULT '0',
`sitemap` tinyint(4) NOT NULL DEFAULT '1',
`sitemap_compress` tinyint(4) NOT NULL DEFAULT '0',
`sitemap_nohtml` tinyint(4) NOT NULL DEFAULT '0',
`sitemap_priority` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '0',
`sitemap_changefreq` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT 'weeekly',
`nofollow` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;--
-- 转存表中的数据 `m9_seo_common`
--INSERT INTO `m9_seo_common` (`id`, `keyword`, `mult_domain`, `redirect`, `url_mode`, `rewrite`, `sitemap`, `sitemap_compress`, `sitemap_nohtml`, `sitemap_priority`, `sitemap_changefreq`, `nofollow`) VALUES
(1, '111,222', 'xxx.com', 0, 'compatible', 0, 0, 1, 1, '0', 'weekly', 1);-- ----------------------------------------------------------
-- 表的结构 `m9_seo_home`
--CREATE TABLE IF NOT EXISTS `m9_seo_home` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(60) COLLATE utf8_bin NOT NULL,
`keyword` text COLLATE utf8_bin NOT NULL,
`meta_desc` text COLLATE utf8_bin NOT NULL,
`layout` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '7',
`category` varchar(50) COLLATE utf8_bin NOT NULL,
`category_num` int(5) NOT NULL,
`sitemap` tinyint(4) NOT NULL DEFAULT '1',
`contact_protect` tinyint(4) NOT NULL DEFAULT '1',
`link` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;--
-- 转存表中的数据 `m9_seo_home`
--INSERT INTO `m9_seo_home` (`id`, `title`, `keyword`, `meta_desc`, `layout`, `category`, `category_num`, `sitemap`, `contact_protect`, `link`) VALUES
(1, '猫咪米店', '域名出售,流量域名,域名交易', '猫猫米店为您提供最优惠的价格购买心仪的域名,海量高品质域名值得您来选择,高权重域名,高流量域名应有尽有', '3', '2,3,11', 15, 1, 1, 1);-- ----------------------------------------------------------
-- 表的结构 `m9_seo_sell_page`
--CREATE TABLE IF NOT EXISTS `m9_seo_sell_page` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`keyword` text COLLATE utf8_bin NOT NULL,
`simple_url` tinyint(4) NOT NULL DEFAULT '1',
`url_keyword` tinyint(4) NOT NULL DEFAULT '1',
`clear_url` tinyint(4) NOT NULL DEFAULT '1',
`redirect` tinyint(4) NOT NULL DEFAULT '1',
`domain_link` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;--
-- 转存表中的数据 `m9_seo_sell_page`
--INSERT INTO `m9_seo_sell_page` (`id`, `keyword`, `simple_url`, `url_keyword`, `clear_url`, `redirect`, `domain_link`) VALUES
(1, '222.333', 0, 1, 0, 1, 0);-- ----------------------------------------------------------
-- 表的结构 `m9_setting_admin`
--CREATE TABLE IF NOT EXISTS `m9_setting_admin` (
`id` int(11) NOT NULL,
`username` varchar(20) COLLATE utf8_bin NOT NULL,
`password` varchar(50) COLLATE utf8_bin NOT NULL,
`logintime` int(11) NOT NULL,
`loginip` varchar(20) COLLATE utf8_bin NOT NULL,
`lock` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!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 */;
我本地是Windows 7(64bit) + MySQL 5.7.10(64bit)