Generate Columns Names in MySQL

trafalger
trafalger Chicagoland, IL 🟢

Would it be possible to generate a list of columns/ a select statement in the MySQL dataflow - it'd be really nice to not have to type out 30-40 columns when doing a union. 

 

(Similar to SSMS when you can click "Select top 1000 rows from tablename" and SSMS will generate "Select Col1, Col2, from tablename" and dump it into a new SSMS window. 

1
1 votes

· Last Updated

Comments

  • trafalger
    trafalger Chicagoland, IL 🟢

    PSA - that screenshot is from the default sample "Adventure Works" database so it's all sample data! 

This discussion has been closed.