Virtual Tech Self-Study Message Board › Lesson 08, MySQL Marinate, Season 2

Lesson 08, MySQL Marinate, Season 2

Sheeri Kritzer C.
Group Organizer
Boston, MA
Post #: 194
Notes/errata/updates for Chapter 8:
See the official book errata at­ - 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.

Powered by mvnForum

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy