Hero192 Posted August 23, 2015 Share Posted August 23, 2015 Hey guys, i think it's my time to start with MySQL, 1)What's the functions i need to knows? 2)If i created a Table where it gonna be saved, at a website? or at a folder/file? 3)Which one is good in saving datas, Mysql or Sqlite? what's the different between them. 4)Please if you know any good tutorial about Mysql post it, mysql not sqlite I hope someone of you know thess things and can give me some informations about these Questions. ~Thanks in advance. Link to comment
nasserdfdd Posted August 23, 2015 Share Posted August 23, 2015 firstly u need to know how to create a table with this line dbExec(sql, "CREATE TABLE IF NOT EXISTS adminpunish (id INT(11), admin TEXT, date INT(11) )"); so numbers = INT and text and alphabet's = TEXT secondly it is save on phpmyadmin or what ever u use if u use sqlite then it saved as .db in ur computer thirdly i prefer mysql forthly i don't know any good tutorial so sorry i cant help regards correct me if uam worng Link to comment
Stanley Sathler Posted August 23, 2015 Share Posted August 23, 2015 Hey NemoxHero, 1) If you mean about Multi Theft Auto functions, you can check them here. Otherwise, if you mean about MySQL itself, the queries aren't so different. 2) All data created by MySQL are saved into your computer. At least on Linux, they are saved on /var/lib/mysql directory. Databases are directories and, tables, are .rfm files (compiled, not readable by a simple cat command). You can read it using a MySQL Graphical Manager (I suggest MySQL Workbench). 3) Who's more faster? Maybe I am wrong, but, in my opinion, it's SQLite. Their communication ways are different and, as I can see, SQLite has a faster communication because it does not pass through a port, for example. 4) I know a great brazilian course, but since you can not speak portuguese (at least I think so), I can suggest to you MySQL Tutorial. I just don't know if it is the best tutorial. Link to comment
Hero192 Posted August 23, 2015 Author Share Posted August 23, 2015 Small Question, Mysql = SQL? or Sqlite = SQL Link to comment
Hero192 Posted August 23, 2015 Author Share Posted August 23, 2015 And,How to create Database? Link to comment
xeon17 Posted August 23, 2015 Share Posted August 23, 2015 I don't recommend you the MySQL module because it's outdated, you can check the list of MTA SQL functions here. About the speed of both, i also think that SQLite is faster, but i'm personally using MySQL which is better in my opinion.Here is a great tutorial about SQLite in MTA,the synax for MySQL and SQLite is almost the same so that shouldn't be a problem for you. NemoxHero said: And,How to create Database? On this page are many examples how you can connect to both databases (SQLite and MySQL) Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now