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

Lesson 03, MySQL Marinate, Season 2

Sheeri Kritzer C.
sheeri
Group Organizer
Boston, MA
Post #: 180
Notes/errata/updates for Chapter 3:
See the official book errata for pages 95 - 106 at http://tahaghoghi.com...­

On p. 96 - 97, there is an example of what you will see with SHOW DATABASES; You will likely also see INFORMATION_SCHEMA and PERFORMANCE_SCHEMA databases.

On p. 97, it says "There are some restrictions on what characters and words you can use in your database, table and other names." These days, it is possible to escape characters and reserved words, but it is still not recommended.

On p. 101-102, there are examples of how to run the MySQL monitor in "batch mode". It says you can use either "SOURCE" or the redirection operator on commandline (<). However, it does not explain an important difference - if you redirect from commandline with "mysql", an error will stop the rest of the script from running, unless you run it with mysql -f to force it to keep going. If you run a batch file with SOURCE, it will continue to read the source file even if there is an error.

This space is reserved for updates and questions about Chapter 3 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