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;