Hi all, I am trying to optimize my database tables at midnight, using winnt, delphi, and libmysql.dll. I want to execute a sequence like:
mysql_select_db(sql, some_database); mysql_query(sql, 'OPTIMIZE TABLE MyTable'); mysql_select_db(sql, another_database); // error mysql_query(sql, 'OPTIMIZE TABLE MyTable'); . . . But the second call to mysql_select_db returns an error (commands out of sync). Why? After successfull optimization, are there any reasons for not changing the selected database? TIA, Anton Tichawa. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
