Hi,
Is there a way to dynamically split a big table
into n smaller tables by doing a single scan of
the table that is being split? Here is more
details:
* Suppose I have a million row MyISAM table X, with
relatively small number of columns. It has
a column chunkId with values between 1
Hi,
At my table i have fields a, b and lets say i want to calculate the
number of entries at the table which has the mentioned propery: if there
are consecutive rows with a=x, b=y and the next line a=y and b=x but the
third line should be a != x and b != y, is it possible with an sql query
on
Why not write a simple script that scans every record and inserts them
into the proper table one at a time?
In php for example..
$query = SELECT * \n;
$query .= FROM `X` \n;
$result = mysql_query($query);
while(($row = mysql_fetch_array($result, MYSQL_ASSOC))){
$Values = ;
foreach($row as
Hi,
At my table i have fields a, b and lets say i want to calculate the
number of entries at the table which has the mentioned propery: if there
are consecutive rows with a=x, b=y and the next line a=y and b=x but the
third line should be a != x and b != y, is it possible with an sql query
Jacek Becla wrote:
Hi,
Is there a way to dynamically split a big table
into n smaller tables by doing a single scan of
the table that is being split? Here is more
details:
* Suppose I have a million row MyISAM table X, with
relatively small number of columns. It has
a column chunkId
Howdy,
I've read through all of the MySQL docs on SSL and I just need a brief
overview of a few things to understand some things that aren't crystal
clear to me since I'm not very familiar with SSL.
1) Which SSL options are *required*?
It seems that only ssl-key is _always_ required for
Hi all-
I want to know what the difference between IN and OR is under the hood.
select * from dummy_table where id in (2, 3, 4, 5, 6, 7);
select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or
id=7;
I run the query sql on the test schema, it seems that there is no
performance