Re: Export of text fields from Access2000

around trying to import it, I just bought their Excel-to-MySQL program. Including the time it took to buy the software, it took less than 15 minutes to import. The hardest part was finding their website, www.convert-in.com Tac - Original Message - From: Greg Knaddison [EMAIL PROTECTED

MySQL 4.03 and merge tables: bug with BETWEEN

not yet (since it's not supported), but I did see that on the to-do list. Thanks! Tac - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: slow query in MySQL 4

a pretty basic query, but I must be doing something wrong because 30 seconds to do a count can't be right. Thx, Tac --- # # Table structure for table `articles_category` # CREATE TABLE articles_category ( article_id int(11) NOT NULL default '0', category_id int(11) NOT NULL default '0

slow query in MySQL 4

MySQL 3 and 4 for now. I believe that the query works significantly faster on MySQL 3. Any ideas? Thx, Tac - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Read-Only MySQL

solution (though the Apache version is free). Microweb is pretty clever with MySQL -- if it's read-only, it'll run from the CD, otherwise, it'll copy the tables to a temporarly location on the user's harddrive. I'm not sure how licensing is handled, though. Tac From http://www.indigostar.com

Re: Recreating an MS-SQL database in MySQL: redux

of the constraints just using MySQL, but the converter may make your life a bit simpler. Or, if you have the $3k, do a google search for SQL MySQL converter Tac - Original Message - From: Christopher Bort [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 1:59 PM

Slow Query: matching criteria AND ordering by primary key

on speeding this up? (Every day I look on mysql.com to see if 4.02 is out, because this issue will largely go away when query caching is available, and I don't want to implement that logic in my code now.) TIA, Tac - Before posting

large table with text field -- performance?

the memos separately, which can kill performance). Finally, in this case should I allow Null's and use them for the 98% empty fields? Thx, Tac - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: GETTING ROWS

$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

execution time in PHP v. perl

using mysql_pconnect to connect to the database in PHP, and using the DBI module to connect in perl. Ideas? I know this sounds very bizarre -- I've been playing around with it for hours, trying to figure out how PHP could possible be tied to slowing My

Re: Seaching Keywords column

word problems, it looks very clear, and it's fairly easy to convert to a more properly designed structure. Anyway, check out the full-text search. It's not as good a full-blown search engine, but it beats the heck out of LIKE %$searchstring% queries! Tac - Original Message - From

Converting tables to MyISAM

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