Forum
Search
Members
Help
Hello There, Guest!
Login
Username:
Password:
Lost Password?
Remember me
SA-MP Forums Archive
SA-MP Scripting and Plugins
Scripting Help
Threaded Mode
SQLite question
SapMan
Banned
Posts: 140
Threads: 35
Joined: Jul 2017
#1
24.12.2018, 14:34
Is it necessary to use these things ( INSERT INTO
`
PLAYERS
`
(
`
NAME
`
),
%q
)?
I mean those quotes "
``
" and "
%q
" instead of "
%s
"
Find
Reply
SyS
High-roller
Posts: 1,939
Threads: 11
Joined: Oct 2015
Reputation:
0
#2
24.12.2018, 14:45
If a column has same name as a reserved keyword in SQL or contains a space, you need to quote it using back ticks (
`
).
%q escapes special characters in order to avoid
SQL injection
Find
Reply
SapMan
Banned
Posts: 140
Threads: 35
Joined: Jul 2017
#3
24.12.2018, 15:14
Oh, it's fine. But, I do not understand the second, what do you mean by "special characters"? If it's the name, ip, password, how would you do it in this case?
Find
Reply
«
Next Oldest
|
Next Newest
»
View a Printable Version
Forum Jump:
Private Messages
User Control Panel
Who's Online
Search
Forum Home
SA-MP
-- News and Updates
-- General
-- Client Support
-- Bug Reports
-- Screenshots and Videos
SA-MP Server
-- Server Support
-- Server Advertisements
SA-MP Scripting and Plugins
-- Scripting Help
---- Tutorials
---- Discussion
---- Help Archive
-- Gamemode Scripts
-- Filterscripts
---- Includes
---- Tools and Files
---- Maps
-- Plugin Development
SA-MP DL Edition
-- SA-MP 0.3.DL
---- Model Releases
Other
-- Everything and Nothing
Non-English
-- Languages
---- Nederlands/Dutch
------ Scripting Showroom en Discussie
------ Off topic
---- Español/Spanish
------ Lanzamientos/Releases
---- Français/French
------ Showroom
---- Русский/Russian
------ Релизы/Releases
---- Português/Portuguese
------ Lançamentos/Releases
---- Română/Romanian
------ Salonul Scripturilor
---- Archive
Users browsing this thread: 1 Guest(s)
SA-MP Forums Archive
SA-MP Scripting and Plugins
Scripting Help