I recently moved to a new web server (running 5.5.32) on one of my production
systems. The new server has more RAM, faster CPU, etc so we see queried results
a lot quicker. However, with basically the default my.cnf config file on each
system, we see simple inserts taking about 10x longer than o
wrote:
> Hi Michael,
>
> FYI: I'm using 5.6.13 and your query returns 0 for the third column with my
> instance.
>
> Cheers,
> Sam
>
>
> On Wed, Oct 23, 2013 at 2:35 AM, Michael Stroh wrote:
> I recently upgraded a local MySQL installation to 5.5.32
I recently upgraded a local MySQL installation to 5.5.32 and am trying to
figure out why the following query won't work as expected anymore. I'm just
trying to compare a set of dates to NOW() but since the upgrade, these don't
seem to work as expected.
SELECT
DATE_ADD(STR_TO_DATE('2013-350-00:
tableb b on b.id = c.id
> inner join tablea a on a.num = b.num
> where c.state = 'Yes';
>
> -Travis
>
>
> -Original Message-
> From: Michael Stroh [mailto:st...@astroh.org]
> Sent: Monday, August 30, 2010 4:39 PM
> To: MySql
> Subject: Nested j
Hello everyone. I'm trying to perform a query that acts on 3 tables at once.
I'm thinking I need to produce a set of joins between all three tables to get
the results that I want, but am not sure how to go about it with nesting or
maybe there's even a better way. I need to check TableC for cases
,t2.Num,max(t2.version) from table1 as t1, tabl2 as t2
> where t1.num=t2.num and t1.state!='new' group by t2.IDt
>
> Cheers,
> Geert-Jan
>
> 2010/7/26 Michael Stroh
>
>> Hi everyone and thanks in advance for the help. I have a query that I'd
>>
Hi everyone and thanks in advance for the help. I have a query that I'd like to
perform using two tables but am not sure what the best way to perform it short
of creating a loop in my code and performing multiple queries.
I have two tables. The first table acts as a master table of sorts and Num
aybe something like this could give you a
> starting point?
>
> Steven Staples
>
>
>> -Original Message-
>> From: Michael Stroh [mailto:st...@astroh.org]
>> Sent: June 3, 2010 11:24 AM
>> To: MySql
>> Subject: Help needed on query on multiple
Hi everyone. I'm trying to create a certain MySQL query but I'm not sure how to
do it. Here is a stripped down version of the result I'm aiming for. I'm pretty
new to queries that act on multiple tables, so apologize if this is a very
stupid question.
I have one table (data) that has two column
, or Oracle and DB2
> installations for that matter.
>
> For many classes of application, avoiding autocommit and explicitly
> creating and commiting transactions is the only way to keep the data
> coherent. For lightweight purposes, this can be overkill
>
>
> On Mon, May 17, 2010
Hello, I'm currently writing a python program that scans some web directories
and then stores some information in a local database. I'm playing with using
InnoDB for this application as a test bed for using InnoDB in further
applications, but I'm running into a couple issues.
When I try to writ
11 matches
Mail list logo
