SQL query statements question
#4

Quote:
Originally Posted by Meller
Посмотреть сообщение
It is, but you do realize what SQL stands for?
Structured Query Language, I've never said I can SQL by 100%. It's a big difference by a language and scripting.

The language describes how the structure should be, you do also realize that this differs so much by each language?
And you do realize scripting is jsut writing the structure?


Should I be able to know every single damn structure within the language because I've used it a few times? No.
Wikipedia people....

actually Mysql is more simpler than any other saving system (as SAVING system)

the base functions are

CREATE TABLE `` (colunm(type(size)), ..)
SELECT * FROM `` WHERE `` = ''
DELETE * FROM `` WHERE `` = ''
INSERT INTO `` () VALUES ()
UPDATE `` SET `` = '', ...

that so simple, you don't have even to think... (that's the functions needed on pawn ^^)
there some others functions such: ALTER, CREATE DATABASE... etc

in your case you don't need to use mysql_tquery, you can format it from the start, by using mysql_format (`%e` for espace) and use mysql_query directly

PHP код:
INSERT INTO player_stats SET (idnameetcVALUES (1'Meller''etc etc'
this won't work, you have an error in your query after playser_stats. you are loading stats, if you have a brain (not insulting nor disrespecting you) you will know that "SET" not needed, and keep on mind that querys aren't a pawn functions, they are like 'commands' so you don't need to put a ";" in end

MySQL is so simple (for me!), there's many query tutorials in the MySQL v8 official website.

Have fun :P


EDIT: you should fetch the values after excuting the query! using cache_get_value_name!

check MySQL R40+ Tutorials, im sure you will understand well!
Reply


Messages In This Thread
SQL query statements question - by Meller - 09.09.2017, 15:02
Re: SQL query statements question - by Paulice - 09.09.2017, 15:11
Re: SQL query statements question - by Meller - 09.09.2017, 15:17
Re: SQL query statements question - by Xeon™ - 09.09.2017, 15:34
Re: SQL query statements question - by Kaperstone - 09.09.2017, 15:36
Re: SQL query statements question - by Meller - 09.09.2017, 15:54
Re: SQL query statements question - by Vince - 09.09.2017, 16:19

Forum Jump:


Users browsing this thread: 1 Guest(s)