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

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 field

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 table

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 doe

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 t

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 na

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

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?

John I think you can do this way on shell: mysql -h db_server -u user -pPASSWORD -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 line?

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 wrote: > On 17/03/2010, at 9:10 PM, Anand kumar wrote: > > you are right sir , the va

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: 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 , 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

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 apprecia

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 wrote: > anand > > Do you use innodb engine at all further > -D > > -Original Message- > From: sanan...@gmail.com [mailto:sanan...@gmail.com] On B

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

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 information

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: dash was converted o a wierd character

On Tue, Mar 16, 2010 at 8:03 PM, Michael Dykman wrote: > On Tue, Mar 16, 2010 at 5:06 AM, Johan De Meersman > 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 have been copied from a word

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