MySQL Forums
Forum List  »  Newbie

Re: script to use lookup tables.
Posted by: Peter Brawley
Date: August 28, 2014 09:39PM

Three possibilities ...

1. Write a batch/bash script to accepts params which it plugs into preformed query statements which it then passes to the mysql client as a PREPARE/EXECUTE/DROP sequence.

2. Write the same logic into one or more MySQL stored procedures

3. Write the same logic into one or more functions in your application language.

Probably option #3 will give you the most robust solution.

Options: ReplyQuote


Subject
Written By
Posted
August 28, 2014 08:25PM
Re: script to use lookup tables.
August 28, 2014 09:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.