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
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
---
$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'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
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
