SQL command for MySQL ?

Hi i am debutant in SQL and i am search to know if it's possible: My SQL requets: UPDATE Table_Logs_Summary SET mails_recus=(mails_recus+1),mail_rbl=(mail_rbl+1) WHERE dom_id=4 AND Date_Start=2010-03-16 06:00:00 AND Date_End=2010-03-16 06:59:59; I wan't know if they have a optimised sql

Re: dash was converted o a wierd character

On Tue, Mar 16, 2010 at 8:03 PM, Michael Dykman mdyk...@gmail.com wrote: On Tue, Mar 16, 2010 at 5:06 AM, Johan De Meersman vegiv...@tuxera.be wrote: On *nix, look for a utility called convmv. I've got a hunch that your original file comes from a windows host, and the filenames may

Disable innodb status info in err log

Hi All, Innodb status information is getting logged on to my mysql error log file for every 15 seconds, can someone help in disabling it ? Thanks Anand

RE: Disable innodb status info in err log

anand Do you use innodb engine at all further -D -Original Message- From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand Sent: Wednesday, March 17, 2010 3:00 PM To: mysql@lists.mysql.com Subject: Disable innodb status info in err log Hi All, Innodb status

Identifiers (was: Re: dash was converted o a wierd character)

Hi everybody! Johan De Meersman wrote: On Tue, Mar 16, 2010 at 8:03 PM, Michael Dykman mdyk...@gmail.com wrote: [[...]] I would suggest that the manner appropriate to most any environment is to just use plain ascii for your filenames :-) [[...]] Let me voice my full support for this

Re: Disable innodb status info in err log

Greetings. Try with the variable innodb_status_file. I wont get logged in mysqlerr.log file. On 17 March 2010 15:15, Shanmugam, Dhandapani dhandapani.shanmu...@eds.comwrote: anand Do you use innodb engine at all further -D -Original Message- From: sanan...@gmail.com

Re: Disable innodb status info in err log

you are right sir , the variables innodb_status_file will write the show innodb status information on to the file innodb_status.PID ... however for me the innodb status is logging into the default error log file... i dont have any clue on how to stop it from writing... Any help would be

Re: Need help with query optimization

It may only be returning 51 rows but its having to read significantly more. Get rid of the derived table join if possible. Something like SELECT TAP.ID http://tap.id/, M.UID, TAP.FirstName, TAP.MI, TAP.LastName, TAP.State, TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType,

Re: Disable innodb status info in err log

On 17/03/2010, at 9:10 PM, Anand kumar wrote: you are right sir , the variables innodb_status_file will write the show innodb status information on to the file innodb_status.PID ... however for me the innodb status is logging into the default error log file... i dont have any clue on how

Re: Disable innodb status info in err log

Jesper, I dont have a table called innodb_monitor on any of my databases, i gone through the links which you mentioned here.. but no luck.. Thanks Anand S On Wed, Mar 17, 2010 at 5:06 PM, Jesper Wisborg Krogh jes...@noggin.com.auwrote: On 17/03/2010, at 9:10 PM, Anand kumar wrote: you are

RE: Trancate table from command line?

John I think you can do this way on shell: mysql -h db_server -u user -pPASSWORD DATABASE -e truncate table table1 Carlos Eduardo Caldi Date: Tue, 16 Mar 2010 14:12:42 -0700 From: joli...@john-oliver.net To: mysql@lists.mysql.com Subject: Trancate table from command

Is Mysql for freebsd 8.0 available?

The official support for freebsd 7.0 has been out of date since May 2009. So I update to the latest version is 8.0. However, I just found the mysql for freebsd 7.0. How can I get the mysql version for freebsd 8.0? Does it exist?

RE: Trancate table from command line?

Am I missing something? Doesn't the -e parameter for the mysql CLI still work? I use it all the time in my scripts. mysql -ulogin -ppassword -e truncate sometable your_dbname Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032

RE: dash was converted o a wierd character

I would suggest that the manner appropriate to most any environment is to just use plain ascii for your filenames :-) The swung dash you refer to is called a tilde, btw, and is mostly used in spanish. [JS] ... and mathematical notation. I certainly agree with your suggestion about file names,

RE: Trancate table from command line?

-Original Message- From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] Sent: Wednesday, March 17, 2010 10:07 AM To: '??? '; 'John Oliver' Cc: mysql@lists.mysql.com Subject: RE: Trancate table from command line? Am I missing something? Doesn't the -e parameter for the

Re: Is Mysql for freebsd 8.0 available?

In the last episode (Mar 17), PengXiaoxun said: The official support for freebsd 7.0 has been out of date since May 2009. So I update to the latest version is 8.0. However, I just found the mysql for freebsd 7.0. How can I get the mysql version for freebsd 8.0? Does it exist? MySQL

Question about DELETE

Hello, I have a simple question about deleting records from INNODB tables. I have a master table with a few child tables linked via Foreign Key constraints. Each table has several indexes as well. My question is: if I delete many records in a single delete statement (i.e., DELETE FROM

Re: SQL command for MySQL ?

I'm not 100% sure I understand what you are wanting but if I do, the INSERT ... ON DUPLICATE KEY UPDATE Syntax detailed here http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html Will probably do what you want. For it to work you would have to have a unique key on the three

Re: Question about DELETE

Hi, It depends how frequently ur doing a commit. If you have written a plsql, with loop and if you commit after each row is deleted, then it get update for each row. Else if you commit at the end the loop, it commits only once for all the rows deleted. regards anandkl On Thu, Mar 18, 2010 at 1:21