I have a large (>40 million rows) table that currently consists of a few
integers and a varchar. I need to add a memo (text > 255 chars) field to
about 2% of the rows. Originally I was going to create another table with a
key and the memo field, but this method is complicating the programming
lo
MySQL 3.23 has full-text search built-in, and it's made for exactly this
situation. You'll need to create a index of type FULLTEXT:
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
Of course, the other way to do this is to create another table with the
keysword in it, and a pointer back
I'm porting some code from perl to php, and have experienced a tremedous
slowdown in one particular query, and I'm perplexed as to why. The query
is simply "Select * From my_table order by ID desc LIMIT 0,20", to get the
last 20 records that were entered. ID is the Primary Key, and it is
auto-i
$query="Select DISTINCT RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT
10" ;
- Original Message -
From: "Randy Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 10:41 AM
Subject: GETTING ROWS
> Here is a query:
>
>
> $query="Select RECEIVER from T
I've searched the MySQL manual and can't figure out how to convert one (or
all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to
3.23).
I think there's a way to do it from the ALTER TABLE command, but I can't
seem to find any examples.
Thx,
Tac
---
