This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 21%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I need help with query that will take all tables with prefix "tifa_" in "centraldb" database and copy all data in same name table that ends with "_hist". Column name should be matched. as_of_date need to be yesterday day when running the query.
I have around 70 tables and this is example of 4 tables -- please see attached
TABLE_NAME COLUMN_NAME
Thank you!
@Alan5896 Welcome to the Microsoft Q&A forum, Thanks for posting your question.
You can use Azure Data Factory to copy data from the source tables to the destination tables. You can create a pipeline that uses a Copy Activity to copy data from the source tables to the destination tables and use dynamic mapping to ensure that the column names match, and you can use a dynamic expression to set the as_of_date column to yesterday's date.In the Source column of the as_of_date mapping, enter the dynamic expression @formatDateTime(adddays(utcnow(),-1),'yyyy-MM-dd').
In the Sink column of the as_of_date mapping, enter the column name of the as_of_date column in the destination table.https://learn.microsoft.com/en-us/azure/data-factory/quickstart-hello-world-copy-data-tool
Regards
Geetha
I dont have Azure Data Factory and I need to do it in MySQL procedure.
Do you know how to do it ?
Thanks
@Alan5896 Yes, you can use a MySQL stored procedure to copy data from tables with a specific prefix to tables with the same name and a suffix.
Can you try the attached sample?
Regards
Geetha
Sorry, I do not understand what you are saying.
I have access only to My SQL and need to write procedure to copy data from tables with a specific prefix to tables with the same name and a suffix. Number of tables every day will be different.
Can you help me with this?
Maybe you should find a forum more focused on MySQL. This is a forum for Microsoft products. While where is a tag Azure Database for MySQL, I think this tag is more for the service as such, and your question is just a general MySQL question.
I note that you also have tagged the query SQL Server, but SQL Server is different product from MySQL, so an answer for SQL Server is unlikely to be helpful for you.
I agree with @Erland Sommarskog
I think if will be answer how to do it in SQL Server then I will convert it to MySQL