Fw: General MySQL Question

- Forwarded Message From: MySQL Web Team 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 site at http://foru

Re: Triggers For Radius DB

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

Re: Stored Procedures from SQL Server

> 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 t

Stored Procedures from SQL Server

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: http://lists.mysq

Triggers For Radius DB

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 UPDA

Re: How to use LIKE for detecting numbers with commas?

Thats Great! Thanks a Ton! :) On Mon, Jul 6, 2009 at 7:55 PM, Dan Nelson wrote: > In the last episode (Jul 06), avrom...@whyisitthat.com said: > > From: "Highviews" > > > I have numbers separated with commas saved into a TEXT Field, for > > > example: > > > > > > ROW1: 10,5,2,8, > > > ROW

Deadlock question

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 likel

Re: How to use LIKE for detecting numbers with commas?

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... > > >

ANSI Isolation Level vs. InnoDB consistent read implementation

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.