Hi, Guys
I think I got puzzled about the transaction isolation level and the
InnoDB consistent read implementation.
My understanding about the ANSI isolation level are:
1. READ-COMMITTED is to protect against Lost Updates, Dirty Reads, and
NOT protect against Nonrepeatable Reads and Phantoms.
2.
LIKE '%,8,%' ?
Probably not as elegant as you were looking for, but it works :)
Colin
On Monday 06 July 2009 21:31:51 Highviews wrote:
Hi,
I have numbers separated with commas saved into a TEXT Field, for example:
ROW1: 10,5,2,8,
ROW2: 2,7,9,65
ROW3: 99,100,55,10,88,
etc...
Now i
Hi,
I have the following table and two concurrent jobs,
trying to insert data into it. They deadlock on accessing an index which
shouldn't collide (the date is part of the index, and the jobs process
data for different dates).
This is mysql 5.0.51a-24+lenny1~bpo40+1-log.
Any ideas? Is this
Thats Great!
Thanks a Ton!
:)
On Mon, Jul 6, 2009 at 7:55 PM, Dan Nelson dnel...@allantgroup.com wrote:
In the last episode (Jul 06), avrom...@whyisitthat.com said:
From: Highviews highvi...@gmail.com
I have numbers separated with commas saved into a TEXT Field, for
example:
Good Day.
I hope someone can assist me.
I have a freeradius server running off mysql.
Now I would like to use triggers to negate some of the traffic logged within
it.
I tried to use following as trigger..
Create Trigger ftp
BEFORE UPDATE ON radacct
FOR EACH ROW
BEGIN
I am working on moving a database from SQL Server to MySQL 5. Tables,
data, etc I already know.
I have some procedures that i would like to move as well.
Does anyone have examples on creating stored procedures?
Best,
-Jason
--
MySQL General Mailing List
For list archives:
Does anyone have examples on creating stored procedures?
There are quite a few in
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-
ML wrote:
I am working on moving a database from SQL Server to MySQL 5. Tables,
data, etc I already know.
I have some procedures
- Forwarded Message
From: MySQL Web Team webmas...@mysql.com
To: christudas_...@yahoo.com
Sent: Wednesday, July 8, 2009 3:46:09
Subject: Re:General MySQL Question
Thank you for contacting MySQL,
You are likely to get a more detailed response to your question if you
ask on the forums
In the last episode (Jul 07), Marcel Grandemange said:
I hope someone can assist me. I have a freeradius server running off
mysql. Now I would like to use triggers to negate some of the traffic
logged within it. I tried to use following as trigger..
Create Trigger ftp
BEFORE UPDATE ON