CHAPTER 4

image

Using MySQL Database

MySQL is the most commonly used open source relational database. MySQL is similar to Oracle Database in some regards such as users are kept in grant tables by the database. But MySQL is different from Oracle Database in some regards too:

  1. MySQL does not have roles and privileges have to be granted individually to users.
  2. Database and table names are case-insensitive in Oracle but are case sensitive if the underlying OS is case-sensitive.
  3. MySQL provides a default value for columns that do not allow a NULL value and a value is not provided explicitly in the INSERT statement, if the strict mode is not enabled. Oracle ...

Get Pro Docker 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.