External Program Execution

2007-06-03 Thread Nasir Iqbal
Hi, I am wondering if there is any way to execute external application from MySQL procedures/trigger/event scheduler. Like as we do in php with !, exec and system. I want to know that if there is any way(simple SQL command, pacth) to do it. so I can execute external application like ???('php -d

Re: Stable mysql 4.xx

2007-06-03 Thread Mogens Melander
I'm haing a hard time figuring out why you want an old 4.0 server, when newer better versions are available. MySQL 4.0.27 can be downloaded from Softpedia: http://linux.softpedia.com/progDownload/MySQL-Download-3074.html On Mon, June 4, 2007 00:44, Baron Schwartz wrote: > Only back to 4.1.x -- b

Problem with UPDATE

2007-06-03 Thread Haig (Home)
Hi everyone, I have a form where you fill out "description" from a textarea and on submit, it updates description in mytable. This works fine. I want to also add the current date into description in my table. Here's what I get: $date = date ("F d Y"); $sql = "UPDATE mytable SET description=

Re: Stable mysql 4.xx

2007-06-03 Thread Dan Nelson
In the last episode (Jun 03), Subasta.pl - Darmowe Aukcje Internetowe said: > Where I can find the best stable version 4.xx? http://dev.mysql.com/downloads/mysql/4.1.html You should really consider using MySQL 5.0, though. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mai

Re: Obtaining the first or second instance of an event

2007-06-03 Thread Baron Schwartz
Hi David, David Scott wrote: I am looking at data from a telephone call centre. I have a table giving data on calls made including time and date with the name CallDateTime. Each call has a number, CallId and each customer has a number CustomerNo. Each row represents a different call. I wou

Re: Stable mysql 4.xx

2007-06-03 Thread Baron Schwartz
Hi, Subasta.pl - Darmowe Aukcje Internetowe wrote: Hello, Where I can find the best stable version 4.xx? Some of the mirrors still have older versions, such as http://mysql.mirrors.pair.com/ Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

Stable mysql 4.xx

2007-06-03 Thread Subasta.pl - Darmowe Aukcje Internetowe
Hello, Where I can find the best stable version 4.xx? Greetings, Ɓukasz Ciszak http://www.subasta.pl

Obtaining the first or second instance of an event

2007-06-03 Thread David Scott
I am looking at data from a telephone call centre. I have a table giving data on calls made including time and date with the name CallDateTime. Each call has a number, CallId and each customer has a number CustomerNo. Each row represents a different call. I would like to create a column whic