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.

you should have a look at some nosql engine. nosql-database.org — Jonathan de M.
– Jonathan de M., Commented Dec 10, 2012 at 10:23
If you want Schema to be changing dynamically then why don't you use MongoDB? You can add new columns using DDL statements through any programming language at run time when ever you require. — jsist
– jsist, Commented Dec 10, 2012 at 10:23
@shubhansh , i had almost developed the schema in mysql , so now i cant migrate to mongodb, so kindly request that tell me , if there is a way in mysql — neotam
– neotam, Commented Dec 10, 2012 at 11:00

Cynical · Accepted Answer · 2012-12-10 11:52:33Z

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 :)

answered Dec 10, 2012 at 11:52

Cynical

9,6281 gold badge19 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to create dynamic columns in a table in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related