SEO

#1 (**permalink**) 02-28-2008, 09:26 AM

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

#2 (**permalink**) 02-28-2008, 09:26 AM

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
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Mysql Script to exe