Tuesday, March 3, 2026

How to add multiple records with insert query in MYSQL

   INSERT INTO new_registration

(

`Ownership_Category`,

`Is_Govt_Org`,

`Title_Category`,

`Nationality`,

`Owner_Name`,

`Owner_Pan_Card`,

`Upload_pan_card_Document`,

`Mobile_No`,

`Email_ID`,

`PinCode`,

`State`,

`District`,

`City`,

`Address`,

`DOB`,

`Upload_DOB_Certificate`,

`GST_No`,

`Upload_GST_Certificate`)

VALUES

(

'Individual',

1,

'News Paper',

'Indian',

'Yash Kapoor','45YYH87Y','Documents/test1.jpg',

457851,'test@test.com',

110022,'Haryana',

'Sonepat','Sonepat','Jangpura, Delhi',

' 15/01/1945', 'Documents/test1.jpg' ,

'JHJDFHJDF8787DF',

'Documents/test1.jpg'),

(

'Individual',

1,

'News Paper',

'Indian',

'Yash Kapoor','45YYH87Y','Documents/test1.jpg',

457851,'test@test.com',

110022,'Haryana',

'Sonepat','Sonepat','Jangpura, Delhi',

' 15/01/1945', 'Documents/test1.jpg' ,

'JHJDFHJDF8787DF',

'Documents/test1.jpg'),

(

'Individual',

1,

'News Paper',

'Indian',

'Yash Kapoor','45YYH87Y','Documents/test1.jpg',

457851,'test@test.com',

110022,'Haryana',

'Sonepat','Sonepat','Jangpura, Delhi',

' 15/01/1945', 'Documents/test1.jpg' ,

'JHJDFHJDF8787DF',

'Documents/test1.jpg')

No comments:

Post a Comment