Database

[Natan Beckman]

Help execute in database:

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 11389

And last:

Error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemtype = 11389' at line 1

 

[Belthazor]

try

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = "11389"
DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = '11389'

 

[Natan Beckman]

no =x

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemtype = '11389'' at line 1
DELETE FROM player_depotitems,
player_items,
tile_items WHERE itemtype = '11389'

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemtype = "11389"' at line 1
DELETE FROM player_depotitems,
player_items,
tile_items WHERE itemtype = "11389"

 

[Belthazor]

try this

DELETE FROM 'player_depotitems', 'player_items', 'tile_items' WHERE 'itemtype' = 11389

 

[Natan Beckman]

SELECT *
FROM `player_depotitems`
WHERE `itemtype` =2472

 

[Belthazor]

SELECT *
FROM `player_depotitems`
WHERE `itemtype` =2472

the outher one worked?

and what u want to do with this?

 

[Natan Beckman]

found

 

[Belthazor]

huh? k
dunno what u meen but anyway goodluck farther

 

[Natan Beckman]

Thanks

 

[Chris]

To delete rows from multiple tables, you have to type the tables twice (in the same order). Once between DELETE and FROM, and once after FROM. You might also have to join the tables together.

 

[Belthazor]

To delete items from multiple tables at once you have to repeat the tables.

DELETE `player_depotitems`, `player_items`, `tile_items` FROM `player_depotitems`, `player_items`, `tile_items` WHERE `itemtype` = 11389;

Also make sure the "itemtype" field exists in all three of the tables.

huh?

DELETE FROM `player_depotitems`, `player_items`, `tile_items` WHERE `itemtype` = 11389;

schuld't it be like this?

 

[Chris]

Actually, no. When deleting from MULTIPLE tables, you have to type it twice.

 

[Belthazor]

hmm never done

i always use it once not twice and it works o,O

btw cute avatar

 

[Chris]

Thank you, I like it as well!

Any way, here's a few quick pointers for you.

DELETE FROM `player_depotitems`, `player_items` WHERE `itemtype` = 1234;

Gives you a regular SQL error.

DELETE `player_depotitems`, `player_items` FROM  `player_depotitems`, `player_items` WHERE `itemtype` = 1234;

Gives you an error about `itemtype` being ambiguous.

DELETE `player_depotitems`, `player_items` FROM  `player_depotitems`, `player_items` WHERE `player_items`.`itemtype` = 1234;

Works as expected.

 

[Natan Beckman]

I think it works.
More Meaning:
1.234
1 = how many?
Id = 234?

 

[Chris]

Err.. what?