MySQL Examples

Drop/delete Column :-
Syntax   
: ALTER TABLE "table_name" DROP "column_name";

Example : ALTER TABLE employee DROP Joining;

Updating Data:-
Syntax   
:  UPDATE "table_name" SET  column1=value1, column2=value"...... WHERE some_column=some_value;

Example : UPDATE employee SET salary=45000 WHERE emp_id=1;

Comments