[Mobtiesgangsa]

Quote:

Originally Posted by Ramboi I'm planning on expanding my knowledge with less learning, so when I want to move to something harder such as MySQL I would at least have the basic knowledge because going to the hardest thing with 0 knowledge would be a challenge.

No knowledge has expanded with less learning that way is un-ballanced

similarity between MySQL and SQLite is this example i will show to you a small database creating on pawn

MySQL
------------
a exapmle how to create a table inside a database with 4 colums

Код:

CREATE TABLE IF NOT EXISTS `Users` (`id` int(11) AUTO_INCREMENT, `Name` varchar(25), `Password`varchar(128), `ip` varchar(18), PRIMARY KEY (`id`))

-----------
-----------

SQLite
-----------

a example how to create a table inside a database with 4 colums

Код:

CREATE TABLE IF NOT EXISTS `Users` (`ID` INTEGER PRIMARY KEY AUTOINCREMENT, `Name` VARCHAR(25), `Password` VARCHAR(128), `Ip` VARCHAR(18))

SQLite is built-in to the SA-MP you already have the include in your pawno directory and if you include #include <a_samp> other inclaudes are alleardy included, the database will create on server start dir/scriptfiles.

MySQL is a third party include to expand data read/writes/loads the Developer/contributer is BlueG for MySQL R41-4 release
this requier a web based server like phpmyadmin to connect to in order for you to create <yourdatabase>.sql inport/export to your webserver

i could do more expaination but that is all i can say for now this is also explained for you Ramboi