SQL INSERT Command with set optionHere is an example of the sql insert command to add a record using set option.
This will add one new record to the table and values for two fields book_name and author gets added in the new record. This is quite helpful in matching field names to value.
Inserting record with default value or auto-increment fieldIn our student record we already have student id which is auto- increment field hence while adding a record we need no enter its name or value. Other than the auto increment field we can store records to our student table by using set command.
Similarly we need not specify for default value of the fields while adding records
PHP Script using SET commandWe will add one record to our student table by using SET command and PHP Script.We will first connect to database Here is the complete code
Using MySQLI
require "config.php";// Database connection $id=50; $name = 'my_name'; $class='Three'; $mark=70; $sex='male'; $query="INSERT INTO student set id=?,name=?,class=?,mark=?,sex=?"; $stmt=$connection->prepare($query); if($stmt){ $stmt->bind_param("issds", $id, $name, $class,$mark,$sex); if($stmt->execute()){ echo "<br>No of records inserted : ".$connection->affected_rows; }else{ echo $connection->error; } }else{ echo $connection->error; }How to connect MysQLI? Download sql dump of this student table UPDATE record by using SET command ![]()
This article is written by plus2net.com team.
https://www.plus2net.com
![]() ![]() | ||||
| ||||