RE: usage of mysql command

2002-07-22 Thread Barnali
download mysql module of perl from cpan.org. Barnali -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:08 PM To: [EMAIL PROTECTED] Subject: usage of mysql command Hello all, How to use mysql command in perl script? I want to lock the db

RE: usage of mysql command

2002-07-22 Thread Barnali
You should use the `FLUSH' command if you want to clear some of the internal caches *MySQL* uses. To execute `FLUSH', you must have the *reload* privilege. FLUSH TABLES closes all open tables. If you want table level locks, use LOCK command. LOCK TABLES tbl_name [AS alias] {READ | [READ