导入数据库报错#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'

估计是字符集问题
在你的SQL文件中加入
SET NAMES GBK;

你的语句测试如下，没有问题。 建议同样贴出你的结果，看看是不是字符集设置的问题。

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>

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)