0
Bill Name Amount
First row
Second row
third row
fourth row

Bill name values should be created a column in another table

First Second Third

if new row is added in first table, a new column should be created on another. Remember: I am working on Heidi-SQL and mySQL.

Ahmed Akram
  • 11
  • 2
  • This sounds like an [XY Problem](https://meta.stackexchange.com/q/66377/179361). Why do you need an additional table with columns that match the row values the original table? What you are asking is possible, but it is definitely not a good idea. – GarethD Sep 15 '21 at 11:10
  • basically i have to convert rows dynamically into column, i need additional table because i have a configuration table for my specific fields, when a field is inserted in that table, it will be converted into a column in another table and that table is basically for jasper report query – Ahmed Akram Sep 15 '21 at 12:00
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Sep 22 '21 at 06:49

0 Answers0