I'm trying to add multiple rows using 'replace into' , but its updating one row.
REPLACE INTO user_balance (user_id,acc_type,currency,balance,enable_deposit, enable_withdrawal,pending_balance,update_ip) VALUES (NEW.id,1,'USD',0,1,0,0,NEW.ip_address), (NEW.id,1,'GBP',0,1,0,0,NEW.ip_address), (NEW.id,1,'EUR',0,1,0,0,NEW.ip_address), (NEW.id,1,'BTC',0,1,0,0,NEW.ip_address);
Is this right, the way am doing it?
PS: am employing a trigger to update the balance table whenever an user is created in the users table. It works well with if I replace one row, for multiple rows, it updates only the last values.