Information Technology @ PaynesNotebook.net




SQL

MySQL official website - http://www.mysql.com/
Wikipedia - http://en.wikipedia.org/wiki/MySQL
W3schools - http://www.w3schools.com/sql/

Notes:

  1. Introduction and terminology - Link
  2. Create and close a MySQL connection, create and delete a database - Link
  3. Create and delete a table - Link
  4. Insert a record - Link
  5. Select columns, go through result - Link
  6. WHERE, ORDER BY, UPDATE, DELETE - Link
  7. Add, delete, and modify a column in a table - Link
  8. Reference database - Link