Ejemplo de METAQUERY

select concat('select * into outfile \'',table_name,'.csv\' from ',table_name,';')
from tables where table_schema='jardineria';
+-----------------------------------------------------------------------------+
| concat('select * into outfile \'',table_name,'.csv\' from ',table_name,';') |
+-----------------------------------------------------------------------------+
| select * into outfile 'Clientes.csv' from Clientes;                         |
| select * into outfile 'Clientes2.csv' from Clientes2;                       |
| select * into outfile 'DetallePedidos.csv' from DetallePedidos;             |
| select * into outfile 'Empleados.csv' from Empleados;                       |
| select * into outfile 'GamasProductos.csv' from GamasProductos;             |
| select * into outfile 'Oficinas.csv' from Oficinas;                         |
| select * into outfile 'Pagos.csv' from Pagos;                               |
| select * into outfile 'Pedidos.csv' from Pedidos;                           |
| select * into outfile 'Productos.csv' from Productos;                       |
+-----------------------------------------------------------------------------+
9 rows in set (0,00 sec)