- Original Message -
From: Alex Schaft al...@quicksoftware.co.za
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
On 2012/02/09 01:40 PM, Johan De Meersman wrote:
- Original Message -
From: Alex Schaftal...@quicksoftware.co.za
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?
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
untested:
update set mydate = IF(mydate = '-00-00', now(), mydate)
- michael dykman
On Thu, Feb 9, 2012 at 8:14 AM, william drescher
will...@techservsys.com 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
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 will...@techservsys.com 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
- Original Message -
From: Alex Schaft al...@quicksoftware.co.za
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
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:
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 exatcly
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
will...@techservsys.com wrote:
I want to update a date field in a
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 will...@techservsys.com wrote:
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where
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 joh...@pixelated.net wrote:
So, add your other criteria to the where clause, you failed to say
there
Grant emailgr...@gmail.com 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
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
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 mdyk...@gmail.com wrote:
He did mention that there was another field he was updating, which
implies that the state of the
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)
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...
16 matches
Mail list logo