MySQL basics

MySQL installation

MySQL connect database

MySQL naming convention

MySQL integers, tinyint, smallint, mediumint, int, bigint

MySQL floating point type, float, double

MySQL date and time type, year, date, time, datetime, timestamp

MySQL character type, char, varchar, tinytext, text, mediumtext

MySQL primary key, composite primary key, auto-increment

MySQL unsigned, zero padded

MySQL empty, default, comment

MySQL creates data table

MySQL insert statement

MySQL delete statement

MySQL modify statement

MySQL query statement