Home
You may like this!
36.
What do % and _ mean inside LIKE statement?

% corresponds to 0 or more characters, _ is exactly one character.

37.
What does + mean in REGEXP?

At least one character. Appendix G. Regular Expressions from MySQL manual is worth perusing before the interview.

38.
How do you get the month from a timestamp?

SELECT MONTH(techpreparation_timestamp) from techpreparation_questions;

39.
How do you offload the time/date handling to MySQL?

SELECT DATE_FORMAT(techpreparation_timestamp, %Y-%m-%d) from techpreparation_questions; A similar TIME_FORMAT function deals with time.

40.
How do you add three minutes to a date?

ADDDATE(techpreparation_publication_date, INTERVAL 3 MINUTE)