Database Help / Tutorial

[Maurize]

Hey. I want to learn everything about SQL Databases.

Can u all tell me what u know about them.

How to create them. How to use them. & ..

Would be very nice cause wiki isn´t a good tutorial at all

[bandi94]

you can use AccountData to for your Login/more script and its easy to store and get data from account

[Maurize]

hm the problem is: i make german server.

and everytime i use the default login system from mta a text appears saying "Wrong Password", or "You succesfully loggined" and so on.

So i need to create a sql database for example. But i want to learn how to store data in it. get the data and all this stuff

[Aibo]

MTA's account data uses SQLite DB, so you can use getAccountData/setAccountData functions to store data.

that is if you dont want to learn SQL yourself. and judging by you asking here and not perusing google to educate yourself — you dont.

teaching takes time and time is money. nobody here will waste their time to teach you "everything about SQL".

this is a scripting help section, not an IT school.

[Maurize]

i simply want to know for example how to insert single values.

for example: i have created a database: [ "Name", "Password", "Hours" ]

and i want insert or update only the last thing. what should i do in the spaces?

[Aibo]

you dont, you only specify fields (columns) that you want to update.