how to create dynamic columns in a table in mysql

Question

I have a query, could you please tell me.

• Is there any possibility to create a dynamic columns in MySQL?
• Is there any way to create a columns at the time of querying(inserting, updating)?
• Is there any way to create columns, just like creating rows at the time row insertion.

Answer 1

You can add a column to a table by using the ALTER TABLE command; add a column while you are doing an INSERT doesn't sound feasible to me, and even if it's possible I would descourage it. You should know which columns you are inserting values in before running the INSERT statement. My choice would be to ALTER your table before the INSERT statement.

That said, why are you needing this? I sense a disturbance in your database design, if you really need to add columns dynamically :)