[HELP] Learning SQL - Printable Version

[HELP] Learning SQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Other (https://sampforum.blast.hk/forumdisplay.php?fid=7)
+--- Forum: Everything and Nothing (https://sampforum.blast.hk/forumdisplay.php?fid=23)
+--- Thread: [HELP] Learning SQL (/showthread.php?tid=625558)

[HELP] Learning SQL - Eoussama - 03.01.2017

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

Re: [HELP] Learning SQL - Sanady - 03.01.2017

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.

Re: [HELP] Learning SQL - Eoussama - 03.01.2017

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

Re: [HELP] Learning SQL - Variable™ - 03.01.2017

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

Re: [HELP] Learning SQL - Lordzy - 03.01.2017

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.

Re: [HELP] Learning SQL - Eoussama - 03.01.2017

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?

Re: [HELP] Learning SQL - saffierr - 03.01.2017

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

Re: [HELP] Learning SQL - Lordzy - 04.01.2017

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