mysql.h *mysql / questions

used to close the connection (of course this happens in a separate thread) What would happen to the resources the closed_query had been using ? With the normal Mysql server , with the embedded server ? Thank you Gamin

worst result in killing an optimize table query

rovide one, unless cancelling means having to repair the table or some similiar problem. Thank you and regards Gamin.

Re: again with SELECT

> thats effectively an OR statement, isnt it? > > how would i select the itemsIDs that have all the requested colors? > > for example if data was: > id:colorID:itemID > - > 11 1 > 21 2 > 3

Re: again with SELECT

Hi, > how do I select all itemIDs that have colorID = 1 and colorID = 2 and > colorID = 3 ... and colorID = N ? > Try this SELECT itemID FROM theTable WHERE colorID IN (1,2,3,...,N); G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

embedded server - show processlist returns empty set

Hi Im running mysql 4.0.12-embedded, a simple query - 'show proceslist'; returns an empty set ? Is this a bug ? thx G

call to 'OPTIMIZE TABLE' in another thread hanging with embedded server

Hi, Im encountering something very funny with embedded server (libmysqld.dll) ver 4.0.12, im connecting to this using Delphi 7 statically on a windows 98 machine. If i call mysql_real_query('OPTIMIZE TABLE my_db.my_table') in the main thread it works perfectly fine, but the moment i call exa