How To Code Well
MYSQL Console Tutorial #1 Basics
The First part of the MYSQL Console series. In this MYSQL tutorial you will learn how to navigate around the MYSQL console and explains some basic commands such as logging into MYSQL, viewing available databases, viewing tables and their structures
MYSQL Console Tutorial #2 Dropping tables
The second part of the MYSQL Console tutorials. In this example you will learn how to delete a table from the database
MYSQL Console Tutorial #3 Dropping Databases
The third part of the MYSQL Console tutorials. In this example you will learn how to delete a database from the mysql console
MYSQL Console Tutorial #4 Create a database and table
In the fourth MYSQL Console Tutorial you will learn how to create a MYSQL database and table via the MYSQL console under Linux.
MYSQL Console Tutorial #5 How to change null fields in a table schema
The fifth part of the MYSQL Console series. This MYSQL command line tutorial demonstrates how to change null field values in a tables schema using the MYSQL console
MYSQL Console Tutorial #6 Renaming and changing table columns
In the sixth part for the MYSQL console tutorial you will learn how to add, drop and change a table column using the MYSQL command line.
MYSQL Console Tutorial #7 How to change default fields in a table schema
In the seventh part for the MYSQL console tutorial you will learn how to change the default values in a table schema using the MYSQL command line.
MYSQL Console Tutorial #8 How to change the extra value in a table schema
In the eighth part for the MYSQL console tutorial you will leanr how to change the extra value in a table schema using the MYSQL command line.
MYSQL Console Tutorial #9 How to insert records into a MYSQL table
In the ninth part for the MYSQL console tutorial you will learn how to insert records into a MYSQL table schema using the MYSQL command line.
MYSQL Console Tutorial #10 How to select records from a MYSQL table
In the tenth part for the MYSQL console tutorial series you will learn how to select records from a MYSQL table using the MYSQL command line.
MYSQL Console Tutorial #11 Updating records in a MYSQL table
In the eleventh part for the MYSQL console tutorial series you will learn how to update records in a MYSQL table using the MYSQL command line.
MYSQL Console Tutorial #12 Using aliases in a MYSQL query
In the twelfth part for the MYSQL console tutorial series we look at using aliases in MYSQL queries.
MYSQL Console Tutorial #13 Using the CONCAT function in MYSQL
In the thirteenth part for the MYSQL console tutorial series we look at using the CONCAT function in a MYSQL query.
MYSQL Console Tutorial #14 Using the UPPER function in MYSQL
In the fourteenth part for the MYSQL console tutorial series we look at using the UPPER function in a MYSQL query.
MYSQL Console Tutorial #15 Using the LOWER function in MYSQL
In the fifteenth part for the MYSQL console tutorial series we look at using the LOWER function in a MYSQL query.
MYSQL Console Tutorial #16 Using the CONCAT_WS function in MYSQL
In the sixteenth part for the MYSQL console tutorial series we look at using the CONCAT_WS function in a MYSQL query.
