MySQL Forums
Forum List  »  Newbie

Automatic changes on my queries when changing my database ?
Posted by: Arnaud Schwartz
Date: August 10, 2022 03:34AM

Hi everybody,
I have a question for something I am trying to do at my company :
We have a MySQL database, with a bunch of queries that are executed daily.
In a few weeks, our database will get an update, restructuring some tables and creating new ones.
I have the SQL script that modifies the database, and I was wondering if there was kind of a way to apply this script to my query to give them the same changes that I made in my database.

Let me give you an exemple :
If my query is : "SELECT * FROM my_table"

And my modification script is : "ALTER TABLE my_table RENAME our_table"

If I applied this modification to my query, it would end up to be : "SELECT * FROM our_table"

Is there a tool that would manage to do that automatically ?

Options: ReplyQuote


Subject
Written By
Posted
Automatic changes on my queries when changing my database ?
August 10, 2022 03:34AM


Sorry, only registered users may post in this forum.

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.