结束没有用分号(;)。
insert into test (username,password)values("1","root1");
mysql-front sql编辑器
phpmysql添加数据
<?php
$host = 'localhost'; // mysql服务器主机地址
$user = 'root'; // mysql用户名
$pwd = '123456'; // mysql用户名密码
$conn = mysqli_connect($host, $user, $pass); if(! $conn ) { die('连接失败: ' . mysqli_error($conn)); } echo '连接成功<br />'; // 设置编码,防止中文乱码
mysqli_query($conn , "set names utf8"); $title = '学习';
$author = 'ss'; $date = '2022-03-06'; $sql = "INSERT INTO test ". "(title,author, date) ". "VALUES ". "('$title','$author','$date')"; mysqli_select_db( $conn, 'test' ); $retval = mysqli_query( $conn, $sql ); if(! $retval ) { die('无法插入数据: ' . mysqli_error($conn)); } echo "数据插入成功\n"; mysqli_close($conn);
?>