xxxxxxxxxx
<?php
include_once 'database.php';
if(isset($_POST['save']))
{
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$city_name = $_POST['city_name'];
$email = $_POST['email'];
$sql = "INSERT INTO employee (first_name,last_name,city_name,email)
VALUES ('$first_name','$last_name','$city_name','$email')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully !";
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
?>
xxxxxxxxxx
INSERT INTO Campus (Campus_Name, Address, Zip, Phone_No)
VALUES
('Nairobi Campus', '123 Moi Avenue, Nairobi', '00100', 0712345678),
('Mombasa Campus', '456 Kilindini Road, Mombasa', '80100', 0723456789),
('Eldoret Campus', '789 Main Street, Eldoret', '30100', 0734567890),
('Kisumu Campus', '987 Lake Road, Kisumu', '40100', 0745678901),
('Nakuru Campus', '654 Kenyatta Avenue, Nakuru', '20100', 0756789012);
xxxxxxxxxx
INSERT INTO tableName
VALUES (‘anydata’, ‘anydata’, ‘anydata’, ‘anydata’, NULL,
NULL);
xxxxxxxxxx
-- if you want to insert values in all column
-- values must be assigned to that column
INSERT INTO table_name
VALUES
(value1, value2, value3, );
-- ^ ^ ^ ^
-- (column1, column2, column3, )
-- the same arrangement
xxxxxxxxxx
INSERT INTO table_name (column1, column2, column3, )
VALUES (value1, value2, value3, );
/* or if you want to add all the fields*/
INSERT INTO table_name
VALUES (value1, value2, value3, );
insert sql
xxxxxxxxxx
INSERT INTO MY_TABLE (COL1, COL2, COL3, )
VALUES (VAL1, VAL2, VAL3, );
xxxxxxxxxx
INSERT INTO promotions (
promotion_name,
discount,
start_date,
expired_date
)
VALUES
(
'2019 Summer Promotion',
0.15,
'20190601',
'20190901'
),
(
'2019 Fall Promotion',
0.20,
'20191001',
'20191101'
),
(
'2019 Winter Promotion',
0.25,
'20191201',
'20200101'
);
Code language: SQL (Structured Query Language) (sql)
xxxxxxxxxx
insert into toys (toy_id, colour) values ( 3, 'red' );
select * from toys
where toy_id = 3;
xxxxxxxxxx
INSERT INTO table (a, b, c) VALUES (1,2,3)
INSERT INTO table SET a=1, b=2, c=3
xxxxxxxxxx
$sql = "INSERT INTO table_name('arg1, 'arg2', ...) VALUES ('value1,
value2, )'";