Re: Determining if a table exists

2005-05-03 Thread Dusan Kolesar
mine the numeric range of existing tables. In the above example 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 = 'databas

Re: order by "version number"

2005-04-29 Thread Dusan Kolesar
divide 1 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 unsub

Notification

2003-06-17 Thread Dusan Kolesar
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: http://