MySQL Authoritative Development Guide (Tutorial)

• Chapter1 MySQL basics
• 1-1 MySQL basics
• 1-2 MySQL installation
• 1-3 MySQL connect database
• 1-4 MySQL naming convention
• Chapter2 MySQL data types
• 2-1 MySQL integers, tinyint, smallint, mediumint, int, bigint
• 2-2 MySQL floating point type, float, double
• 2-3 MySQL date and time type, year, date, time, datetime, timestamp
• 2-4 MySQL character type, char, varchar, tinytext, text, mediumtext
• 2-5 MySQL primary key, composite primary key, auto-increment
• 2-6 MySQL unsigned, zero padded
• 2-7 MySQL empty, default, comment
• Chapter3 MySQL add, delete, check and modify
• 3-1 MySQL creates data table
• 3-2 MySQL insert statement
• 3-3 MySQL delete statement
• 3-4 MySQL modify statement
• 3-5 MySQL query statement