如何用 PHP 在 mySQL 中创建数据库表

〈?
$conn=mysql_connect("localhost","username","password");
$db=mysql_select_db("dengyong", $conn);

$tbsql="create table message (";
$tbsql= $tbsql."id bigint UNSIGNED AUTO_INCREMENT Primary key,";
$tbsql= $tbsql."title varchar(100),";
$tbsql= $tbsql."content text,";
$tbsql= $tbsql."ishomepage varchar(1),";
$tbsql= $tbsql."date datetime,";
$tbsql= $tbsql."category varchar(3)";
$tbsql= $tbsql.")";

echo $tbsql."\n\r";
echo mysql_query( $tbsql, $conn);

mysql_close( $conn);
?〉

Published At
Categories with Web编程
Tagged with
comments powered by Disqus