plsql错误提示乱码_SQL提示1064错误,求解
问题补充:
-- ----------------------------
-- Table structure for `gc_lottery`
-- ----------------------------
DROP TABLE IF EXISTS `gc_lottery`;
CREATE TABLE `gc_lottery` (
`id` varchar(50) NOT NULL,
`money` double NOT NULL,
`number` int(11) NOT NULL,
`sender` int(11) NOT NULL,
`roomId` varchar(50) NOT NULL,
`description` varchar(200) DEFAULT NULL,
`createTime` datetime NOT NULL,
`status` varchar(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
最佳答案
确实 选择数据库 的语句
use 数据库名;
追问:
Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50709 Source Host : localhost Source Database : gamechat Target Server Version : 50709 File Encoding : utf-8 Date: 03/20/2016 16:13:13 PM*/SET NAMES utf8;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for `gc_lottery`-- ----------------------------DROP TABLE IF EXISTS `gc_lottery`;CREATE TABLE `gc_lottery` ( `id` varchar(50) NOT NULL, `money` double NOT NULL, `number` int(11) NOT NULL, `sender` int(11) NOT NULL, `roomId` varchar(50) NOT NULL, `description` varchar(200) DEFAULT NULL, `createTime` datetime NOT NULL, `status` varchar(2) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
最佳答案由网友 茶谈四季 提供
其他回答
暂无其它回答!