RE: ?

You forgot the comma before PRIMARY. Patrick -Message d'origine- De : Toth Dalibor [mailto:[EMAIL PROTECTED]] Envoyé : mardi 27 février 2001 09:51 A : '[EMAIL PROTECTED]' Objet : ? DROP TABLE IF EXISTS recepti; CREATE TABLE recepti ( rid smallint(6) NOT NULL auto_increment, put v

2nd Post : Problems with splitting data across different disks under Windows...

the error in mysql_change_db function. I saw nothing in this function taking into account the symbolic links... Thanks Patrick ______ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED

Problems with splitting data across different disks under Windows...

the error in mysql_change_db function. I saw nothing in this function taking into account the symbolic links... Thanks Patrick ______ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED

RE: Slow Select count(*) - Second Post

| +---+--+---+--+-+---+---+--- --+ 1 row in set (0.00 sec) Is it just tipping the balance and making the optimiser choose a different index? If so, why does the select against the queue_index take so long? Thanks for your help in

concurrency in mysqld library ?

have to use Client/Server solution ? Does someone have an approximative date for 4.0 release. It seems that in the TODO list, it appears as a quick version... Thanks Patrick __ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED

No answer for previous mail : Use of mysql_use_result in ODBC driver

Hi, I had not answer at my first mail... Sorry for posting it again but this is really important for us. -Message d'origine- De : Patrick FICHE [mailto:[EMAIL PROTECTED]] Envoyé : lundi 12 février 2001 18:09 À : Mysql Objet : Use of mysql_use_result in ODBC driver ? Hi all, I

Use of mysql_use_result in ODBC driver ?

trick ______ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.com ___ - Before po

Date for Gemini project

integration of the kernel of a successful commercial databas. Could we already have some idea about performance against MyISAM tables ? Thanks Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http

RE: Index question

If the order of your columns in the index is what you say ( Vessel + Voyage + Port ), MySQL will use the index if you specify the Vessel and Voyage values. The index could not be used if you didn't use the first column of the index (for example, specifying values for Voyage and Port columns)... P

RE: Direct use of MyISAM in applications.

I'm afraid there is absolutely no documentation. You can look for some examples in the MYISAM sources directory. You just have to be aware that this API is not available in Client/Server mode. Furthermore, I don't think it will be possible to access the same data through SQL and Isam at the same

RE: How to query and return nearest value...

Try something like this SELECT price, min(abs(price-value)) as Mini from table group by price order by Mini LIMIT 1 Patrick -Message d'origine- De : Robert Badaracco [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 24 janvier 2001 05:47 À : [EMAIL PROTECTED] Objet : How to query and return

MySQL Performance...

Hi, I'm very new to MySQL and tries to execute some applications with it... I'm having problems which are certainly do to a misunderstanding of how MySQL works... I want to access to MySQL with any application where I want to show only the 20th records of the table or of the result of a query (w