Is the syntax "INSERT INTO table SET column='value'" a standard practice in MySQL, and what versions of MySQL support this syntax?

The syntax "INSERT INTO table SET column='value'" is not a standard practice in MySQL. Instead, the correct syntax for inserting data into a table in MySQL is "INSERT INTO table (column) VALUES ('value')". This syntax is supported in all versions of MySQL. 

<?php
// Connect to MySQL database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Insert data into table
$column = "value";
$query = "INSERT INTO table (column) VALUES ('$column')";
$mysqli->query($query);

// Close database connection
$mysqli->close();
?>

Keywords

MySQL INSERT INTO SET syntax version support

Related Questions