MYSQL- Learning It - 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: MYSQL- Learning It (/showthread.php?tid=587856)

---

MYSQL- Learning It - Roberto80 - 03.09.2015

Hey,so i'm looking to learn MySQL,mmm its so hard,i found this:https://sampwiki.blast.hk/wiki/MySQL
But its so hard :/ can someone PM me how to start?
Thanks in advance (sorry if wrong section ).

---

Re: MYSQL- Learning It - iZN - 03.09.2015

Useful links that are required to study and setup MySQL for a SA-MP server:

• Latest release version of the SA-MP MySQL plugin on BlueG's Github repo
• Official MySQL Documentation/References
• A tutorial by newbienoob to get the basic idea how a registration system can be made with Whirlpool hashing and threaded queries (includes MySQL setup information for newbies like you)
• Another tutorial like newbienoob's but it's written by Overhaul and is up-to-date
• Outdated tutorial by AndreT but still clears how to work with cache and threaded queries
• SA-MP Wiki page for BlueG & maddinat0r's MySQL Plugin R39+
• MySQL Plugin thread

Other tutorials which are written by Vince:
(I wouldn't recommend going through these tutorials unless you've learned abit basic about MySQL because most of them are pretty advance for a newbie)

• Table structure and foreign keys
• Saving weapon data
• GeoIP and handling rangebans with MySQL

Want more MySQL related tutorials? You can simply ****** it, there are millions of tutorials available on the internet.

---

Re: MYSQL- Learning It - DRIFT_HUNTER - 03.09.2015

http://www.w3schools.com/sql/
That is just sql (MySql uses sql syntax), and it doesnt explain how to handle results in pawn or any other language/software/whatever...

If you just want to learn about some modern databases than i suggest you to check out MongoDB, its one of the uprising no-sql databases.

---

Re: MYSQL- Learning It - Abagail - 03.09.2015

MySQL isn't just a mere plugin. The plugin only supports connection and interaction with the database, SQL is it's entire own language just as PAWN is a language and isn't "SA-MP"(it's merely what's used to compile and write scripts for use within SA-MP).

---

Re: MYSQL- Learning It - iZN - 03.09.2015

Stop recommending W3Schools! It's terrible.

---

Re: MYSQL- Learning It - Extremo - 06.09.2015

Why would W3Schools be terrible?? I've been working in the field for ages now and I have frequently used it as a documentation tool? It doesn't make you an expert, but it certainly covers the basics? I really don't see what is so wrong with it.

---

Re: MYSQL- Learning It - iZN - 06.09.2015

If you're working in the fields for ages now, I'm really disappointment if you haven't really noticed the documentation of W3Schools. I don't mind the really basic stuff, but what if there are BETTER sites like MDN, why visit W3Schools because it's appearing on the top search result?

W3Schools is quite famous for giving out wrong and outdated information (especially the example code), mainly common among the institutes, they all recommend W3Schools for reference which is wrong. I always recommend MDN for web development because I know myself that once the base of reference is good, you can be a good developer otherwise you'll end up with an incomplete and outdated information. Don't rely on W3Schools if you wanted to be a good developer.

Need more answers? visit http://w3fools.com/ or try asking over at stackoverflow.

---

Re: MYSQL- Learning It - Giogimic - 12.09.2015

If it works for the very basic information he needs then i really don't see the issue.

---