On Wed, 2001-12-05 at 16:33, Arjen G. Lentz wrote:
- Original Message -
From: Florin Andrei [EMAIL PROTECTED]
SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM
event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid =
tcphdr.cid AND tcphdr.tcp_flags =
On Thu, Dec 06, 2001 at 09:39:18AM +1000, Arjen G. Lentz wrote:
Well, you have to realise that the server can only use a one index
per table (for obvious reasons).
That's far from being obvious to a lot of folks...
You can actually split a table into multiple identical ones, by
using MERGE
I have this SQL query:
SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
(well, maybe there are more than two columns selected, and maybe a
little more than two tables, but you got the idea...)
The tables have 5...10 columns, every column is an
At 14:45 -0800 2001/12/05, Florin Andrei wrote:
The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
it run over night, in the morning i still didn't got any results, so i
killed the query).
Hi Florin,
It would help if you could also provide:
the hardware and OS
the
On Wed, 2001-12-05 at 15:01, Robert Alexander wrote:
At 14:45 -0800 2001/12/05, Florin Andrei wrote:
The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
it run over night, in the morning i still didn't got any results, so i
killed the query).
the hardware and OS
SGI
Florin Andrei writes:
SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
it run over night, in the morning i still didn't got any results, so i
killed the query).
Hi Florian,
- Original Message -
From: Florin Andrei [EMAIL PROTECTED]
I have this SQL query:
SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
(well, maybe there are more than two columns selected, and maybe a
little more than two
Hi again Florin,
- Original Message -
From: Florin Andrei [EMAIL PROTECTED]
SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM
event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid =
tcphdr.cid AND tcphdr.tcp_flags = '2';
Your only search condition is