Laravel Insert Data Using Core sql query

  • 31-12-2022
  • 452
  • Laravel 9
  • Haresh Chauhan

If you wish to insert data in the MySQL database using core sql query or want to insert using DB statement in the laravel this post example will help you.

In this post I am inserting data in the database using DB::statment(), Query builder in the laravel allows us to accept core SQL query statements to execute and insert data in the MySQL database.

Here I am providing an example of laravel query builder DB::statment(), I have an India state which having in core SQL query base so I want to insert directly using the laravel query builder. see below example of how to insert in laravel.

DB::statement("INSERT INTO `states` (
     `name`,
     `district`,
     `delivery`,
     `created_at`,
     `updated_at`
) VALUES
('Andhra Pradesh', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Arunachal Pradesh', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Assam', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Bihar', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Chhattisgarh', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Goa', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Gujarat', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Haryana', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Himachal Pradesh', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Jammu and Kashmir', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Jharkhand', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Karnataka', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Kerala', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Madhya Pradesh', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Maharashtra', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00'),
('Manipur', NULL, 'Yes','2022-11-23 12:00:00','2022-11-23 12:00:00')");

We always thanks to you for reading our blogs.


dharmesh-image

Dharmesh Chauhan

(Swapinfoway Founder)

Hello Sir, We are brothers origin from Gujarat India, Fullstack developers working together since 2016. We have lots of skills in web development in different technologies here I mention PHP, Laravel, Javascript, Vuejs, Ajax, API, Payment Gateway Integration, Database, HTML5, CSS3, and Server Administration. So you need our service Please Contact Us

haresh-image

Haresh Chauhan

(Co-Founder)


We Are Also Recommending You :