Re: Determining if a table exists

it would be 998 to 1001. What would be a half-way efficient way of doing this? MySQL version is 3.21.x, with MyISAM tables. Hello, What about: SELECT * FROM `information_schema`.`TABLES` where TABLE_SCHEMA = 'databaseName' AND TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME LIKE 'jst%' -- Dusan

Re: order by version number

text column into 3 integer columns? SELECT * FROM table ORDER BY MajorVersion, MinorVersion, Release Dusan -- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Notification

Hello, I have a problem: If there are more then one clients connected into server and one of them changes databese, how can server notify other clients that data was changed. It is important for refresh view in client program. Thanks. -- MySQL General Mailing List For list archives: