December 2003
Beginner
648 pages
14h 1m
English
The workshop is designed to help you anticipate possible questions, review what you've learned, and begin learning how to put your knowledge into practice.
| 1: | Which MySQL function will enable you to run an expression many times over to find the speed of the iterations? |
| 2: | Which SQL command will clean up the structure of your tables? |
| 3: | Which FLUSH command resets the MySQL log files? |
| 4: | To quickly determine if MySQL has support for InnoDB tables, would you use SHOW STATUS or SHOW VARIABLES? |
| 5: | Write a SQL statement that will enable you to see the SQL statement used to create a table called myTable. |
| A1: | The benchmark() function |
| A2: | OPTIMIZE |
| A3: | FLUSH LOGS |
| A4: | SHOW VARIABLES |
| A5: | SHOW CREATE TABLE myTable |
| 1: | If you have root-level ... |
Read now
Unlock full access