// Create connection
$conn = new mysqli("localhost", "uesename", "password","test");
// Detect connection
if ($conn->connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
// Use sql to create a data table
$ sql = "CREATE TABLE new (
id int(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
title varchar(100) NOT NULL,
author varchar(20) NOT NULL,
content text NOT NULL,
created_at datetime NOT NULL,
)ENGINE=InnoDB DEFAULT CHARSET=utf8 ";
if ($conn->query($sql) === TRUE)
{
echo " Table MyGuests created successfully";
} else { Table MyGuests created successfully"; ?>
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
The statement to create the table, there cannot be a comma here at the end, it should be enough to remove it. This is SQL syntax, commas are required at the beginning and not at the end.
created_at datetime NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8 ";