导入数据库报错#1067 - Invalid default value for 'Author'
这是我要导入的
CREATE TABLE `mini` (
`ID` int(11) NOT NULL auto_increment,
`Title` tinytext NOT NULL,
`Content` text NOT NULL,
`Author` varchar(32) NOT NULL default '小桑',
`Location` varchar(32) NOT NULL default '桂林',
`Post_Date` datetime NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
然后mysqladmin报错
#1067 - Invalid default value for 'Author'
CREATE TABLE `mini` (
`ID` int(11) NOT NULL auto_increment,
`Title` tinytext NOT NULL,
`Content` text NOT NULL,
`Author` varchar(32) NOT NULL default '小桑',
`Location` varchar(32) NOT NULL default '桂林',
`Post_Date` datetime NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
然后mysqladmin报错
#1067 - Invalid default value for 'Author'
作者: shangyanshuo 发布时间: 2011-05-23
估计是字符集问题
在你的SQL文件中加入
SET NAMES GBK;
在你的SQL文件中加入
SET NAMES GBK;
作者: wwwwb 发布时间: 2011-05-23
你的语句测试如下,没有问题。 建议同样贴出你的结果,看看是不是字符集设置的问题。
mysql> CREATE TABLE `mini` (
-> `ID` int(11) NOT NULL auto_increment,
-> `Title` tinytext NOT NULL,
-> `Content` text NOT NULL,
-> `Author` varchar(32) NOT NULL default '小桑',
-> `Location` varchar(32) NOT NULL default '桂林',
-> `Post_Date` datetime NOT NULL,
-> PRIMARY KEY (`ID`)
-> ) ;
Query OK, 0 rows affected (0.14 sec)
mysql> show variables like 'char%';
+--------------------------+----------------------------------------
| Variable_name | Value
+--------------------------+----------------------------------------
| character_set_client | latin1
| character_set_connection | latin1
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | latin1
| character_set_server | latin1
| character_set_system | utf8
+--------------------------+----------------------------------------
8 rows in set (0.03 sec)
mysql>
mysql> CREATE TABLE `mini` (
-> `ID` int(11) NOT NULL auto_increment,
-> `Title` tinytext NOT NULL,
-> `Content` text NOT NULL,
-> `Author` varchar(32) NOT NULL default '小桑',
-> `Location` varchar(32) NOT NULL default '桂林',
-> `Post_Date` datetime NOT NULL,
-> PRIMARY KEY (`ID`)
-> ) ;
Query OK, 0 rows affected (0.14 sec)
mysql> show variables like 'char%';
+--------------------------+----------------------------------------
| Variable_name | Value
+--------------------------+----------------------------------------
| character_set_client | latin1
| character_set_connection | latin1
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | latin1
| character_set_server | latin1
| character_set_system | utf8
+--------------------------+----------------------------------------
8 rows in set (0.03 sec)
mysql>
作者: ACMAIN_CHM 发布时间: 2011-05-23
CREATE TABLE `mini` (
`ID` int(11) NOT NULL auto_increment,
`Title` tinytext NOT NULL,
`Content` text NOT NULL,
`Author` varchar(32) CHARACTER SET utf8 default '小桑' not null,
`Location` varchar(32) CHARACTER SET utf8 default '桂林' not null,
`Post_Date` datetime NOT NULL,
PRIMARY KEY (`ID`)
) engine=MyISAM AUTO_INCREMENT=2 ;
mysql> CREATE TABLE `mini` (
-> `ID` int(11) NOT NULL auto_increment,
-> `Title` tinytext NOT NULL,
-> `Content` text NOT NULL,
-> `Author` varchar(32) CHARACTER SET utf8 default '小桑' not null,
-> `Location` varchar(32) CHARACTER SET utf8 default '桂林' not null,
-> `Post_Date` datetime NOT NULL,
-> PRIMARY KEY (`ID`)
-> ) engine=MyISAM AUTO_INCREMENT=2 ;
Query OK, 0 rows affected (0.06 sec)
`ID` int(11) NOT NULL auto_increment,
`Title` tinytext NOT NULL,
`Content` text NOT NULL,
`Author` varchar(32) CHARACTER SET utf8 default '小桑' not null,
`Location` varchar(32) CHARACTER SET utf8 default '桂林' not null,
`Post_Date` datetime NOT NULL,
PRIMARY KEY (`ID`)
) engine=MyISAM AUTO_INCREMENT=2 ;
mysql> CREATE TABLE `mini` (
-> `ID` int(11) NOT NULL auto_increment,
-> `Title` tinytext NOT NULL,
-> `Content` text NOT NULL,
-> `Author` varchar(32) CHARACTER SET utf8 default '小桑' not null,
-> `Location` varchar(32) CHARACTER SET utf8 default '桂林' not null,
-> `Post_Date` datetime NOT NULL,
-> PRIMARY KEY (`ID`)
-> ) engine=MyISAM AUTO_INCREMENT=2 ;
Query OK, 0 rows affected (0.06 sec)
作者: rucypli 发布时间: 2011-05-23