View Full Version : MySQL mssql -> mysql?
Zaid_W1red
July 16th, 2008, 02:07 PM
hey ladies and gents.
I have a .SQL file which is an export of a mssql database.
I'm trying to import this to a mysql database.
The syntax of the .SQL while familier to me has some fairly alien commands - I've never worked with mssql so they are to me anyway.
Is there any simple clean way of doing this?
Zaid
sekasi
July 16th, 2008, 02:10 PM
you should be able to import it into mysql in compatibility mode. What errors are you getting?
Zaid_W1red
July 16th, 2008, 02:12 PM
thanks for the reply sekasi.
i can only use phpmyadmin...the error is a beast as it dumps most of the db:
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNrtWltz2kYU3tfyK/YhD07HECSM7TLTBxljwhQEQXLSpuPxYExsWnGpwJ3QX99vDxcJ W9KuLmls
V6MZ0K72XPbsd86es1Kj3+/2a7yu8brO2w2zxjWuc61yenRUsGw8YYWC9RHdb1q3Nb74y5kP3 MXI
LTnjm9L8fs618lFF53q5fFIsHxc1jWsntXK5Vj3+zJ3R5Cf+pt BZWR/aNV4tlUuVk+JwNpk8TMfL
VXG6LFxafd61DrnRbJj2If/YgLzOYMgt48Lot4ikqlcLvY5R43pJA4NC731PjDvsWoKlXtL5p 5Zp
2oW2YTZrfDQtPiy/FE8LJPKSWazBOPudfWYGa7FzZrMRW7AlG7Mpu2NXrICrybr0/4796Ls4em/Y
Hxg/xPga2pxdgnbE3EiOfHNZoHPRO8czjnED/I+IT5mdQJbGjvGro1Vmp+jVWBVPK7iv0T3f0+Yd
aVhnfczHgMwGaSNm15doc4F5iDFt/DcxxpSM/4R+m70nnRugNiCnjZ5rSKujv8E66PsZPG5hn1kq
Gxp4NmAr9gt7YBPcud/NfsGaBNsueOy3tpsNSTfMQR/38Sjh3oKO1+Dt0jqK1Vx8YzsKu9l4YsAi
FuZ9jX8x2zZaQndzb27b0R8wpku2PwdFi+xkot2CtVqblQij9S T1cH+OS6xGM4Bif41t3J1Br4ai
1Q6Ixw+0yi7peLWhFGsxpvV2aJwGCx2SFd/i16SZ8Z0dDn18TNBMQL/m9DchZsjuN8g5ICvLuZyD
wxI0Y8hfbHiJlfyK36sQmhbpexch25P8lLqLMbfkq6o2eMqjgb iyxe1tCj4u2jPMZBY6kzWC/fSC
+u0GIYKmhxVvkRf22W/ER2DkV0Kg6G2idR06Oi4qL3Bl7eEO+kTMyf1b3b/9NjvY840sfDtejHhK
b2P8ktZ8zWOaOD74I5kar8c8hM3rsL+pEC3C9OihfwUsJos4Td BNMS6c+jSU+gIr72zilSziRumQ
bcwUeVV4fA6KjtEUtwl2gT6eCwkDyry2EWKL2XVrSbgdRfCQ2+ Uk1C51XOG732uP212KzWP0TvPI
rRy5H1vNi93dTGK3nQmXrjTWHCnwSJ9pdWPHkh6kzTDygZDs2S LYQ+P45/f3uDraDzR34V+j3OuU
vS7Icp7nWXgyS+0zfhmrnf8slHYINZ51QnbUDv6y8GxD7wHG/5kjWRnJ+zY7yDjuGxntQY/z/6dY
rShk3XZA9h8v9xc2jdoDwilbZO96AspzeKxLqF3v8vE59Aj/w531vsCSM+J4JYkWQrJL1cYQ8SK+
5AtwcHB5KFPPb/16OOS/SWgbu5xfZc/2a568QjsjtPb3KoioHMNGa7A7WY6PSXk9GF5zpK96LFwD
n29GzzRO5WfHztZs6arpEShbz1acnrmJ0G4nOH20U1XS6tlpJZ SHJc0Domg7CvT6K69cv8IC9xsP
Hu35fZ6ByDOQMOv582kzg2xabS/TpZzEjrIf21X3UwtyJzR/55VUkc0c/SnQ3/wfoP/547dN2dro
UY6aY1eO3SDL+SvIbe9/8Q6pGnnu5+kiO4esRNQSHpcu/MiJ8KMoLrJqLFyqvCKJrp8WlJsmqYaS
V69ZZNVuiqxeUKc/N+4nqox6FHEfS4+jfdz6R3ydMWb/JKolljucWQo4CeMyhK5z6XqpVPvy70HK
Ly5X6lBtOH1yDpXvNvLdJth23n4T9DyLnSeIb5pdJIhf0gj1/BGfIz0+0sMQnt23dm4qBPvpzyTn
ujI+6fdmcX52J/3uTZPoEXRyF/yWOsqzk8aetPv+ds/0f92TxBI32LeXic+93V1eFCdLGga+hY6X
Jxnkg/t5tcq3jx4HsWbORt+ot0P6i4vA2yqtTnPIo3Dc6taz28FeVeNm lF+cAf2rhG8V1Wps1do4
bmW61ny/Mor39mK2qUnvlGWua6pZ7Jrq+ftp/jVOUk/Nv8bJHs//AmL2uXI=
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 1 2 13844
STR:
SVN: $Id: sqlparser.lib.php 10432 2007-06-11 17:00:56Z lem9 $
MySQL: 5.0.37-community-nt
USR OS, AGENT, VER: Mac SAFARI 5.0.525
PMA: 2.10.3
PHP VER,OS: 5.2.2 WINNT
LANG: en-utf-8
SQL: USE [ZAIDTesting]
GO
/****** Object: User [ZAIDTesting] Script Date: 07/16/2008 15:38:15 ******/
CREATE USER [ZAIDTesting] FOR LOGIN [ZAIDTesting] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: User [AjayKumar] Script Date: 07/16/2008 15:38:15 ******/
CREATE USER [AjayKumar] FOR LOGIN [AjayKumar] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: Table [dbo].[SR_Artists] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Artists](
[ArID] [decimal](18, 0) NOT NULL,
[AName] [varchar](150) NOT NULL,
[ADetails] [text] NULL,
[AImage] [varchar](50) NULL,
[AOrder] [decimal](18, 0) NULL,
[AEnabled] [decimal](18, 0) NULL,
[ArLogo] [varchar](200) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_Albums] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Albums](
[AID] [decimal](18, 0) NOT NULL,
[ArID] [decimal](18, 0) NULL,
[ATitle] [nvarchar](150) NOT NULL,
[AArtist] [nvarchar](150) NULL,
[DICPN] [varchar](50) NOT NULL,
[PType] [varchar](50) NULL,
[AGenre] [varchar](80) NULL,
[FolderName] [varchar](50) NULL,
[AImage] [varchar](50) NULL,
[AOrder] [int] NULL,
[AEnabled] [int] NULL,
[Adetails] [text] NULL,
[AReleaseDate] [datetime] NULL,
[ARImage] [varchar](70) NULL,
[CC] [varchar](100) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_Options] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Options](
[OID] [decimal](18, 0) NOT NULL,
[TID] [decimal](18, 0) NOT NULL,
[OName] [varchar](40) NOT NULL,
[OOrder] [decimal](18, 0) NULL,
[OEnabled] [int] NULL,
[ProductID] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_Countries] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Countries](
[Sno] [decimal](18, 0) NOT NULL,
[CountryNames] [varchar](100) NOT NULL,
[CountryCode] [varchar](5) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_Tracks] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Tracks](
[TID] [decimal](18, 0) NOT NULL,
[AID] [decimal](18, 0) NOT NULL,
[TTitle] [varchar](350) NOT NULL,
[TArtist] [varchar](150) NULL,
[TEID] [varchar](50) NULL,
[ISRC] [varchar](50) NULL,
[Duration] [varchar](50) NULL,
[Price] [float] NOT NULL,
[Currency] [varchar](50) NULL,
[FullTrack] [varchar](100) NULL,
[Clip] [varchar](100) NULL,
[Ext] [varchar](10) NULL,
[FType] [varchar](50) NULL,
[BitRate] [int] NULL,
[TLang] [varchar](150) NULL,
[TGenre] [varchar](70) NULL,
[ReleaseDate] [datetime] NULL,
[SSale] [int] NULL,
[TOrder] [int] NULL,
[TEnabled] [int] NULL,
[TType] [varchar](20) NULL,
[Category] [varchar](50) NULL,
[TDetails] [text] NULL,
[TImage] [varchar](50) NULL,
[ProductID] [varchar](30) NULL,
[SCode] [varchar](30) NULL,
[SMSCode] [varchar](20) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_xChangeRate] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_xChangeRate](
[SN] [decimal](18, 0) NOT NULL,
[Currency] [varchar](20) NOT NULL,
[ExRate] [float] NOT NULL,
[Symbol] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_xChangeRate] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_xChangeRate](
[SN] [decimal](18, 0) NOT NULL,
[Currency] [varchar](20) NOT NULL,
[ExRate] [float] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_LiteTrack] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_LiteTrack](
[TrackID] [decimal](18, 0) NOT NULL,
[ArID] [decimal](5, 0) NULL,
[TrackName] [varchar](300) NULL,
[TrackOnly] [varchar](300) NULL,
[Price] [float] NULL,
[TrackType] [varchar](5) NULL,
[Clipstat] [varchar](10) NULL,
[ISRC] [varchar](50) NULL,
[Category] [varchar](50) NULL,
[TrType] [varchar](20) NULL,
[TrOrder] [decimal](18, 0) NULL,
[RDate] [datetime] NULL,
[PreOrder] [varchar](20) NULL,
[Enabled] [int] NULL,
[tsize] [varchar](50) NULL,
[trackStat] [varchar](100) NULL,
[clpType] [varchar](100) NULL,
[ClipName] [varchar](100) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_MainArtist] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_MainArtist](
[MainArtistID] [decimal](18, 0) NOT NULL,
[MainArtistName] [varchar](300) NULL,
[MainArtistOrder] [decimal](18, 0) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_Artist] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_Artist](
[ArID] [decimal](18, 0) NOT NULL,
[ArName] [varchar](300) NULL,
[ArNameBack] [varchar](300) NULL,
[ArOrder] [decimal](18, 0) NULL,
[ImgLogo] [varchar](100) NULL,
[ArDetails] [varchar](4000) NULL,
[MArtistID] [decimal](18, 0) NULL,
[Enabled] [int] NULL,
[ClipFolder] [varchar](100) NULL,
[bytype] [varchar](50) NULL,
[rdate] [datetime] NULL,
[countries] [varchar](20) NULL,
[A_Price] [varchar](200) NULL,
[islatest] [varchar](20) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_LiteCart] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_LiteCart](
[CartID] [decimal](18, 0) NOT NULL,
[BuyID] [varchar](50) NULL,
[TrackID] [decimal](5, 0) NULL,
[TrackPrice] [float] NULL,
[BuyDate] [varchar](50) NULL,
[Postage] [float] NULL,
[Preorder] [varchar](20) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_Countries] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_Countries](
[Sno] [decimal](18, 0) NOT NULL,
[CountryNames] [varchar](100) NOT NULL,
[CountryCode] [varchar](5) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
----END RAW----
SQL query:
USE [ZAIDTesting] GO /****** Object: User [ZAIDTesting] Script Date: 07/16/2008 15:38:15 ******/ CREATE USER [ZAIDTesting] FOR LOGIN [ZAIDTesting] WITH DEFAULT_SCHEMA=[dbo] GO /****** Object: User [AjayKumar] Script Date: 07/16/2008 15:38:15 ******/ CREATE USER [AjayKumar] FOR LOGIN [AjayKumar] WITH DEFAULT_SCHEMA=[dbo] GO /****** Object: Table [dbo].[SR_Artists] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Artists]( [ArID] [decimal](18, 0) NOT NULL, [AName] [varchar](150) NOT NULL, [ADetails] [text] NULL, [AImage] [varchar](50) NULL, [AOrder] [decimal](18, 0) NULL, [AEnabled] [decimal](18, 0) NULL, [ArLogo] [varchar](200) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_Albums] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Albums]( [AID] [decimal](18, 0) NOT NULL, [ArID] [decimal](18, 0) NULL, [ATitle] [nvarchar](150) NOT NULL, [AArtist] [nvarchar](150) NULL, [DICPN] [varchar](50) NOT NULL, [PType] [varchar](50) NULL, [AGenre] [varchar](80) NULL, [FolderName] [varchar](50) NULL, [AImage] [varchar](50) NULL, [AOrder] [int] NULL, [AEnabled] [int] NULL, [Adetails] [text] NULL, [AReleaseDate] [datetime] NULL, [ARImage] [varchar](70) NULL, [CC] [varchar](100) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_Options] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Options]( [OID] [decimal](18, 0) NOT NULL, [TID] [decimal](18, 0) NOT NULL, [OName] [varchar](40) NOT NULL, [OOrder] [decimal](18, 0) NULL, [OEnabled] [int] NULL, [ProductID] [varchar](10) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_Countries] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Countries]( [Sno] [decimal](18, 0) NOT NULL, [CountryNames] [varchar](100) NOT NULL, [CountryCode] [varchar](5) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_Tracks] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Tracks]( [TID] [decimal](18, 0) NOT NULL, [AID] [decimal](18, 0) NOT NULL, [TTitle] [varchar](350) NOT NULL, [TArtist] [varchar](150) NULL, [TEID] [varchar](50) NULL, [ISRC] [varchar](50) NULL, [Duration] [varchar](50) NULL, [Price] [float] NOT NULL, [Currency] [varchar](50) NULL, [FullTrack] [varchar](100) NULL, [Clip] [varchar](100) NULL, [Ext] [varchar](10) NULL, [FType] [varchar](50) NULL, [BitRate] [int] NULL, [TLang] [varchar](150) NULL, [TGenre] [varchar](70) NULL, [ReleaseDate] [datetime] NULL, [SSale] [int] NULL, [TOrder] [int] NULL, [TEnabled] [int] NULL, [TType] [varchar](20) NULL, [Category] [varchar](50) NULL, [TDetails] [text] NULL, [TImage] [varchar](50) NULL, [ProductID] [varchar](30) NULL, [SCode] [varchar](30) NULL, [SMSCode] [varchar](20) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_xChangeRate] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_xChangeRate]( [SN] [decimal](18, 0) NOT NULL, [Currency] [varchar](20) NOT NULL, [ExRate] [float] NOT NULL, [Symbol] [varchar](10) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_xChangeRate] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_xChangeRate]( [SN] [decimal](18, 0) NOT NULL, [Currency] [varchar](20) NOT NULL, [ExRate] [float] NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_LiteTrack] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_LiteTrack]( [TrackID] [decimal](18, 0) NOT NULL, [ArID] [decimal](5, 0) NULL, [TrackName] [varchar](300) NULL, [TrackOnly] [varchar](300) NULL, [Price] [float] NULL, [TrackType] [varchar](5) NULL, [Clipstat] [varchar](10) NULL, [ISRC] [varchar](50) NULL, [Category] [varchar](50) NULL, [TrType] [varchar](20) NULL, [TrOrder] [decimal](18, 0) NULL, [RDate] [datetime] NULL, [PreOrder] [varchar](20) NULL, [Enabled] [int] NULL, [tsize] [varchar](50) NULL, [trackStat] [varchar](100) NULL, [clpType] [varchar](100) NULL, [ClipName] [varchar](100) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_MainArtist] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_MainArtist]( [MainArtistID] [decimal](18, 0) NOT NULL, [MainArtistName] [varchar](300) NULL, [MainArtistOrder] [decimal](18, 0) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_Artist] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_Artist]( [ArID] [decimal](18, 0) NOT NULL, [ArName] [varchar](300) NULL, [ArNameBack] [varchar](300) NULL, [ArOrder] [decimal](18, 0) NULL, [ImgLogo] [varchar](100) NULL, [ArDetails] [varchar](4000) NULL, [MArtistID] [decimal](18, 0) NULL, [Enabled] [int] NULL, [ClipFolder] [varchar](100) NULL, [bytype] [varchar](50) NULL, [rdate] [datetime] NULL, [countries] [varchar](20) NULL, [A_Price] [varchar](200) NULL, [islatest] [varchar](20) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_LiteCart] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_LiteCart]( [CartID] [decimal](18, 0) NOT NULL, [BuyID] [varchar](50) NULL, [TrackID] [decimal](5, 0) NULL, [TrackPrice] [float] NULL, [BuyDate] [varchar](50) NULL, [Postage] [float] NULL, [Preorder] [varchar](20) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_Countries] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_Countries]( [Sno] [decimal](18, 0) NOT NULL, [CountryNames] [varchar](100) NOT NULL, [CountryCode] [varchar](5) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO
MySQL said:
#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 'U' at line 1
i used compatibility mode here with no joy...
Zaid_W1red
July 16th, 2008, 02:14 PM
thanks for the reply sekasi.
i can only use phpmyadmin...the error is a beast as it dumps most of the db:
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNrtWltz2kYU3tfyK/YhD07HECSM7TLTBxljwhQEQXLSpuPxYExsWnGpwJ3QX99vDxcJ W9KuLmls
V6MZ0K72XPbsd86es1Kj3+/2a7yu8brO2w2zxjWuc61yenRUsGw8YYWC9RHdb1q3Nb74y5kP3 MXI
LTnjm9L8fs618lFF53q5fFIsHxc1jWsntXK5Vj3+zJ3R5Cf+pt BZWR/aNV4tlUuVk+JwNpk8TMfL
VXG6LFxafd61DrnRbJj2If/YgLzOYMgt48Lot4ikqlcLvY5R43pJA4NC731PjDvsWoKlXtL5p 5Zp
2oW2YTZrfDQtPiy/FE8LJPKSWazBOPudfWYGa7FzZrMRW7AlG7Mpu2NXrICrybr0/4796Ls4em/Y
Hxg/xPga2pxdgnbE3EiOfHNZoHPRO8czjnED/I+IT5mdQJbGjvGro1Vmp+jVWBVPK7iv0T3f0+Yd
aVhnfczHgMwGaSNm15doc4F5iDFt/DcxxpSM/4R+m70nnRugNiCnjZ5rSKujv8E66PsZPG5hn1kq
Gxp4NmAr9gt7YBPcud/NfsGaBNsueOy3tpsNSTfMQR/38Sjh3oKO1+Dt0jqK1Vx8YzsKu9l4YsAi
FuZ9jX8x2zZaQndzb27b0R8wpku2PwdFi+xkot2CtVqblQij9S T1cH+OS6xGM4Bif41t3J1Br4ai
1Q6Ixw+0yi7peLWhFGsxpvV2aJwGCx2SFd/i16SZ8Z0dDn18TNBMQL/m9DchZsjuN8g5ICvLuZyD
wxI0Y8hfbHiJlfyK36sQmhbpexch25P8lLqLMbfkq6o2eMqjgb iyxe1tCj4u2jPMZBY6kzWC/fSC
+u0GIYKmhxVvkRf22W/ER2DkV0Kg6G2idR06Oi4qL3Bl7eEO+kTMyf1b3b/9NjvY840sfDtejHhK
b2P8ktZ8zWOaOD74I5kar8c8hM3rsL+pEC3C9OihfwUsJos4Td BNMS6c+jSU+gIr72zilSziRumQ
bcwUeVV4fA6KjtEUtwl2gT6eCwkDyry2EWKL2XVrSbgdRfCQ2+ Uk1C51XOG732uP212KzWP0TvPI
rRy5H1vNi93dTGK3nQmXrjTWHCnwSJ9pdWPHkh6kzTDygZDs2S LYQ+P45/f3uDraDzR34V+j3OuU
vS7Icp7nWXgyS+0zfhmrnf8slHYINZ51QnbUDv6y8GxD7wHG/5kjWRnJ+zY7yDjuGxntQY/z/6dY
rShk3XZA9h8v9xc2jdoDwilbZO96AspzeKxLqF3v8vE59Aj/w531vsCSM+J4JYkWQrJL1cYQ8SK+
5AtwcHB5KFPPb/16OOS/SWgbu5xfZc/2a568QjsjtPb3KoioHMNGa7A7WY6PSXk9GF5zpK96LFwD
n29GzzRO5WfHztZs6arpEShbz1acnrmJ0G4nOH20U1XS6tlpJZ SHJc0Domg7CvT6K69cv8IC9xsP
Hu35fZ6ByDOQMOv582kzg2xabS/TpZzEjrIf21X3UwtyJzR/55VUkc0c/SnQ3/wfoP/547dN2dro
UY6aY1eO3SDL+SvIbe9/8Q6pGnnu5+kiO4esRNQSHpcu/MiJ8KMoLrJqLFyqvCKJrp8WlJsmqYaS
V69ZZNVuiqxeUKc/N+4nqox6FHEfS4+jfdz6R3ydMWb/JKolljucWQo4CeMyhK5z6XqpVPvy70HK
Ly5X6lBtOH1yDpXvNvLdJth23n4T9DyLnSeIb5pdJIhf0gj1/BGfIz0+0sMQnt23dm4qBPvpzyTn
ujI+6fdmcX52J/3uTZPoEXRyF/yWOsqzk8aetPv+ds/0f92TxBI32LeXic+93V1eFCdLGga+hY6X
Jxnkg/t5tcq3jx4HsWbORt+ot0P6i4vA2yqtTnPIo3Dc6taz28FeVeNm lF+cAf2rhG8V1Wps1do4
bmW61ny/Mor39mK2qUnvlGWua6pZ7Jrq+ftp/jVOUk/Nv8bJHs//AmL2uXI=
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 1 2 13844
STR:
SVN: $Id: sqlparser.lib.php 10432 2007-06-11 17:00:56Z lem9 $
MySQL: 5.0.37-community-nt
USR OS, AGENT, VER: Mac SAFARI 5.0.525
PMA: 2.10.3
PHP VER,OS: 5.2.2 WINNT
LANG: en-utf-8
SQL: USE [ZAIDTesting]
GO
/****** Object: User [ZAIDTesting] Script Date: 07/16/2008 15:38:15 ******/
CREATE USER [ZAIDTesting] FOR LOGIN [ZAIDTesting] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: User [AjayKumar] Script Date: 07/16/2008 15:38:15 ******/
CREATE USER [AjayKumar] FOR LOGIN [AjayKumar] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: Table [dbo].[SR_Artists] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Artists](
[ArID] [decimal](18, 0) NOT NULL,
[AName] [varchar](150) NOT NULL,
[ADetails] [text] NULL,
[AImage] [varchar](50) NULL,
[AOrder] [decimal](18, 0) NULL,
[AEnabled] [decimal](18, 0) NULL,
[ArLogo] [varchar](200) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_Albums] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Albums](
[AID] [decimal](18, 0) NOT NULL,
[ArID] [decimal](18, 0) NULL,
[ATitle] [nvarchar](150) NOT NULL,
[AArtist] [nvarchar](150) NULL,
[DICPN] [varchar](50) NOT NULL,
[PType] [varchar](50) NULL,
[AGenre] [varchar](80) NULL,
[FolderName] [varchar](50) NULL,
[AImage] [varchar](50) NULL,
[AOrder] [int] NULL,
[AEnabled] [int] NULL,
[Adetails] [text] NULL,
[AReleaseDate] [datetime] NULL,
[ARImage] [varchar](70) NULL,
[CC] [varchar](100) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_Options] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Options](
[OID] [decimal](18, 0) NOT NULL,
[TID] [decimal](18, 0) NOT NULL,
[OName] [varchar](40) NOT NULL,
[OOrder] [decimal](18, 0) NULL,
[OEnabled] [int] NULL,
[ProductID] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_Countries] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Countries](
[Sno] [decimal](18, 0) NOT NULL,
[CountryNames] [varchar](100) NOT NULL,
[CountryCode] [varchar](5) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_Tracks] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_Tracks](
[TID] [decimal](18, 0) NOT NULL,
[AID] [decimal](18, 0) NOT NULL,
[TTitle] [varchar](350) NOT NULL,
[TArtist] [varchar](150) NULL,
[TEID] [varchar](50) NULL,
[ISRC] [varchar](50) NULL,
[Duration] [varchar](50) NULL,
[Price] [float] NOT NULL,
[Currency] [varchar](50) NULL,
[FullTrack] [varchar](100) NULL,
[Clip] [varchar](100) NULL,
[Ext] [varchar](10) NULL,
[FType] [varchar](50) NULL,
[BitRate] [int] NULL,
[TLang] [varchar](150) NULL,
[TGenre] [varchar](70) NULL,
[ReleaseDate] [datetime] NULL,
[SSale] [int] NULL,
[TOrder] [int] NULL,
[TEnabled] [int] NULL,
[TType] [varchar](20) NULL,
[Category] [varchar](50) NULL,
[TDetails] [text] NULL,
[TImage] [varchar](50) NULL,
[ProductID] [varchar](30) NULL,
[SCode] [varchar](30) NULL,
[SMSCode] [varchar](20) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SR_xChangeRate] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_xChangeRate](
[SN] [decimal](18, 0) NOT NULL,
[Currency] [varchar](20) NOT NULL,
[ExRate] [float] NOT NULL,
[Symbol] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_xChangeRate] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_xChangeRate](
[SN] [decimal](18, 0) NOT NULL,
[Currency] [varchar](20) NOT NULL,
[ExRate] [float] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_LiteTrack] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_LiteTrack](
[TrackID] [decimal](18, 0) NOT NULL,
[ArID] [decimal](5, 0) NULL,
[TrackName] [varchar](300) NULL,
[TrackOnly] [varchar](300) NULL,
[Price] [float] NULL,
[TrackType] [varchar](5) NULL,
[Clipstat] [varchar](10) NULL,
[ISRC] [varchar](50) NULL,
[Category] [varchar](50) NULL,
[TrType] [varchar](20) NULL,
[TrOrder] [decimal](18, 0) NULL,
[RDate] [datetime] NULL,
[PreOrder] [varchar](20) NULL,
[Enabled] [int] NULL,
[tsize] [varchar](50) NULL,
[trackStat] [varchar](100) NULL,
[clpType] [varchar](100) NULL,
[ClipName] [varchar](100) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_MainArtist] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_MainArtist](
[MainArtistID] [decimal](18, 0) NOT NULL,
[MainArtistName] [varchar](300) NULL,
[MainArtistOrder] [decimal](18, 0) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_Artist] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_Artist](
[ArID] [decimal](18, 0) NOT NULL,
[ArName] [varchar](300) NULL,
[ArNameBack] [varchar](300) NULL,
[ArOrder] [decimal](18, 0) NULL,
[ImgLogo] [varchar](100) NULL,
[ArDetails] [varchar](4000) NULL,
[MArtistID] [decimal](18, 0) NULL,
[Enabled] [int] NULL,
[ClipFolder] [varchar](100) NULL,
[bytype] [varchar](50) NULL,
[rdate] [datetime] NULL,
[countries] [varchar](20) NULL,
[A_Price] [varchar](200) NULL,
[islatest] [varchar](20) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_LiteCart] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_LiteCart](
[CartID] [decimal](18, 0) NOT NULL,
[BuyID] [varchar](50) NULL,
[TrackID] [decimal](5, 0) NULL,
[TrackPrice] [float] NULL,
[BuyDate] [varchar](50) NULL,
[Postage] [float] NULL,
[Preorder] [varchar](20) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SG_Countries] Script Date: 07/16/2008 15:38:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SG_Countries](
[Sno] [decimal](18, 0) NOT NULL,
[CountryNames] [varchar](100) NOT NULL,
[CountryCode] [varchar](5) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
----END RAW----
SQL query:
USE [ZAIDTesting] GO /****** Object: User [ZAIDTesting] Script Date: 07/16/2008 15:38:15 ******/ CREATE USER [ZAIDTesting] FOR LOGIN [ZAIDTesting] WITH DEFAULT_SCHEMA=[dbo] GO /****** Object: User [AjayKumar] Script Date: 07/16/2008 15:38:15 ******/ CREATE USER [AjayKumar] FOR LOGIN [AjayKumar] WITH DEFAULT_SCHEMA=[dbo] GO /****** Object: Table [dbo].[SR_Artists] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Artists]( [ArID] [decimal](18, 0) NOT NULL, [AName] [varchar](150) NOT NULL, [ADetails] [text] NULL, [AImage] [varchar](50) NULL, [AOrder] [decimal](18, 0) NULL, [AEnabled] [decimal](18, 0) NULL, [ArLogo] [varchar](200) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_Albums] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Albums]( [AID] [decimal](18, 0) NOT NULL, [ArID] [decimal](18, 0) NULL, [ATitle] [nvarchar](150) NOT NULL, [AArtist] [nvarchar](150) NULL, [DICPN] [varchar](50) NOT NULL, [PType] [varchar](50) NULL, [AGenre] [varchar](80) NULL, [FolderName] [varchar](50) NULL, [AImage] [varchar](50) NULL, [AOrder] [int] NULL, [AEnabled] [int] NULL, [Adetails] [text] NULL, [AReleaseDate] [datetime] NULL, [ARImage] [varchar](70) NULL, [CC] [varchar](100) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_Options] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Options]( [OID] [decimal](18, 0) NOT NULL, [TID] [decimal](18, 0) NOT NULL, [OName] [varchar](40) NOT NULL, [OOrder] [decimal](18, 0) NULL, [OEnabled] [int] NULL, [ProductID] [varchar](10) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_Countries] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Countries]( [Sno] [decimal](18, 0) NOT NULL, [CountryNames] [varchar](100) NOT NULL, [CountryCode] [varchar](5) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_Tracks] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_Tracks]( [TID] [decimal](18, 0) NOT NULL, [AID] [decimal](18, 0) NOT NULL, [TTitle] [varchar](350) NOT NULL, [TArtist] [varchar](150) NULL, [TEID] [varchar](50) NULL, [ISRC] [varchar](50) NULL, [Duration] [varchar](50) NULL, [Price] [float] NOT NULL, [Currency] [varchar](50) NULL, [FullTrack] [varchar](100) NULL, [Clip] [varchar](100) NULL, [Ext] [varchar](10) NULL, [FType] [varchar](50) NULL, [BitRate] [int] NULL, [TLang] [varchar](150) NULL, [TGenre] [varchar](70) NULL, [ReleaseDate] [datetime] NULL, [SSale] [int] NULL, [TOrder] [int] NULL, [TEnabled] [int] NULL, [TType] [varchar](20) NULL, [Category] [varchar](50) NULL, [TDetails] [text] NULL, [TImage] [varchar](50) NULL, [ProductID] [varchar](30) NULL, [SCode] [varchar](30) NULL, [SMSCode] [varchar](20) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SR_xChangeRate] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SR_xChangeRate]( [SN] [decimal](18, 0) NOT NULL, [Currency] [varchar](20) NOT NULL, [ExRate] [float] NOT NULL, [Symbol] [varchar](10) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_xChangeRate] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_xChangeRate]( [SN] [decimal](18, 0) NOT NULL, [Currency] [varchar](20) NOT NULL, [ExRate] [float] NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_LiteTrack] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_LiteTrack]( [TrackID] [decimal](18, 0) NOT NULL, [ArID] [decimal](5, 0) NULL, [TrackName] [varchar](300) NULL, [TrackOnly] [varchar](300) NULL, [Price] [float] NULL, [TrackType] [varchar](5) NULL, [Clipstat] [varchar](10) NULL, [ISRC] [varchar](50) NULL, [Category] [varchar](50) NULL, [TrType] [varchar](20) NULL, [TrOrder] [decimal](18, 0) NULL, [RDate] [datetime] NULL, [PreOrder] [varchar](20) NULL, [Enabled] [int] NULL, [tsize] [varchar](50) NULL, [trackStat] [varchar](100) NULL, [clpType] [varchar](100) NULL, [ClipName] [varchar](100) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_MainArtist] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_MainArtist]( [MainArtistID] [decimal](18, 0) NOT NULL, [MainArtistName] [varchar](300) NULL, [MainArtistOrder] [decimal](18, 0) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_Artist] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_Artist]( [ArID] [decimal](18, 0) NOT NULL, [ArName] [varchar](300) NULL, [ArNameBack] [varchar](300) NULL, [ArOrder] [decimal](18, 0) NULL, [ImgLogo] [varchar](100) NULL, [ArDetails] [varchar](4000) NULL, [MArtistID] [decimal](18, 0) NULL, [Enabled] [int] NULL, [ClipFolder] [varchar](100) NULL, [bytype] [varchar](50) NULL, [rdate] [datetime] NULL, [countries] [varchar](20) NULL, [A_Price] [varchar](200) NULL, [islatest] [varchar](20) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_LiteCart] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_LiteCart]( [CartID] [decimal](18, 0) NOT NULL, [BuyID] [varchar](50) NULL, [TrackID] [decimal](5, 0) NULL, [TrackPrice] [float] NULL, [BuyDate] [varchar](50) NULL, [Postage] [float] NULL, [Preorder] [varchar](20) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SG_Countries] Script Date: 07/16/2008 15:38:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SG_Countries]( [Sno] [decimal](18, 0) NOT NULL, [CountryNames] [varchar](100) NOT NULL, [CountryCode] [varchar](5) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO
MySQL said:
#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 'U' at line 1
i used compatibility mode here with no joy...
Powered by vBulletin® Version 4.1.10 Copyright © 2012 vBulletin Solutions, Inc. All rights reserved.