Re: Export of text fields from Access2000

aying 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" &l

MySQL 4.03 and merge tables: bug with BETWEEN

. Finally, does anyone know if you can now use fulltext indexes with a merge table? We're not yet (since it's not supported), but I did see that on the to-do list. Thanks! Tac - Before posting, please check: http:

Re: slow query in MySQL 4

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

slow query in MySQL 4

to work on both 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://

Re: Read-Only MySQL

th the Microweb 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

Slow Query: matching criteria AND ordering by primary key

rds matching this criteria". Any suggestions 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 -

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

to lose some 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" <[EM

large table with text field -- performance?

Server stores 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

Re: Seaching Keywords column

d multiple 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 - Origina

execution time in PHP v. perl

tion as to how). I'm 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 c

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 T

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