SQL Query to insert items in all accounts in storage

[Fily]

Hi,

I want to insert an item to every account storage. What's the correct SQL Syntax to use? 

Item ID: 32135

Amount: 100

 

Thanks in advance

[Emistry]

you can try something like this.

INSERT INTO `storage` (`account_id`, `nameid`, `amount`)
	SELECT `account_id`, 32135, 100
	FROM `login`
	WHERE `account_id` > 1

it actually not a safe way with this query...

it required more query and checking to ensure its safe, for example

• duplicate item checking
• total amount of item in storage checking
• etc

tho, it would be much easier if the database was actually designed properly in the start, example the constraint for each keys...

Edited December 24, 2016 by Emistry