Installing Mysql-Workbench

2012-02-09 Thread Adarsh Sharma
Dear All, I researched about data modelling & designing Schema diagrams & need a tool to design Schema diagrams. Today i download the source code of Mysql-Workbench ( mysql-workbench-gpl-5.2.37-src ), but when i run the ./configure command i am facing the below issue :- checking for GNOME..

About mysql++3.1.0 SET TRANSACTION ISOLATION LEVEL

2012-02-09 Thread 陈秋丰
Hello: I foud a question about function of transaction. In this function switch not have break Transaction::Transaction(Connection& conn, IsolationLevel level, IsolationScope scope, bool consistent) : conn_(conn), finished_(true)

Re: conditional updating

2012-02-09 Thread Johnny Withers
It implied to me there were two fields to update based on the date being a given value. Read it how you like. Sent from my iPad On Feb 9, 2012, at 9:34 AM, Michael Dykman wrote: > He did mention that there was another field he was updating, which > implies that the state of the date field was n

Re: Tuning mysql

2012-02-09 Thread Michael Dykman
Good advice, all of it. What hasn't been said and should be noted: in most cases, the bottleneck is the queries themselves. You will generally get a lot more boost from tuning those than from any configuration tweaking (excepting the pathological cases). - michael dykman On Thu, Feb 9, 2012 a

Re: Tuning mysql

2012-02-09 Thread Giovanni Bechis
Grant wrote: > I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should > change any settings. I'm using mysql with a website on the same > server so I have skip-networking, and I increased key_buffer and > innodb_buffer_pool_size from 16M to 256M. Everything else is default. > Sho

Re: conditional updating

2012-02-09 Thread Michael Dykman
He did mention that there was another field he was updating, which implies that the state of the date field was not the only condition. - michael On Thu, Feb 9, 2012 at 9:22 AM, Johnny Withers wrote: > So, add your "other criteria" to the where clause, you failed to say > there were other condi

Re: conditional updating

2012-02-09 Thread Johnny Withers
So, add your "other criteria" to the where clause, you failed to say there were other conditions in your first email. Sent from my iPad On Feb 9, 2012, at 7:56 AM, william drescher wrote: > On 2/9/2012 8:22 AM, Johnny Withers wrote: >> Update table set mydate=now() where mydate='-00-00'; sh

Re: conditional updating

2012-02-09 Thread william drescher
On 2/9/2012 8:18 AM, Michael Dykman wrote: untested: update set mydate = IF(mydate = '-00-00', now(), mydate) - michael dykman Thank you very much ! bill On Thu, Feb 9, 2012 at 8:14 AM, william drescher wrote: I want to update a date field in a record. if the date in the fie

Re: conditional updating

2012-02-09 Thread Reindl Harald
Am 09.02.2012 14:55, schrieb william drescher: > On 2/9/2012 8:22 AM, Johnny Withers wrote: >> Update table set mydate=now() where mydate='-00-00'; should do it. > can't do that because the record is selected by other criteria. so explain the criteria, show us the query usually you do exat

Re: conditional updating

2012-02-09 Thread william drescher
On 2/9/2012 8:22 AM, Johnny Withers wrote: Update table set mydate=now() where mydate='-00-00'; should do it. can't do that because the record is selected by other criteria. Thanks bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: C api mysql_store_result vs mysql_use_result

2012-02-09 Thread Johan De Meersman
- Original Message - > From: "Alex Schaft" > > From the user's perspective, they just need to know the process didn't > hang. The count() query is more for getting memory requirements upfront. > Can I handle it all, or do I need to break it down into pages? Then just use the cursor-bas

Re: conditional updating

2012-02-09 Thread Johnny Withers
Update table set mydate=now() where mydate='-00-00'; should do it. Sent from my iPad On Feb 9, 2012, at 7:15 AM, william drescher wrote: > I want to update a date field in a record. if the date in the field is > -00-00 I want to change it to the current date. I would appreciate > sug

Re: conditional updating

2012-02-09 Thread Michael Dykman
untested: update set mydate = IF(mydate =  '-00-00', now(), mydate) - michael dykman On Thu, Feb 9, 2012 at 8:14 AM, william drescher wrote: > I want to update a date field in a record. if the date in the field is > -00-00 I want to change it to the current date.  I would apprecia

conditional updating

2012-02-09 Thread william drescher
I want to update a date field in a record. if the date in the field is -00-00 I want to change it to the current date. I would appreciate suggestions or links on how to do this. Yup, tried reading the manual, but need a bit of help. I will be updating another field at the same time. bill

Re: C api mysql_store_result vs mysql_use_result

2012-02-09 Thread Alex Schaft
On 2012/02/09 01:40 PM, Johan De Meersman wrote: - Original Message - From: "Alex Schaft" If I were to do a select count(*) from x where y prior to doing select * from x where y to get a number of records, how would this impact performance on the server itself? Would the first query be

Re: C api mysql_store_result vs mysql_use_result

2012-02-09 Thread Johan De Meersman
- Original Message - > From: "Alex Schaft" > > If I were to do a select count(*) from x where y prior to doing > select * from x where y to get a number of records, how would this impact > performance on the server itself? Would the first query be the one to > do the most processing, with