Jump to content

Questions about MYSQL


Hero192

Recommended Posts

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

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 :D:D

Link to comment

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...