[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE,
KEY `FK_attentioned_Relationship` (`f_gid`) USING BTREE,
CONS' at line 7
[Err] -- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.5.11
/*!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 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- Create schema codecore
CREATE DATABASE IF NOT EXISTS codecore;
USE codecore;
-- Definition of table `blog`
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
`b_id` int(11) NOT NULL AUTO_INCREMENT,
`u_id` int(11) DEFAULT NULL,
`b_content` mediumtext,
`b_time` datetime DEFAULT NULL,
`b_img` varchar(150) DEFAULT NULL,
`b_degree` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`b_id`),
KEY `FK_User_Blog_Relationship` (`u_id`),
CONSTRAINT `FK_User_Blog_Relationship` FOREIGN KEY (`u_id`) REFERENCES `userinfo` (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=gbk;
-- Dumping data for table `blog`
这个问题我也碰到了。是 CHARSET=utf8mb4 COLLATE=utf8_general_ci。 这句导致的。我把utf8mb4 全部改成utf8。navicat的报警比较少, 第一次用sqlyog,导入报警,明确就是这句有问题,改了就好了。建议用sqlyog.