Hi,
Move the conditions b.tag = 1 and b.day = 11323
into the ON clause of the outer join.
In your present query, the result of the outer join gets filtered
with the two conditions, and those are not true for the records in T1
that have no matching rows in b.
Jan
Roger Karnouk wrote:
>
> I
Hi,
No, you can't get both in one query.
Anyway, you probably want to see how many results
would be returned in the first place,
before deciding on sensible LIMIT clause parameters.
And you may want to add an ORDER BY clause to your second query,
so that you can rely on the order in which the r
ormix database through perl scripts.
> > BUT what I want is my scripts to ONLY access the mysql DB, but to
> > somehow get the mysql DB to go to the remote informix DB and get data
> > out of tables there and return it through mysql, so that the process
> > accessing the
Yes, either that or plain text files that Informix dumps and MySQL reads in.
Jan
Curtis Maurand wrote:
>
> Perl DBI with the Mysql and the Informix drivers installed.
>
> Curtis
>
> - Original Message -
> From: "MArk Williams" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Mond
Hi,
I'd try to `optimize' the tables in the first place.
Have you tried to select and group by PR1.pollResponsesID instead of
PR2.pollResponsesID?
As they are the equal, the result should be the same, but the query might get
optimized better.
Hope this helps,
Jan
"Oson, Chris M." wrote:
>
Hi,
The perror command gives MySQL error messages.
[jenik@zarq jenik]$ perror 2
Error code 2: No such file or directory
I'd guess you should specify the full path to the output file,
and make sure the location is world-writable.
/tmp should work on Unix systems.
Jan
Jennifer wrote:
>
>
Hi,
I have a table that needs to be indexed heavily.
Even though I specify the `pack_keys=1` table option
and all the keys are combinations of unsigned integers of various sizes,
I don't really get any key packing - read the full story below.
Is there any other magic I should use to get my keys
Hi,
MySQL lets you do a select without any tables,
i.e., without the from-clause.
So,
select 3;
returns one row, one column, value 3.
To put a value into a variable (you mean the @a -style variables?),
you can either
select @a := 3;
or
set @a := 3;
And yes, if you want to do it the Oracl
Hi,
Hmm, MySQL in itself is a wonderful cornerstone for OLAP.
I've set up a MIS that's been running for 16 months now, without a glitch.
The 25 million rows in the main fact table are not a problem.
The trick reads: compressed tables.
But the interface is very poor, MS Query.
Perhaps it would ma
umbly,
> Cal
> http://www.calevans.com
Yours,
Jan
> p.s. another reason not to include it is NOBODY wants to distract the MySQL
> coders from getting 4.0 frozen and out the door! :)
Hey, eventually a good reason against XML in MySQL!
>
> -----Original Message-
>
Michael,
> Is anybody on this thread really rationally suggesting using XML
> instead of SQL? I hope not. It would no longer be an SQL database. Of
> course SQL is the language for committing data to the storage
> mechanism. What the data consists of is another matter.
I'm suggesting there is a
a database, *not* metadata. Do you understand
>the difference?
There is no difference.
What is metadata in one context, is data in another context.
It's just a matter of your standpoint, which can change with time.
XML is a fo
I think 12 tables is not a large number by any means.
If they _logically_ form one database, I'd not bother about the number.
Only if performance problems pop up, and are positively recognized as being caused
by too many files in the database directory, I'd start looking for a solution.
Which need
Hi,
If my calculations are correct, your table will grow quite a lot
if you change from the MyISAM format to HEAP. The space to hold
the data will be roughly 1.3GB (a double of what it's with MyISAM!)
and the index will be another 1.3GB. Pretty huge, isn't it?
I think the dynamic row format is
This way madness lay.
I you don't have data in the database, then it's easy:
Just drop the old database, and use your new script to create it again.
The end result is the same as if you have used alter table's.
O.k., but you probably do have data in the database that you want to preserve.
But th
Hi,
Asaf Maruf wrote:
>
> How can i specify two columns together as primary key for a table.
>
> Using create table test
> (increment int , id int not null primary key, date not null primary key, name
>char(20) );
>
> doesn't work.
You should rather say
create table test (
increment int ,
a given package
is significant enough that you want to record it with packenames?
OTOH this, as a derived piece of information,
would go against the "Normalize!" imperative.
You'd have to be more careful when updating the records,
as MySQL won't look for that part of info for you.
Hi,
Another thing to try can be the myisampack table compressor,
since you say you need just read-only access to the tables.
If the tables get smaller, they could perhaps fit in the OS buffer cache.
MySQL does a memory-map of compressed tables,
which should be quite like having a ramdisk that mig
18 matches
Mail list logo
