Re: MYSQL FUNCTIONS

2008-03-10 Thread Tim McDaniel
On Mon, 10 Mar 2008, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: While i was going through mysql reference manual. I saw that "A query cannot be cached if it contains any of the functions shown below" ... NOW() On my production server, the following query is being used. select * f

Re: MYSQL FUNCTIONS

2008-03-10 Thread Sebastian Mendel
Krishna Chandra Prajapati schrieb: Hi All, While i was going through mysql reference manual. I saw that "A query cannot be cached if it contains any of the functions shown below" BENCHMARK() CONNECTION_ID() CONVERT_TZ() CURDATE() CURRENT_DATE()

Re: MySQL Functions

2005-05-03 Thread Gleb Paharenko
Hello. See: http://search.cpan.org/~spidb/Net-ext-1.011/lib/Net/Inet.pm Mike Blezien <[EMAIL PROTECTED]> wrote: > Hello, > > Sorry for the slightly OT question :) > > Hoping we have some expert MySQL Function to perl function people on the list. > > Is there an equivelant fun

Re: MySQL functions

2004-11-01 Thread Jon Stephens
In MySQL versions before 5.0, you can write a user-defined function in C and compile it as a shared object. Beginning with MySQL 5.0, you can write stored routines. See these sections of the MySQL Manual: http://dev.mysql.com/doc/mysql/en/Adding_functions.html http://dev.mysql.com/doc/mysql/en/A