错误日志: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)
请教朋友帮忙解答下,谢谢了
请教朋友帮忙解答下,谢谢了
这个是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下没有建立有这个库,则这个语句也要去掉。