php对建立数据库表约束

最新推荐文章于 2021-03-26 02:14:31 发布

mazenan900621

最新推荐文章于 2021-03-26 02:14:31 发布

阅读量268

点赞数

文章标签：数据库 php mysql database query insert

本文链接：https://blog.csdn.net/mazenan900621/article/details/6732466

版权

<?php
$con = mysql_connect("localhost","root","123456");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE if not exists shop_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_select_db("shop_db",$con);
$sql = "create table if not exists user(id int AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(10),
password VARCHAR(10),
isdispaly bool not null default '0' )";
mysql_query($sql,$con) or die(mysql_error());

mysql_query("insert into user (id, username, password)
VALUES (null,'joon', 'AAAAA')")or die(mysql_error());
mysql_query("insert into user (username, password)
VALUES ('Toom', 'BBBBB')")or die(mysql_error());
mysql_query("insert into user VALUES (null,'mary', '12345', '1')");

mysql_close($con);

?>