如何将新列添加到MYSQL表? [英] How to add new column to MYSQL table?
本文介绍了如何将新列添加到MYSQL表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试使用PHP将新列添加到我的MYSQL表中.我不确定如何更改我的表,以便创建新列.在我的评估表中,我有:
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
说我有一个带有文本框的页面,然后在文本框中键入q6
并按一个按钮,表格将更新为:
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
我的代码:
<?php
include 'core/init.php';
include 'core/admininit.php';
include 'includes/overall/overall_header.php';
adminprotect_page();
include 'includes/adminmenu.php';
?>
<?php
mysql_query("ALTER TABLE `assessment` ADD newq INT(1) NOT NULL AFTER `q10`");
?>
<h1>Input Career Name</h1>
<form method="post" action="">
Career Name
<input type="text" name="newq" size="20">
<input type="submit"
name="submit" value="Submit">
</body>
</html>
推荐答案
您的表格:
q1 | q2 | q3 | q4 | q5
您也可以
ALTER TABLE yourtable ADD q6 VARCHAR( 255 ) after q5
这篇关于如何将新列添加到MYSQL表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文