- Connecting to MySQL using the command-line client
- Creating databases
- Creating tables
- Inserting, updating, and deleting rows
- Loading sample data
- Selecting data
- Sorting results
- Grouping results (aggregate functions)
- Creating users
- Granting and revoking access to users
- Selecting data into a file and table
- Loading data into a table
- Joining tables
- Stored procedures
- Functions
- Triggers
- Views
- Events
- Getting information about databases and tables
mysql --host=localhost --port=3306 --user=root --password=admatic123
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.12 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>