Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to add new column to MYSQL table?

Tags:

php

mysql

add

alter

I am trying to add a new column to my MYSQL table using PHP. I am unsure how to alter my table so that the new column is created. In my assessment table I have:

assessmentid | q1 | q2 | q3 | q4 | q5  

Say I have a page with a textbox and I type q6 in to the textbox and press a button then the table is updated to:

assessmentid | q1 | q2 | q3 | q4 | q5 | q6 

My code:

<?php    mysql_query("ALTER TABLE `assessment` ADD newq INT(1) NOT NULL AFTER `q10`"); ?>   <form method="post" action="">     <input type="text" name="newq" size="20">     <input type="submit" name="submit" value="Submit"> 
like image 519
Steven Trainor Avatar asked Apr 19 '13 21:04

Steven Trainor


1 Answers

your table:

q1 | q2 | q3 | q4 | q5 

you can also do

ALTER TABLE yourtable ADD q6 VARCHAR( 255 ) after q5 
like image 195
Dima Avatar answered Oct 06 '22 01:10

Dima