Introduction to SQL
/ Bobby Iliev
- 1 online resource (96 pages)
Databases Tables and columns MySQL Installing MySQL Accessing MySQL via CLI Creating a database Configuring .my.cnf The mysqladmin command GUI clients Tables Data types Creating a database Creating tables Dropping tables Allowing NULL values Specifying a primary key Updating tables Basic syntax INSERT SELECT UPDATE DELETE Comments Conclusion SELECT SELECT all columns Formatting SELECT specific columns only LIMIT COUNT MIN, MAX, AVG, and SUM DISTINCT Conclusion WHERE WHERE Clause example Operators AND keyword OR keyword LIKE operator IN operator IS operator Conclusion Sorting with ORDER and GROUP by ORDER BY GROUP BY INSERT Inserting multiple records UPDATE DELETE JOIN Cross join Inner join Left join Right join Conclusion The MySQL dump command Exporting a Database Exporting all databases Automated backups