{"id":11726,"date":"2020-03-05T12:10:18","date_gmt":"2020-03-05T12:10:18","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=11726"},"modified":"2021-11-12T06:41:22","modified_gmt":"2021-11-12T06:41:22","slug":"tinker-command-and-how-to-insert-data-in-database-using-tinker-in-laravel","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/tinker-command-and-how-to-insert-data-in-database-using-tinker-in-laravel\/","title":{"rendered":"Tinker Command and How to Insert Data in Database using Tinker in Laravel."},"content":{"rendered":"\n

Tinker Command(php artisan tinker<\/strong>) is used to interact directly with the database <\/strong>table to insert<\/strong>, delete<\/strong>, update <\/strong>data. It executes SQL <\/strong>commands through the command line<\/em>. <\/p>\n\n\n\n

When we run the tinker <\/strong>command, it will open a shell <\/strong><\/em>where we can execute php commands<\/em>. See below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

How to use tinker in our project. <\/h1>\n\n\n\n

To use tinker, we have to make a migration in which we define a table and also defines the column. Make migration by using php artisan make:migration Name –create=Table_name<\/strong> command and define columns as I defined. See the below image:-<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

In the above example, I defined 4 columns of Name<\/strong>, E-mail<\/strong>, Location<\/strong>, and created_at<\/strong>, and also defined default values <\/strong>because if we can’t provide the value of any column then it assigns the default value in the database rather than giving error.<\/p>\n\n\n\n

If we can’t provide a default value and adding the value of one column then, it gives an error that “This field is required<\/em>” so we define a default value in each column to overcome from this type of error.<\/p>\n\n\n\n

How to Insert Data in Database using Tinker.<\/h1>\n\n\n\n

To insert data in database table we use below PHP command. See below:-<\/p>\n\n\n\n

Syntax<\/strong><\/h2>\n\n\n\n

DB::table(“Table_Name”)->insert([“Column1″=>”Column1_data”, “Column2″=>”Column2_data”, “Column3″=>”Column3_data”);<\/strong><\/p>\n\n\n\n

For Example:- My table name is tinker and i’m inserting Name<\/strong>, E-mail<\/strong>, Location,<\/strong> and time indication created_at<\/strong> as mentioned above. See the below image what happened when i executed the command.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Let’s See in Database, my data added or not.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

What happens when we insert value only for one column.<\/h1>\n\n\n\n

When we insert a value in only one column then, other columns filled by default value as I said above. See the below image for help:-<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Let’s see in the Database, Other columns are filled with a Default value or not.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

How to insert multiple Row’s in Database(Multiple rows Insertion). <\/h1>\n\n\n\n

To insert multiple rows in the database we use below syntax:- <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

See the below Program to understands better:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Now, let’s see the database that our data was inserted or not.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n