MySQL help. - Printable Version

MySQL help. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL help. (/showthread.php?tid=98695)

MySQL help. - Landon - 22.09.2009

Good day SAMP'ers,

I am now having a script, but when I try to host the .sql I get the following error:

Код:

SQL-query:

-- ----------------------------
-- Table structure for baseproducts
-- ----------------------------
CREATE TABLE `baseproducts` Roxt(
`prodid` int( 11 ) NOT NULL ,
`name` varchar( 15 ) COLLATE latin1_general_ci NOT NULL ,
`typeid` int( 11 ) NOT NULL ,
`typeid2` int( 11 ) NOT NULL ,
`baseprice` int( 11 ) NOT NULL ,
`unitquantity` int( 11 ) NOT NULL ,
`maxallowedshop` int( 11 ) NOT NULL ,
`currentprice` int( 11 ) NOT NULL ,
`priceflex` int( 11 ) NOT NULL ,
`available` int( 11 ) NOT NULL ,
`genpertick` int( 11 ) NOT NULL ,
`maxfactory` int( 11 ) NOT NULL ,
`maxallowedtruck` int( 11 ) NOT NULL ,
PRIMARY KEY ( `prodid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci;

MySQL retourneerde: Documentatie
#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 'Roxt (
 `prodid` int(11) NOT NULL,
 `name` varchar(15) collate latin1_genera' at line 1

Does anyone know how to fix this? I am prepaired to pay the one who know how to fix this.

Thanks.

Re: MySQL help. - Peter_Corneile - 22.09.2009

As far as i am concerned , i dont even know the 'M' of MySQL ..

Re: MySQL help. - brett7 - 22.09.2009

SQL is the standard the "My" bit is just a trade mark ^

Re: MySQL help. - Peter_Corneile - 22.09.2009

I have seen many people using MySQL but i never thought of or did use it .. I just want to stick with PAWNO

Re: MySQL help. - Silent314 - 22.09.2009

Remove the "Roxt" from " CREATE TABLE `baseproducts` Roxt( " and try, so it's:

Код:

CREATE TABLE `baseproducts` (

Re: MySQL help. - dougbrowne - 22.09.2009

Quote:

Originally Posted by ►►►Peter Corneile◄◄◄

I have seen many people using MySQL but i never thought of or did use it .. I just want to stick with PAWNO

PAWNO is a programming language, MySQL is a database software. PAWNO = The gamemode code, MYSQL = Where the gamemode would store it's data. MySQL is very good for servers which require a lot of dynamic data to be stored like some RP scripts.

Re: MySQL help. - Peter_Corneile - 22.09.2009

Quote:

Originally Posted by dougbrowne

Quote:

Originally Posted by ►►►Peter Corneile◄◄◄

I have seen many people using MySQL but i never thought of or did use it .. I just want to stick with PAWNO

Ahh kk .. But still i dont know anything about it xD

Re: MySQL help. - Landon - 22.09.2009

Quote:

Originally Posted by Gabe

Remove the "Roxt" from " CREATE TABLE `baseproducts` Roxt( " and try, so it's:

Код:

CREATE TABLE `baseproducts` (

When I do that I get the next message:

Код:

SQL-query:

INSERT INTO `groups_permissions`
VALUES (
'3', '1', '3'sdad2241
);

MySQL retourneerde: Documentatie
#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 'sdad2241)' at line 1

Re: MySQL help. - Silent314 - 22.09.2009

It looks like you have a bunch of text that just shouldn't be there. Remove "sdad2241" from that line.