Hi,
From the MySQL manual @
http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html
The MyISAM storage engine supports concurrent inserts to reduce
contention between readers and writers for a given table: If a MyISAM
table has no free blocks in the middle of the data file, rows are al
Is id a sequential number? And is it referenced by other tables? If so,
and if over time new products become "old" products, then CASE 2 is more
complex, because when moving a product (i.e., a row) from the new
product table to the old product table, the value of id needs to stay
the same. So for C
Maybe someone could provide a good resonable
input on this issue.
Let's say i have a table products
CASE 1:
table: products
id int unsigned not null,
name char(128) not null,
f_new tinyint not null
id - is basically the id of a product
name - is the name of a product
f_new - is a one byte fla
On a dual boot it should work okay. I've done a similar thing, by taking
the data folder from a Linux installation, copying it to a local windows
computer and using a local install (same version of course) to read it.
It worked fine. I would think the scenario is much the same as what
you're su
Hi,
On Dec 26, 2007 9:23 PM, 232160563 <[EMAIL PROTECTED]> wrote:
> i can not understand sentences as following:
>
> For a BTREE index, an interval might be usable for conditions combined with
> AND, where each condition compares a key part with a constant value using =,
> <=>, IS NULL, >, <, >
Hi,
On Dec 26, 2007 11:02 PM, wang shuming <[EMAIL PROTECTED]> wrote:
> Hi,
> select * , ( select f2
> from (select f1,f2 from t2 where t2.id=t1.id limit 1 union
> all ... order by f1 ) t2
> limit 1
> ) f2
>from t1
> Unknown column ' t