[qmnty]

I make an TABLE like this structure...

* playervehicles with FOREIGN KEY playerID references from playerdata, have 5 rows each playerID
* vehiclemods with FOREIGN KEY playerID references from playerdata, and vehicleID references from playervehicles, have 15 rows each vehicleID, total vehiclemods rows 15 rows * 5 vehicleID = 75 rows each playerID
* vehicletoys with FOREIGN KEY playerID references from playerdata, and vehicleID references from playervehicles,
have 10 rows each vehicleID, total vehicletoys rows 10 rows * 5 vehicleID = 50 rows each playerID

Question 1:

Where is better loader?

Code 1

Single loader query like this

pawn Код:

SELECT * FROM playerdata 
INNER JOIN playervehicles ON playerdata.playerID = 3
INNER JOIN vehiclemods ON playerdata.playerID = 3
INNER JOIN vehicletoys ON playerdata.playerID = 3;

or

Multiple query loader?

pawn Код:

SELECT * FROM playerdata WHERE playerID = 3;
SELECT * FROM playervehicles WHERE playerID = 3;
SELECT * FROM vehiclemods WHERE playerID = 3;
SELECT * FROM vehicletoys WHERE playerID = 3;

Question 2:

How to UPDATE the multiple row data..

But in pawno script, the string only limited 10000 characters....

Thanks...