Re: Expect Script accessing MySQL

2001-09-24 Thread Mikel King
I'm not up on expect, but I would assume that since you can use sh then you should ber able to use expect. Generally speaking in sh you can do the following: #!/bin/sh MYSQLCMD="/usr/local/bin./mysql" USER="me' HOST="some.host.com" PASSWD="whatever" QUERY="SELECT userId FROM thisTable WHERE id=

Re: Expect Script accessing MySQL

2001-09-23 Thread Chris Aitken
At 11:36 PM 23/09/2001, Neil Zanella wrote: >It is possible and not very hard at all. >But why would you need expect? Why not >just use a shell script? Because the task I need the script to do is best done using Expect (its interfacing with a serial port doing things with some data pulled out o

Re: Expect Script accessing MySQL

2001-09-23 Thread Neil Zanella
It is possible and not very hard at all. But why would you need expect? Why not just use a shell script? Neil On Mon, 24 Sep 2001, Chris Aitken wrote: > Hi, > > Just a quick query. I haven't been able to locate any documentation on it, > but has anyone ever used an expect script to connect to

Expect Script accessing MySQL

2001-09-23 Thread Chris Aitken
Hi, Just a quick query. I haven't been able to locate any documentation on it, but has anyone ever used an expect script to connect to a MySQL database and pull out a bunch of data for use further in the expect script ? Any directions would be appreciated. Cheers Chris -- Chris Ait