Advantages of INSERT INTO SET in MySQL

Insert data into mysql database. Previously commonly used

INSERT INTO table name (column name 1, column name 2…) VALUES (column value 1, column value 2);

$sql = "INSERT INTO products (p_title,p_price.........) VALUES ('$p_title','$p_price'............)";

• 1. The front and back need to correspond, and it is easy to write the wrong order.
• 2. Later changes (add columns, reduce columns) are made after the front part, which is scattered and easy to make mistakes.
• 3. Difficulty in reading.

$sql = " INSERT INTO products SET
            p_title = '$p_title',
               p_price = '$p_price',
            ...
   ";

$sql = "INSERT INTO products (p_title,p_price) VALUES ('apple','5 yuan'),('lychee','10 yuan'),('red dates','8 yuan')";

The above is the advantages of INSERT INTO SET in MySQL that I would like to introduce to you. I hope it will be helpful to you. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!