MySQL: How Do A Create Sql By Using Sql? (Doc ID 2024563.1)

Last updated on MARCH 26, 2017

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Goal

In Oracle if a do the following:
SELECT 'select * from' || table_name FROM `TABLES`
will generate the below SQL.
select * from PRIORITY
...

How do I do the same in MySQL
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms