12 lines
688 B
Batchfile
12 lines
688 B
Batchfile
SET path=%PATH%;D:\Programs\MariaDB\bin;
|
|
|
|
SET dbUser=root
|
|
SET dbPassword=password
|
|
|
|
SET userId=1
|
|
SET amount=999
|
|
|
|
mariadb -v -u%dbUser% -p%dbPassword% -D aime -e "SELECT * from chuni_item_item WHERE itemKind = 5; UPDATE chuni_item_item SET stock = %amount% WHERE itemId = 8000 AND itemKind = 5 AND user = %userId%; UPDATE chuni_item_item SET stock = %amount% WHERE itemId = 8010 AND itemKind = 5 AND user = %userId%; UPDATE chuni_item_item SET stock = %amount% WHERE itemId = 8020 AND itemKind = 5 AND user = %userId%; UPDATE chuni_item_item SET stock = %amount% WHERE itemId = 8030 AND itemKind = 5 AND user = %userId%; SELECT * from chuni_item_item WHERE itemKind = 5;"
|
|
|
|
|
|
pause |