ba.hons wrote:
> hello,
>
> I have a mysql script very simple as follows:
>
> UPDATE shift_history
> SET end_date='1900-01-01 00:00:00'
> WHERE employee_id=80 AND end_date='2007-03-25 00:00:00';
>
> UPDATE shift_history
> SET end_date='1900-01-01 00:00:00'
> WHERE employee_id=79 AND end_date='2007-03-25 00:00:00';
>
>
> i need to send this to someone so they can run it on their PC and it
> will update their DB.
>
> I know i have done this before i think using winrar and turning into
> a .exe file.
>
> Could anyone tell me the best way to go about this.
>
> Thanks
>
> Adam
>

Just create a batch file with one line:

mysql -u userid -p < inputfile.txt

Or have them run the above line (with the appropriate substitutions, of
course) from their MS DOS Prompt.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================