主页 / 问题 / 1585053
Accepted
Ильнур Габдуллин
Asked:2024-06-24 20:58:43 +0000 UTC2024-06-24 20:58:43 +0000 UTC

mysql 中未创建表

  • 772

代码：

$id = 1;
$text = "555";

$hostnamesite = "localhost"; 
$usernamesite = "namedef"; 
$passwordsite = "1234"; 
$dbNamesite = "namedef";
$link = mysqli_connect($hostnamesite,$usernamesite,$passwordsite,$dbNamesite);
mysqli_set_charset($link, "utf8mb4");
mysqli_query($link, "INSERT INTO table_eee('id','text') VALUES ('$id','$text')");

mysql中没有创建该表。哪个是对的？

php

1 个回答

  1. Best Answer

    INSERT INTO命令用于将数据插入到现有表中，而不是创建表。要创建表，请使用CREATE TABLE命令

    $id = 1;
$text = "555";

$hostnamesite = "localhost"; 
$usernamesite = "namedef"; 
$passwordsite = "1234"; 
$dbNamesite = "namedef";
$link = mysqli_connect($hostnamesite, $usernamesite, $passwordsite, $dbNamesite);

mysqli_set_charset($link, "utf8mb4");

// Создание таблицы
$createTableQuery = "CREATE TABLE IF NOT EXISTS table_eee (
    id INT NOT NULL,
    text VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
)";
mysqli_query($link, $createTableQuery);

// Вставка данных
$insertQuery = "INSERT INTO table_eee (id, text) VALUES (?,?)";
mysqli_execute_query($link, $insertQuery, [$id, $text]);

echo "Table created and data inserted successfully";

mysqli_close($link);
    • 0

相关问题