回首页

后一页
前一页
如何用 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);
?〉


后一页
前一页

回首页