I'll ask the dumb question.
Why not create individual history tables corresponding to your 'main'
tables? So, if you have an 'address' table, then the original record could
be written to an 'address_his' table via an update or delete trigger
(depending on whether you allow deletions or not) when a
If'n it were my nickel, here is how I would solve the problem (at a somewhat
high level). That is, assuming I had an ETL tool available.
1. Create landing tables for your source data.
2. Load data from the source table(s) to your new landing table(s).
3. Perform lookups from the new landing table
Having watched responses go back and forth, I'll throw my cave-man approach
into the mix.
select id from
(select distinct id, count(*)
from my_table
where type in (2,5)
group by id
having count(*) = 2)a;
And addressing one of your concerns about more than two variables...in this
example,you wou
I'm a fan of Toad for MySQL.
http://toadformysql.com/index.jspa
> -Original Message-
> From: AndrewMcHorney [mailto:andrewmchor...@cox.net]
> Sent: Friday, October 14, 2011 1:12 PM
> To: mysql@lists.mysql.com
> Subject: Additional Software to Download and Install
>
> Hello
>
> I just d
Toad for MySQL can do the diagramming piece...but, it looks and feels like
you might have some of the same frustrations with it as well. But, another
tool worth exploring nonetheless.
On Thu, Apr 7, 2011 at 2:17 PM, Daevid Vincent wrote:
> Does anyone have any suggestions on this? I've written
> -Original Message-
> From: ishaq gbola [mailto:ishaq...@yahoo.co.uk]
> Sent: Tuesday, January 05, 2010 7:18 AM
> To: mysql@lists.mysql.com
> Subject: Exporting the result of a Query into excel
>
> Hi all,
>
> I would like to know if there is a tool or command in mySQL that allows
> one
Depending on whether you just need to count or the transaction numbers, one of
the following three should get you where you want/need to be:
To identify the count for comp_id = 675:
select count(distinct trans_no) from trans where comp_id = 675 and result = 'o';
To identify the transactions:
sel
Methinx you need a "GROUP BY" in there. See below.
> -Original Message-
> From: John Meyer [mailto:john.l.me...@gmail.com]
> Sent: Thursday, September 10, 2009 6:48 PM
> To: mysql@lists.mysql.com
> Subject: Natural join problem
>
> Two tables:
>
> USERS:
> USER_ID (PK)
> . . .etc
>
> T
to use localhost.
> Do you need Apache and PHP? Is there a Windows application that works
> like
> phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not cut
> and
> paste SQL Commands into the editor.
>
[Jason Trebilcock]
Toad for MySQL would be another optio
I think we've got almost all of the big ones listed. To complete the list
(or at least grow the list by one), let me offer up Toad for MySQL:
http://www.toadsoft.com/toadmysql/
On Wed, Jun 10, 2009 at 1:55 PM, Isart Montane wrote:
> I've been using phpmyadmin as a MySQL GUI for some time and wor
See below...
> -Original Message-
> From: John Taylor-Johnston [mailto:John.Taylor-
> [EMAIL PROTECTED]
> Sent: Thursday, March 20, 2008 2:17 PM
> To: Sebastian Mendel; mysql@lists.mysql.com
> Subject: Re: relational tables
>
> DROP TABLE IF EXISTS `person`;
> CREATE TABLE `person` (
>
11 matches
Mail list logo
