How to add multiple columns in a MySQL table with PHP form?

Question

I have a table in my database with 2 columns.What I want to do is to let the admin (of the web application ) have the possibility from a simple php/html form to add multiple columns in the table already created.

Thanks.

There is something very wrong with your db schema if you need to change table structure on a regular basis. — piotrm
– piotrm, Commented May 10, 2011 at 17:11
There is nothing wrong with the db schema, I want to give the admin the possibility to add 2,3,4,etc extra columns if he needs for administrating the site. — user747192
– user747192, Commented May 10, 2011 at 18:55

Amir Khalid · Accepted Answer · 2013-03-06 08:36:57Z

1

when you access your web application as admin then try this query

ALTER TABLE Table Name
ADD (column1 col_definition,
column2 col_definition,
column3 col_definition,
....      ......
....      ......
columnN col_definition);

answered Mar 6, 2013 at 8:36

Amir Khalid

711 silver badge2 bronze badges

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

Comments

Shakti Singh · Accepted Answer · 2011-05-10 16:37:10Z

0

so what give admin to fill the required info for the column and run query if admin enter valid info

alter table table_name add column <colname> <datatype> <otheroption>

answered May 10, 2011 at 16:37

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Comments

Anthony Basooma · Accepted Answer · 2022-02-10 19:39:58Z

0

To add multiple table columns if they don not exist alter table_name add column IF NOT EXISTS ( <colname1> <datatype> DEFAULT VALUE, <colname2> <datatype> DEFAULT VALUE, <colname3> <datatype> DEFAULT VALUE, <colname4> <datatype> DEFAULT VALUE)

answered Feb 10, 2022 at 19:39

Anthony Basooma

511 silver badge3 bronze badges

Collectives™ on Stack Overflow

How to add multiple columns in a MySQL table with PHP form?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related