Workshop
The quiz and exercises are provided to help you solidify your understanding of the material covered today. Try to understand the quiz and exercise answers before continuing to tomorrow's lesson.
Quiz
| 1: | Is it possible to decode a string that has been encrypted with PASSWORD()? |
| A1: | No. |
| 2: | What's wrong with the query:
SELECT ADD_PERIOD (200304, 8) |
| A2: | The function should be PERIOD_ADD(), and there cannot be a space before the opening parenthesis. |
| 3: | What is returned by:
SELECT 'Hello' - '22' |
| A3: | The number -22. |
| 4: | What is the result of:
SELECT 'Hello World' RLIKE 'b|c|d' |
| A4: | 1, meaning true. |
Exercises
| 1: | Write a query to run on a table invoices that returns all columns where the invoice was produced more than one week ago (according to the ... |
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
