RE: ?

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

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

2001-02-22 Thread Patrick FICHE
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] Int

RE: Slow Select count(*) - Second Post

2001-02-20 Thread Patrick FICHE
(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 advance, Robin -Original Message- From: Patrick FICHE [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 14

concurrency in mysqld library ?

2001-02-15 Thread Patrick FICHE
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

2001-02-14 Thread Patrick FICHE
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 fvrier 2001 18:09 : Mysql Objet : Use of mysql_use_result in ODBC driver ? Hi all, I would like

Use of mysql_use_result in ODBC driver ?

2001-02-12 Thread Patrick FICHE
__ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.com ___ - Before posting

Date for Gemini project

2001-01-29 Thread Patrick FICHE
in the 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: How to query and return nearest value...

2001-01-24 Thread Patrick FICHE
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

RE: Direct use of MyISAM in applications.

2001-01-24 Thread Patrick FICHE
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