INSERT fails -> return primary key?

Hi, Say I have a table with 2 columns. The first is the primary key (int(11), unique, auto-increment). The second column is a varchar(20) (also unique and indexed). This is part of a search engine. Whenever a new document is indexed then for each word I have to do 2 queries: look up in the ta

MySQL index implementation on MyISAM tables

Hi, Can someone point to a location where the implementation of indexes on MyISAM tables is explained? I'm trying to understand exactly (not roughly) how the indexes are created and used. Harald

Re: combining fields in select

Piko, Please see http://www.mysql.com/doc/en/String_functions.html for more information about String functions in the SELECT. The function you're looking for is CONCAT or CONCAT_WS. Harald - Original Message - From: "Michael Piko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursd

Re: Performance Problems

Do you use indexes? See http://www.mysql.com/doc/en/CREATE_INDEX.html. In my system a retrieval from a 24 million records table (3 columns) with a result of 25 records only took 0.09 sec and 24 million records table with 5 columns 0.25 sec Harald - Original Message - From: "Schonder, M