MySQL noob question

[alexb]

I'm a complete newbie to MySQL, and I'm trying to create a simple script that creates two tables in a database.

CREATE TABLE data (
siteID int AUTO_INCREMENT,
siteNAME VARCHAR(100) NOT NULL,
sitePR LONGTEXT NOT NULL,
PRIMARY KEY(siteID))

CREATE TABLE user (
username VARCHAR(30) NOT NULL,
password VARCHAR(30) NOT NULL,
PRIMARY KEY(username))

Why is this throwing an error after creating the first table?

 

[threehundred]

throw a semicolon at the end of each statement

CREATE TABLE data (
siteID int AUTO_INCREMENT,
siteNAME VARCHAR(100) NOT NULL,
sitePR LONGTEXT NOT NULL,
PRIMARY KEY(siteID));

CREATE TABLE user (
username VARCHAR(30) NOT NULL,
password VARCHAR(30) NOT NULL,
PRIMARY KEY(username));

 

[alexb]

DOH.

Thanks. It's been years since I took a SQL course and I forgot everything.