使用xampp中的mysql建表后解析显示: Table 'movie' already exists

浏览次数：246次悬赏分：50 | 提问时间：2011-05-05 | 提问者：天天当前状态：未解决

使用xampp中的mysql建表后解析显示: Table 'movie' already exists 之前并未建立这个表，一直无法解决求解代码如下：

//connect to MySQL

$db = mysql_connect('localhost','root','') or  die ('Unable to connect.Check your connection parameters.');

//create the main database if it doesn't already exist

$query = 'CREATE DATABASE IF NOT EXISTS moviesite';

mysql_query($query,$db) or die(mysql_error($db));

//make sure our recently created database is the active one

mysql_select_db('moviesite',$db) or die(mysql_error($db));

//create the movie table

$query = 'CREATE TABLE movie (

    movie_id       INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

    movie_name     VARCHAR(255)      NOT NULL,

    movie_type     TINYINT           NOT NULL DEFAULT 0,

    movie_year     SMALLINT UNSIGNED NOT NULL DEFAULT 0,

    movie_leadactor  INTEGER UNSIGNED NOT NULL DEFAULT 0,

    movie_director  INTEGER UNSIGNED NOT NULL DEFAULT 0,

    PRIMARY KEY (movie_id),

    KEY movie_type (movie_type,movie_year)

    )

    ENGINE=MyISAM';

mysql_query($query,$db) or die (mysql_error($db));