错误日志: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 'if exists(select * from sysdatabases where name='CompanyManager') drop database' at line 2 (1064)
请教朋友帮忙解答下,谢谢了
请教朋友帮忙解答下,谢谢了
解决方案 »
- mysql gbk_chinese_ci 字符集 插入 '婳' 等字显示是问号?
- MySQL5.1.24配置问题求救!!!!!!
- MySQL新手求助!高手请进来看看!
- Mysql查询删除重复记录,保留最新记录
- mysql如何导入txt文件里的数据,有点急啊
- 我进mysql的密码忘了,请问有什么办法可以重新设置新密码
- 基本表所采用的堆技术!what and advantage and disadvantage?谢谢
- 在win下编的vc程序,怎样使它更新web服务器上的mysql数据库,(odbc,mysql api 皆可),万分感谢!
- [ERROR] /usr/libexec/mysqld: unknown option '--ndbcluster'
- java连接不上mysql的问题
- heap内存表ERROR 1114 : The table 'UserIP' is full
- mysql存储过程
这个是mssql里面的语句改成mysql的话,对应如下:
drop database if exists CompanyManager;
if exists(select * from sysdatabases where name='CompanyManager')
drop database CompanyManager
create database CompanyManager
应该怎么改呀?我对这个不懂呀
create database CompanyManager;
drop database if exists CompanyManager;
create database CompanyManager;
if exists(select * from sysdatabases where name='CompanyManager')
orDROP DATABASE IF EXISTS db_name
create database db_name
use master
if exists(select * from sysdatabases where name='CompanyManager')
drop database if exists CompanyManager
create database CompanyManager
if exists(select * from sysdatabases where name='CompanyManager')
又报这句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 'drop database if exists CompanyManager create database CompanyManager collate ' at line 2 (1064)
drop database if exists CompanyManager;
create database CompanyManager collate;
改成这样
drop database if exists CompanyManager;
create database CompanyManager;
if exists(select * from sysdatabases where name='CompanyManager')drop database if exists CompanyManager
create database CompanyManager
删除这一句
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 'drop database if exists CompanyManager create database CompanyManager collate ' at line 2 (1064)
create database CompanyManager collate;
create database CompanyManager;加上分号
---------
这句应该也要去掉,这个是mssql里面的系统库,如果你在mysql下没有建立有这个库,则这个语句也要去掉。