Warning: include(JerryVale.inc) [function.include]: failed to open stream: No such file or directory in /home/content/95/8053495/html/sql.php on line 6

Warning: include() [function.include]: Failed opening 'JerryVale.inc' for inclusion (include_path='.:/usr/local/php5/lib/php') in /home/content/95/8053495/html/sql.php on line 6
SQL the DataBase
What Do You Want To Know?
Enter your query in SQL
 

         
 
Some pattern queries:
Show the SeenMovies tables
Describe the columns of a table
Select rows from a table and display them
Insert a new row of values into a table
Update an item in a table
Delete an item from a table
Delete a column from a table
Add a column to a table
Modify a column definition
Add an index
Change a column name
Delete a table or index
Are there any movies not seen?
Does this movie exist in the SeenMovies table?
List a month's movies
List any duplicate movie names

Delete all the movies in a month

Definition of the SeenMovie table

DROP TABLE IF EXISTS Persons;
CREATE TABLE SeenMovies (
Name_IDVARCHAR( 010 )UNIQUE NOT NULL,
NameVARCHAR( 100 )NOT NULL,
DOBDateNULL,
DODDateNULL,
PRIMARY KEY( Name ) );
 
DROP TABLE IF EXISTS Cities;
CREATE TABLE Cities (
City_IDINT( 004 )AUTO_INCREMENT,
CityVARCHAR( 100 )UNIQUE NOT NULL,
PRIMARY KEY( City_ID ) KEY( City ) );
 
DROP TABLE IF EXISTS Cemeteries;
CREATE TABLE Cemeteries (
Cemetery_IDINT( 004 )AUTO_INCREMENT,
CemeteryVARCHAR( 100 )UNIQUE NOT NULL,
PRIMARY KEY( Cemetery_ID ) );
 
DROP TABLE IF EXISTS AItems;
CREATE TABLE AItems (
Name_IDVARCHAR( 010 ),NOT NULL
City_IDINT( 004 ),NULL
Cemetery_IDINT( 004 ),NULL,
PRIMARY KEY( Name_ID ) );