Mysql 101 Basic Notes

MYSQL 101 Notes

Table related

=================

Creating a table:

http://www.w3schools.com/php/php_mysql_create.asp

Alter table syntax : http://www.w3schools.com/sql/sql_alter.asp

Foreign key syntax (also includes drop ):

http://www.w3schools.com/sql/sql_foreignkey.asp

Issue with dropping foreign key constraints:

http://bugs.mysql.com/bug.php?id=14347

See create table code of current table

http://stackoverflow.com/questions/4004205/mysql-show-constraints-on-tables-command

Queries

=======

Like statements in where clauses:

http://stackoverflow.com/questions/10022338/mysql-use-like-in-where-clause-to-search-in-subquery

Left Joins:

http://www.w3schools.com/sql/sql_join_left.asp

Inserts

=======

Inserting records:

http://www.w3schools.com/php/php_mysql_insert.asp

Mysql Server

============

Mysql server has gone away error (got this when passing in a large script of insert statements):

http://bogdan.org.ua/2008/12/25/how-to-fix-mysql-server-has-gone-away-error-2006.html