Things which can be done with MYSQL instead of involving PHP [closed]

Question

What are the must-know MYSQL functions (like IF etc..,) which every web developer should know?

Answer 1

My favorite:

INSERT ... SELECT

It allows me to bypass heavy PHP code to fetch data from one table, manipulate it and insert into another.

Answer 2

i'd say:

CREATE VIEW .. AS SELECT

when i have querys that i use all the time, but it's not a function =P