0

Can you insert into more than one row at a time ?

If so would be code be like this INSERT INTO house, size Values (bungalow, 24) (Detached house, 35)

16th May 2020, 1:43 AM
AKINTOBI ABIBAT OLAMIDE
2 Answers
0
You have already written. Just add comma before every next values like. INSERT INTO table_name (house, size) values ( 'bungalow', 24 ), ( 'Detached house', 35 ), ( 'xyz', 30 )
16th May 2020, 1:51 PM
A͢J
A͢J - avatar
0
Thanks
16th May 2020, 3:52 PM
AKINTOBI ABIBAT OLAMIDE