Re: Logging SQL queries

2009-05-27 Thread Mauricio Tellez
need to record all > queries performed. What is the best / recommended way to achieve this. > > Thanks > Neil > -- Mauricio Tellez

Trigger working with server 5.0.51 but not 5.0.22

2009-05-13 Thread Mauricio Tellez
mp_calculos_res' doesn't exist" Is there a big change in handling triggers from version 5.0.22 to 5.0.51? Or I missing something? Thanks in advance -- Mauricio Tellez

Log querys from stored procedure

2009-04-29 Thread Mauricio Tellez
call. By the way, how can I log the triggers queries? Do I need to set some kind of "query log verbose level"? thanks in advance. -- Mauricio Tellez

dynamic table name

2009-04-26 Thread Mauricio Tellez
7;John Doe'; END of course nested_sp is very silly, but the idea is the same. When I run this, I found that there is no table name like '20080426...' but I get a table 'my_table', how can I fix this? -- Mauricio Tellez

[OFFTOPIC] PHP and local-infile

2009-02-17 Thread Mauricio Tellez
mysql command line I get the same message, so I put the following in my.cnf: loose-local-infile at [client]section. This solve the mysql command line, but when running from PHP I still got the same. Any clue? -- Mauricio Tellez

Re: Automatic email to database member on X date?

2008-07-07 Thread Mauricio Tellez
gt; For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Mauricio Tellez

Re: Odd behavior of 'load data'

2008-01-07 Thread Mauricio Tellez
sage- > From: joe [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 08, 2008 12:01 AM > To: 'Mauricio Tellez' > Subject: RE: Odd behavior of 'load data' > > You may need to use LOAD DATA LOCAL INFILE. > > > -Original Message- > From: Ma

Re: Odd behavior of 'load data'

2008-01-07 Thread Mauricio Tellez
cess the file specified by load data, and the user you use to connect to mysql has nothing to do in that, am I right? So, why this work properly with the root user but not with the filasPOS user? Thanx for the help 2008/1/7, Chris <[EMAIL PROTECTED]>: > > Mauricio Tellez wrote: > >

Odd behavior of 'load data'

2008-01-07 Thread Mauricio Tellez
_priv: Y Create_user_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 any clue? thanks in advance. -- Mauricio Tellez