Re: How do I get version information from a MySQL server?

2001-12-13 Thread Ken Guest
On Déar, 2001-12-13 at 14:42, Colin Hill wrote: > How do I go about querying a mySQL server for version information? mysql> select version(); +-+ | version() | +-+ | 3.23.44-log | +-+ 1 row in set (0.01 sec) mysql> -- The duck quacks. -

Re: mysql CLI: executing SQL from a file

2001-10-23 Thread Ken Guest
On Tue, 2001-10-23 at 10:52, Ken Guest wrote: > On Mon, 2001-10-22 at 23:49, Neil Zanella wrote: > > > > Hello, > > > > I would like to know if it is possible to issue a command from the > > mysql command line interface which will read SQL commands contain

Re: mysql CLI: executing SQL from a file

2001-10-23 Thread Ken Guest
On Mon, 2001-10-22 at 23:49, Neil Zanella wrote: > > Hello, > > I would like to know if it is possible to issue a command from the > mysql command line interface which will read SQL commands contained > in a file and execute them immediately without having to cut and > paste them one gpm buffer

Re: locking question

2001-08-21 Thread Ken Guest
On 19 Aug 2001 19:29:17 +0100, Wesley Darlington wrote: > Hi, Howdy. > On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote: > > At the moment, what I am doing is: > > > > execute "LOCK TABLES foo READ" > > select info from foo > >

locking question

2001-08-16 Thread Ken Guest
hi, I'm new to this list, but not so new to using MySQL and have a question about locking. (This is my first foray into datalocking with MySQL.) I'd like to lock a table (a row in that table would be better) for read and write access to prevent mishaps from occurring during data manipulation. A