1024 syntax error

[BREZ]

:facewall:Me old head is sore!

My .sql file is 20Mb in size and keeps timing out on import.

I tried uploading the first table on its own with this error as a result.

Error

 

SQL query: Documentation

 

-------------------------------------------------------- --

-- Program Version 3.0.117

IF NOT EXISTS (

SELECT *

FROM master.dbo.sysdatabases

WHERE name = N 'irishavs_list01'

)

CREATE DATABASE [irishavs_list01] USE [irishavs_list01]

 

MySQL said: Documentation

#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 '----------------------------------------------------------

-- Program Version 3' at line 1

[bundyxc]

Try this:

 

IF NOT EXISTS (
SELECT *
FROM master.dbo.sysdatabases
WHERE name = N 'irishavs_list01'
)
CREATE DATABASE [irishavs_list01] USE [irishavs_list01]

[BREZ]

Pardon my old eyes but....

Is that not exactly the same?

 

Without the CREATE and USE i get an 1064

SQL query: Documentation

 

-------------------------------------------------------- --

-- Program Version 3.0.117

IF NOT EXISTS (

SELECT *

FROM master.dbo.sysdatabases

WHERE name = N 'irishavs_list01'

)

 

MySQL said: Documentation

#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 '----------------------------------------------------------

-- Program Version 3' at line 1

[Philip]

A comment (--) needs to have a space after the first 2 hyphens.

-- --------------------------------------------------------
-- Program Version 3.0.117
IF NOT EXISTS (
SELECT *
FROM master.dbo.sysdatabases
WHERE name = N 'irishavs_list01'
)
CREATE DATABASE [irishavs_list01] USE [irishavs_list01]