My SQL database help?

when i try to run it under query it gives me an error

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 'DATABASE COLLATION "Latin1_General" CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREAT' at line 1

can anyone modify my sql info so that it doesnt give me an error when trying todo this

the MYSQL version is 5.0.75

here is the information in the file

SET DATABASE COLLATION "Latin1_General"

CREATE SCHEMA PUBLIC AUTHORIZATION DBA

CREATE CACHED TABLE "Items"("ID" INTEGER NOT NULL PRIMARY KEY,"Name" VARCHAR(50),"Type" VARCHAR(50),"CategoryID" INTEGER,"Info" LONGVARCHAR)

CREATE USER SA PASSWORD ""

GRANT DBA TO SA

SET WRITE_DELAY 60

SET SCHEMA PUBLIC

INSERT INTO "Items" VALUES(0,'ThinkPad T60','Computer',1,'Intel Core 2, ATI Graphics, Windows Vista Ultimate')

INSERT INTO "Items" VALUES(1,'Dell Inspiron 1501','Computer',2,'AMD processor, Windows 7 Ultimate')

INSERT INTO "Items" VALUES(2,'Dell Inspiron 1501','Computer',21,'AMD Processor, Windows Vista Home Premium')

INSERT INTO "Items" VALUES(3,'MSI Wind U100','Computer',3,'Intel Atom, Mac OS X 10.5, netbook')

INSERT INTO "Items" VALUES(4,'40GB WD HDD','computer Part',1,'IDE Drive')

INSERT INTO "Items" VALUES(5,'320GB WD HDD','Computer Part',2,'SATA')

INSERT INTO "Items" VALUES(6,'Broadcom LAN Card','Computer Part',3,'Unknown Connector, Mabye PCI')

INSERT INTO "Items" VALUES(7,'iPod Touch','Mobile',1,'8GB, IG')

INSERT INTO "Items" VALUES(8,'iPod Video','Mobile',2,'30GB, 5G')

INSERT INTO "Items" VALUES(9,'Blackberry 8830 WE','Mobile',3,'World Edition, Verizon, Silver')

INSERT INTO "Items" VALUES(10,'LG ENV','Mobile',4,'Green, Verizon')

INSERT INTO "Items" VALUES(11,'LG ENV3','Mobile',5,'Slate Blue, Verizon')

INSERT INTO "Items" VALUES(12,'Samsung Glyde','Mobile',6,'Black, Touchscreen, slide out keyboard, Verizon')

INSERT INTO "Items" VALUES(13,'Logitech MX1000 Mouse','Accesories',1,'Wireless Mouse, Includes Reciver')

INSERT INTO "Items" VALUES(14,'Logitech Quickcam Fusion','Accesories',2,'Webcam')

INSERT INTO "Items" VALUES(15,'HP Wireless Keyboard','Accesories',3,'Keyboard with reciever, media and volume controls')

INSERT INTO "Items" VALUES(16,'Dell E773c Display','Accesories',4,'Moniter')

INSERT INTO "Items" VALUES(17,'Nintendo DS','Gaming',1,'Original System, in peices, Silver')

INSERT INTO "Items" VALUES(18,'Nintendo DS Lite','Gaming',2,'DS, Black revision one, black')

INSERT INTO "Items" VALUES(19,'Nintendo Gamecube','Gaming',3,'Limited Edition Silver')

INSERT INTO "Items" VALUES(20,'Nintendo GameBoy','Gaming',4,'Original Hardware, no longer works')

INSERT INTO "Items" VALUES(21,'Nintendo GameBoy Color','Gaming',5,'Original Gameboy Color, Purple')

INSERT INTO "Items" VALUES(22,'Nintendo GameBoy Advance','Gaming',6,'Original Gameboy Advance, Purple')

INSERT INTO "Items" VALUES(23,'Nintendo GameBoy Advance SP','Gaming',7,'Original GBA SP, Silver, Still Working')

INSERT INTO "Items" VALUES(24,'Wii','Gaming',8,'Original Nintendo Wii, White')

INSERT INTO "Items" VALUES(25,'Xbox','Gaming',9,'Original Xbox original, from launch, working, black')

INSERT INTO "Items" VALUES(26,'Xbox 360','Gaming',10,'Original from launch, White 20GB HDD')

INSERT INTO "Items" VALUES(27,'Xbox 360 Elite','Gaming',11,'Xbox 360 Elite, 160GB HDD, Black')

INSERT INTO "Items" VALUES(28,'PS2','Gaming',12,'Original PS2, Painted, Missing Bottom half of system')

INSERT INTO "Items" VALUES(29,'Xbox 360 Controller(2)','Gaming',13,'Black')

INSERT INTO "Items" VALUES(30,'PSP 1001','Gaming',14,'Black, original system, Needs new faceplate')

INSERT INTO "Items" VALUES(31,'PSP 2001','Gaming',15,'Black, Working condition')

INSERT INTO "Items" VALUES(32,'PSP 3001','Gaming',16,'Black, wor

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Try this

    CREATE DATABASE COLLATION CHARACTER SET latin1 COLLATE latin1_General;

    MHO

    careful with DB_NAME maybe COLLATION_DB (my .02)

  • 4 years ago

    the two version works so which you would be able to edit a sq. Server 2005 DB. all the destiny variations are be certain to be backward properly matched implying you are able to restoration a sq. 2005 database backup on sq. 2012 yet vice-versa isn't achieveable. word of a actuality that any discontinued syntax/keywords of sq. 2005will be nonetheless operational in sq. 2012 yet deprecated constructive aspects won't artwork. to word, sq. 2012 (Denali) continues to be in a CTP mode ( yet another call for Beta version)... -- In 'concepts'... Lonely Rogue.

Still have questions? Get your answers by asking now.