[MySql] How to make UPDATE to create a row, instead of doing nothing if the row doesnt exist.

Linear Mode

Mauzen
High-roller

Posts: 4,878
Threads: 85
Joined: Jun 2007
Reputation: 0

01.10.2013, 23:55

Search for "INSERT … ON DUPLICATE KEY UPDATE"
This one either creates a new row with the given data, or updates the existing one. Exactly what youre looking for I guess.

Find

« Next Oldest | Next Newest »

Messages In This Thread

[MySql] How to make UPDATE to create a row, instead of doing nothing if the row doesnt exist. - by Unri - 01.10.2013, 20:40

Re: [MySql] How to make UPDATE to create a row, instead of doing nothing if the row doesnt exist. - by overflow - 01.10.2013, 20:54

Re: [MySql] How to make UPDATE to create a row, instead of doing nothing if the row doesnt exist. - by Unri - 01.10.2013, 21:17

Re: [MySql] How to make UPDATE to create a row, instead of doing nothing if the row doesnt exist. - by Mauzen - 01.10.2013, 23:55

View a Printable Version

Forum Jump:

Users browsing this thread: 1 Guest(s)

Login
Username:
Password:	Lost Password?
	Remember me