ROC - Message Board

Back to ROC - Message Board

SQL database



Delete data in clumnn:


UPDATE Table_Name SET Column_Name = Null;

UPDATE Class_Info SET NumStudents = "0";

UPDATE Student_Profile SET Class_1 = Null;
UPDATE Student_Profile SET Class_2 = Null;
UPDATE Student_Profile SET Class_3 = Null;
UPDATE Student_Profile SET Class_4 = Null;
UPDATE Student_Profile SET Paid = "N";
UPDATE Student_Profile SET RegFee = "N";


UPDATE Student_Profile SET RegFee = Paid;

Replace value in Table_A_column_A with Table_B_column_B:


update table1 set table1.col2=table2.col2
from table1
join table2 on (table1.col2=table2.col1)