Calculate time span in mysql

Hi : I am trying to calculate the time span of listing a large table database in mysql and I run into trouble where I am trying to use curtime() - value stored in startime.But I do not know how to get the stored value out from startime.Does anybody knows how I can get value out from startime wh

Timing in mysql

Hi: I am using expect scripts to display huge number of tables in mysql, I wonder is there any command in mysql that display out the timestamp it takes to load the databases. Thanks - Before posting, please check: http://ww

cannot locate dbi.pm while running perl scripts

Hi : When I try running my perl scripts using DBI interface with mysql, I got this message:Can't locate DBI.pm in @INC((@INC contain : /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0./usr/libperl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) Where

RE: Can Expect scripts interact with mysql ?

MySQL server version for the right syntax to use near 'qu it' at line 1 -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 2:11 PM To: Paul Choy; [EMAIL PROTECTED] Subject: RE: Can Expect scripts interact with mysql ? At 11:37 -0800

RE: Can Expect scripts interact with mysql ?

wn_id 5) match glob pattern "Enter password:"? no expect: timed out send: sending "\r" to { 5 } expect: does "/cygdrive/c/mysql/bin/mysql -u root -p test\r\n" (spawn_id 5) match glob pattern "*mysql>"? no expect: does "/cygdrive/c/mysql/bin/mysql -u

Can Expect scripts interact with mysql ?

Hi : I am trying to run Expect scripts to interact with mysql. So far I cannot get it to work here is the list of log I got.Does anyone know how to interact Expect scripts with mysql. What am I missing ? Thanks spawn mysql parent: waiting for sync byte parent: telling child to go ahead paren