Need SQL help

[seal]

Hi, im new in lua programming and need some help in executesql using.

Ok, i can create tables and rows but i cant put in values, so how can i put values into the database?

E.G: playerposition, charactername.

And when an account is already in the table how can is update its data?

Thank you for your answers

[golanu21]

addEventHandler("onPlayerJoin", getRootElement(), 
function () 
zombie_db = connectToDB() 
x, y, z = getElementPosition(source) 
dbExec( zombie_db, "INSERT INTO characters (nume, model, health, posx, posy, posz) VALUES (?,?,?,?,?,?)", getPlayerName(source), getElementModel(source), getElementHealth(source), x, y, z ) 
end) 

take an example

Edited December 12, 2013 by Guest

[Castillo]

You can execute INSERT queries to add rows with values, and also UPDATE queries to update rows.

[Desaster]

here are the most useful functions for sql

https://wiki.multitheftauto.com/wiki/ExecuteSQLQuery

to update data use UPDATE and to put values use INSERT INTO ^^

[seal]

thanks your comments, but how do the sql knows in which line should it update?

e.g:

id name money

1 John 123

2 Max 50

i call update function but how can i update max's values, instead e.g john's values?

[Renkon]

If you want to use UPDATE You can use WHERE statement

WHERE name = 'John'

WHERE id = 1

[TAPL]

Useful website.

http://www.w3schools.com/sql/

[Sasu]

You can get more information here: http://www.w3schools.com/sql/sql_where.asp

[seal]

well, i know how simple SQL query works, but how can i use "where" in MTA?

[pa3ck]

If you want to use UPDATE You can use WHERE statement

WHERE name = 'John'

WHERE id = 1

dbExec(connection,"UPDATE character SET name = ? WHERE id = ?", getPlayerName(source), accountID) 

accountID is the account, which you want to update