error
directly when offset is more than 4000, this issue seems to disappear.
On 2008-11-05, Kelvin Wu <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I need advice for creating proper INDEX for a query.
>
> The table is like:
Hi All,
I need advice for creating proper INDEX for a query.
The table is like:
mysql> desc article;
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-
BTW, I have force to use index key by using USE INDEX (bysource) for
example, in the query, but it didn't look good to me...
--
Sent from my BlackBerry. Ignore the typos unless they're funny.
I am looking for help and suggestion.
Mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686)
The table structure:
mysql> desc article;
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-
Hi list,
I am thinking of upgrading to MySQL v4.1.8, I installed on my local
machine(Windows XP). Copied tables from MySQL v3.23.xx to MySQL 4(eg,
mytest.MYD, mytest.MYI, mytest.frm), it works just fine, query,
sorting as usual.
I created a new table (say 'newtest') with exactly same structure a