I tagged something for this challenge earlier, but it was unread so I went back and reworked my recipe page and added the comment box. Been a while, so I am thinking this is what was needed.
When setting up my database, I have been banging my head against the wall trying to figure out which data types to use for each item. I began by checking the MySQL homepage, but in the end I found myself getting more and more confused - they seemed to get tooo wordy and involved in the definition of the data type. I found this site to be much more helpful in describing the different data types - it gets right to the point and clearly explains with examples, what each data type does.
An online training course from Web Developers Notes that explains the MySQL commands to create database tables: rows, columns, records, assigning unique id numbers to individuals records. At the news organization where I work, developers have used MySQL to create databases for Connecticut high school football and basketball statistics. The stats are all displayed in tables - check it out at http://data.courant.com/highschoolsports/basketball/home.aspx