Part IV. mysql database

Table of Contents

16. introduction to sql using mysql
installing mysql
accessing mysql
Linux users
mysql client application
the mysql command line client
mysql databases
listing all databases
creating a database
using a database
access to a database
deleting a database
backup and restore a database
mysql tables
listing tables
creating a table
describing a table
removing a table
mysql records
creating records
viewing all records
updating records
viewing selected records
primary key in where clause ?
ordering records
grouping records
deleting records
joining two tables
inner join
left join
mysql triggers
using a before trigger
removing a trigger