MySQL server version for the right syntax to use near 'type = InnoDB' at line 25
来源:互联网 发布:怎么用matlab编程 编辑:程序博客网 时间:2024/06/05 16:46
使用PowerDesigner 生成了sql脚本(摘抄部分):
/*==============================================================*//* DBMS name: MySQL 5.0 *//* Created on: 2017/8/29 11:15:50 *//*==============================================================*//*==============================================================*//* Table: f_discuss_service_predetermine *//*==============================================================*/create table f_discuss_service_predetermines( ID bigint(20) not null comment '主键', TENANT_ID varchar(200) comment '租户Id', CREATOR varchar(80) not null comment '创建人名称', CREATE_USER_ID bigint(20) not null comment '创建人用户ID', CREATE_TIME datetime not null comment '创建时间', MODIFY_USER varchar(80) comment '最后修改人名称', MODIFY_USER_ID bigint(20) comment '最后修改人用户ID', MODIFY_TIME datetime comment '最后修改时间', BUSINESS_ID bigint(20) not null comment '业务id', SERVICE_STAGE_CODE varchar(20), SERVICE_ID bigint(20), BINDING_SERVCIE_ID bigint(20), primary key (ID))type = InnoDB;alter table f_discuss_service_predetermine comment '服务预定信息';
执行错误:
[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 'type = InnoDB' at line 25
可将这语句删除,再执行。
也可以改成 : ENGINE=InnoDB
注:这里表会采用默认引擎,MySQL5.5.5版本之后采用的默认引擎就是InnoDB
阅读全文
0 0
- MySQL server version for the right syntax to use near 'type = InnoDB' at line 25
- MySQL server version for the right syntax to use near 'type=InnoDB' at line 1
- hibernate自动键表报MySQL server version for the right syntax to use near 'type=InnoDB' at line 1
- hibernate自动键表报MySQL server version for the right syntax to use near 'type=InnoDB' at line 7
- You have an error MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 20
- mysql报错:MySQL server version for the right syntax to use near 'type=InnoDB'
- your MySQL server version for the right syntax to use near 'NULL' at line 1
- MySQL server version for the right syntax to use near '-1.stu stu0_' at line 1
- MySQL server version for the right syntax to use near ';) T' at line 7
- MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
- MySQL server version for the right syntax to use near 'info where info.stu_id = 1' at line 1
- Hibernate初运行异常---:MySQL server version for the right syntax to use near 'type=InnoDB'
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT’
- corresponds to your MySQL server version for the right syntax to use near错误原因之一
- mysql ignore 不能执行MySQL server version for the right syntax to use near ignore问题
- java MySQL server version for the right syntax to use near
- 孙子问题-中国剩余定理
- EventBus3.0最容易理解的源码解析
- 拥有确认和取消两个按钮的提示框
- 开发者必读的十大经典书籍
- LINUX常常忽略的一些命令
- MySQL server version for the right syntax to use near 'type = InnoDB' at line 25
- druid连接池监控在spring中的配置
- Android开发者书籍推荐
- prototype.js常用函数详解
- Linux服务器信息查看
- Hdu 3016 Man Down【线段树+Dp】
- 移动端ionic App 资讯上下循环滚动的实现
- HDU 5733 tetrahedron (求四面体内切球模板)
- mybatis动态SQL