[Eoussama]

Hello, guys, so I decided to switch to SQL for obvious reasons, well, the fact that I had no knowledge in SQL whatsoever, I spent yesterday learning the Basics on a couple of websites, like SELECT UPDATE... What is a Querry, database.... So, at this point I'm kinda confused what should I learn next, my aim in learning SQL was to be able to make SQL based samp server, so what tutorials should I consider checking next?

I found this Wikipedia page here; https://sampwiki.blast.hk/wiki/MySQL
I don't know if that would help,

plus, I would appreciate it if you recommend me a good IDE (text editor) that I can use for SQL, (by the way would it work on Sublim text 3)?

Thanks in advance

[Sanady]

Hey first question, while I was reading this post, I don`t know what you want to learn SQL or MySQL because there are differences. About IDE, Sublime Text 3 is pretty good for this kind of scripting.

[Eoussama]

Quote:

Originally Posted by Sanady Hey first question, while I was reading this post, I don`t know what you want to learn SQL or MySQL because there are differences. About IDE, Sublime Text 3 is pretty good for this kind of scripting.

yeah, I installed the SQL tools plugin for sublim text 3, but I find it confusing to set up connection, I'd appreciate it if I get some help

[Variable™]

Well. If you are new to the SA:MP MySQL coding you'll have to start off reading https://github.com/pBlueG/SA-MP-MySQ...stem-cache.pwn

[Lordzy]

Be familiar with SQL language first. MySQL is almost similar to SQL, except it has more features and few differences but most of them are very easy to be understood. There are tutorials here which explains implementing SQLite or MySQL in SA-MP.

SQL Tutorial - http://www.w3schools.com/sql/
MySQL Tutorial - https://www.tutorialspoint.com/mysql/
Using SQLite on SA-MP - https://sampforum.blast.hk/showthread.php?tid=449536
Search for others, there are plenty.

[Eoussama]

Quote:

Originally Posted by Lordzy Be familiar with SQL language first. MySQL is almost similar to SQL, except it has more features and few differences but most of them are very easy to be understood. There are tutorials here which explains implementing SQLite or MySQL in SA-MP. SQL Tutorial - http://www.w3schools.com/sql/ MySQL Tutorial - https://www.tutorialspoint.com/mysql/ Using SQLite on SA-MP - https://sampforum.blast.hk/showthread.php?tid=449536 Search for others, there are plenty.

thanks, how to set up mysql connection to a database?

[saffierr]

Best tutorial in my opinion is Register/Login system from MySQL.

[Lordzy]

Quote:

Originally Posted by Eoussama thanks, how to set up mysql connection to a database?

This is an old tutorial but it lets you know to set up wamp server - https://sampforum.blast.hk/showthread.php?tid=129183
MySQL registration system (The first part contains setting up MySQL connection) - https://sampforum.blast.hk/showthread.php?tid=485633