小语法有关问题
程序员文章站
2022-05-21 12:59:48
...
小语法问题
$db=mysql_connect('localhost', 'bp6am', '123')
or die('Unable to connect.');
$query='CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query,$db) or die(mysql_error($db));
mysql_select_db('moviesite',$db) or die(mysql_error($db));
$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,
PRIMARY KEY(movie_id),
KEY movie_type (movie_type,movie_year)
)';
mysql_query($query,$db) or die(mysql_error($db));
?>
然后运行的时候说You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; )' at line 7
------解决方案--------------------
语法错误、、、你看看你SQL语句吧
$db=mysql_connect('localhost', 'bp6am', '123')
or die('Unable to connect.');
$query='CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query,$db) or die(mysql_error($db));
mysql_select_db('moviesite',$db) or die(mysql_error($db));
$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,
PRIMARY KEY(movie_id),
KEY movie_type (movie_type,movie_year)
)';
mysql_query($query,$db) or die(mysql_error($db));
?>
然后运行的时候说You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; )' at line 7
------解决方案--------------------
语法错误、、、你看看你SQL语句吧
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。
相关文章
相关视频