shell script to run update sql statement

Question

I have an update sql statement and I have to run this sql script through linux script.. What will be the shell script to do such a task?

update inventories
set reserveddate is null,
     purchasedid is null,
where purchased is null
and (TO_CHAR(SYSTIMESTAMP,'HH24') - TO_CHAR(reserveddate ,'HH24')) > 1;

Adem Öztaş · Accepted Answer · 2015-10-25 21:25:39Z

1

Try like this,

#!/bin/bash

mysql -uroot -p<YOUR_PASS> -e <DB_NAME> "update inventories set reserveddate is null, purchasedid is null, where purchased is null and (TO_CHAR(SYSTIMESTAMP,'HH24') - TO_CHAR(reserveddate ,'HH24')) > 1;"

answered Oct 25, 2015 at 21:25

Adem Öztaş

21.6k5 gold badges36 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2327300 Over a year ago

thank you. How can we do the same thing in Oracle database?

Collectives™ on Stack Overflow

shell script to run update sql statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related