Update (DML command)

image.png


Delete (DML command)

image.png


DROP (DDL command)

image.png


image.png


When you install MySQL v9 database software:

  1. 78 System tables are automatically created. The system tables store complete information about the database. (For example: which users are there, what info has stored with user)
  2. 4 users are automatically created.
  3. A few (6) system databases are automatically created.

Users: