R> SQL

[Jhosef]

i want to request a sql

i want to put this item to all account

20048 is the item id

in there inventory

using my database

[Fluffle Puff]

INSERT INTO `inventory` (account_id, nameid, amount, identify) SELECT account_id, 20048, 1, 1 FROM login WHERE sex!='S' AND state=0;

[Jhosef]

@alexandria

the sql you made is not working

i want in all Account will have in the inventory this Item 20048

20048 is the itemid not account_id