插入数据
语法:INSERT INTO table_name(field,field...fieldN) VALUES
通过命令提示窗口插入数据
INSERT INTO bird_tbl
(title, author, submission_date)
VALUES
("PHP","xx",now());
INSERT INTO bird_tbl
(title, author, submission_date)
VALUES
("MySQL","xx","2021-02-11");
补充说明:
如果插入的数据类型是字符型,需要用单引号或双引号
now()是一个MySQL函数,返回日期和时间
使用PHP脚本插入数据
header("content-type:text/html;charset=utf-8");
$dbhost='localhost';
$dbuser='root';
$dbpass='root';
$conn=mysqli_connect($dbhost,$dbuser,$dbpass);
if(!$conn)
{
die('连接失败:'.mysqli_error($conn));
}
echo '连接成功';
mysqli_query($conn,"set names utf8");
$title='学习 Python';
$author='xxx';
$sql="INSERT INTO bird_tbl".
"(title,author,submission_date)".
"VALUES".
"('$title','$author',now())";
mysqli_select_db($conn,'bird');
$retval=mysqli_query($conn,$sql);
if(!$retval)
{
die('无法插入数据'.mysqli_error($conn));
}
echo "数据插入成功\n";
mysqli_close($conn);
?>