mysql 插入数据语法_MySQL——插入数据

插入数据

语法：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);

?>