Virtual Tech Self-Study Message Board › Lesson 08, MySQL Marinate, Season 2
|Sheeri Kritzer C.||
Notes/errata/updates for Chapter 8:
See the official book errata at http://tahaghoghi.com... - Chapter 8 includes pages 277 - 296.
Note: if trying to load the "academics.csv" file on Linux, you may want to set the owner and group to mysql first:
sudo chown mysql:mysql /tmp/academics.csv
In the section on "Creating Tables with Queries", p. 286, it says "The LIKE syntax allows you to create a new table with exactly the same structure as another, including keys." However, it only preserves UNIQUE, PRIMARY and regular indexes. It does not preserve foreign keys at all.
In the section on "Replacing Data", p 292 - 293, it mentions the REPLACE command, but not the INSERT...ON DUPLICATE KEY UPDATE syntax. You can read about that at the MySQL manual page
Finally, for more information on EXPLAIN, check out this hour-long presentation I did on using EXPLAIN. There are also PDF slides
This space is reserved for updates and questions about Chapter 8 of the Learning MySQL book being used in the MySQL Marinate virtual self-study course. If you want, you can go to the Master Discussion List for MySQL Marinate Season 2.