Unlimited Web Space

Enjoy Unlimited web hosting

Aug 9, 2011

UPDATE

UPDATE TableName
Set Column1=1,
Set Column2='hello'
# This updates the table by setting the new values of Column1 and Column2


Update TableName
Drop Column Column1,
Truncate Column Column2
#This drops and truncates a particular column of a Table

No comments:

Post a Comment