MySQL Console

16 Tutorials
10 hours 13 minutes

MySQL Console

Enrol in Course
Continue as Guest
please change

Learning outcomes

  1. Learn how to use query a MySQL database via the command line
  2. Manage a MySQL database via the command line
  3. Gain an understanding of MySQL string functions

Recommended Knowledge

  1. Basic knowledge of the commandline
  2. Basic knowledge SQL

Lessons

Basics
Dropping Tables
Dropping Databases
Create a Database and table
How to change null fields in a table schema
Renaming and changing table columns
How to change default field in a table schema
How to change the extra value in a table schema
How to insert records into a MySQL table
How to select records from a MySQL table
Updating records in a MySQL table
Using aliases in a MySQL query
Using the CONCAT function in MySQL
Using the UPPER function in MySQL
Using the LOWER function in MySQL
Using the CONCAT_WS function in MySQL