select a,b,c,0 as addcolumn from table其中a,b,c是你表table里的列,addcolumn是新增的列
select a,b,'' as c from tb update Tb set 字段='值' where 条件
Suppose you want to add one column named as "Name",Follow is an example: Alter table add column name char(20)
如果要在表中增加列: Alter 表名 add column 列名 char(10)[数据类型] 如果要在返回的结果集里面增加列项: select student.sno,student.sname,course.cName,course.grade from student,course where student.sno=course.sno
update Tb set 字段='值' where 条件
Alter table
add column name char(20)
Alter 表名
add column 列名 char(10)[数据类型]
如果要在返回的结果集里面增加列项:
select student.sno,student.sname,course.cName,course.grade
from student,course
where student.sno=course.sno