我只是想把这个字段默认值改为null而已,只是一个普通的字段
有时候还经常出现这个警告,百度也没搜到什么意思
求教大神支个招,这是哪里出了问题呢
有时候还经常出现这个警告,百度也没搜到什么意思
求教大神支个招,这是哪里出了问题呢
解决方案 »
- mysql实现多个字段重复内容的查询
- 如何登陆到安装有2个mysql服务的linux
- 字符集latin1_swedish_ci转换成utf8_general_ci
- 我买的虚拟主机空间,登录phpmyadmin时,提示无法加载 mcrypt 扩展,这个正常吗?
- 求my.ini的标准配置
- MYSQL误删数据,没有备份,没有binlog,能恢复吗
- 请问auto_increament的字段怎么update和insert呢?
- 数据库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)