I need another pair of eyes to see what I am missing. This is simple but I just cannot see what is wrong. I have a file that creates my database and tables. The problem is that when I have a single create table, it works but as soon as I add additional create table statements, I get syntax errors on the subsequent statements. Here is my file:
create database if not exists Erics_BBQ;
use Erics_BBQ;
create table if not exists Products (
Item_Number int unsigned key not null,
Category enum('Beef','Chicken','Pork','Turkey','Misc.') not null,
Product varchar (80) not null,
Description varchar (4096) not null,
Units enum('lb.','oz.','ea.','pt.','qt.','dz.') not null,
Price decimal(5,2)not null
);
create table if not exists Updates (
Last_Update date not null;
Update_by varchar (8) not null;
);
When I comment out the second create table statement, it works fine. What am I not seeing? TIA.