INSERT IGNORE is 'the' SQL solution,
as you know and mention.
I dont know Rails but this is not MySQL / SQL / Database issue but more a
specific framework one so the solution depends on it.
You can also make some higher level programming workaround.
Claudio
On Jan 4, 2012 6:46 AM, "KK Everest" wr
Hola,
At the first look, it looks like one of the following will work:
1.Use MySQL's MERGE statement (that is, INSERT with ON DUPLICATE KEY).
What really happens, when the two transactions execute SELECT followed by an
INSERT, there is no way to hold off SELECT. The natural instinct is
Hi all,
Can anyone help me with the problem explained here please:
http://www.reddit.com/r/mysql/comments/o256m/a_transactional_problem/
Thanks in advance.
Jan, thanks so much for taking the time with me.
I hesitate to spend much of everyone's inbox space on this as it is getting off
topic, and I am newbie enough with all things CL that folks will tire of me
before I am near ready to complete the thread.
Like it took me a bit of time to think/rese
2012/01/02 15:47 +0530, Adarsh Sharma
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
line 31 of what? Likly it would be helpful to show it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql