General error: 1364 Field city_id doesn't have a default value

I have upgraded the MySQL from 5.5 to 5.6 and then getting below type of errors.
General error: 1364 Field 'city_id' doesn't have a default value

(I was not getting such type of error, it must come after upgrading my MySQL Version from 5.5 to 5.6)

Solution: It have 3 Solutions

1. In Your Code (PHP), always set a default value (if no value) before save.
   

   $objSaveData->saveData(
       array(
           'id'=>111,
           'name'=>'New user',
           'city_id'=>0, //default value
       );
   );
   

2. Create fields with default values set in datatable. It could be empty string, which is fine for MySQL server running in strict mode.
   like below:

   ALTER TABLE `users` CHANGE `city_id` `city_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';
   

3. Disable MySQL Strict Mode (Most appropriate)
   Disable it by setting your own SQL_MODE in the my.cnf file, then restart MySQL.
   
   Look for the following line:
   

   sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

   Change it to:

   sql-mode="" 

   Restart the MySQL Service.
   

Laravel Interview Questions and answers

Question: What is Laravel?
Laravel is a free and open-source PHP framework that follows the model–view–controller design pattern.


Question: What is the latest version of Laravel?
7.0, released on 3rd March 2020.


Question: Who created Laravel?
Taylor Otwell


Question: Who created Laravel?
Taylor Otwell


Question: What language does Laravel use?
PHP


Question: Which is the best IDE for Laravel?
Netbeans,
PhpStorm,
Atom,
Sublime Text


Question: Features of Laravel?

1. Eloquent ORM
2. Reverse routing
3. Restful controllers
4. Migrations
5. Unit testing
6. Automatic pagination
7. Database Seeding
8. Query builder available

Question: What are the new features of Laravel 7?
Laravel 7.0 is incorporated features such as Better routing speed, Laravel Airlock, Custom Eloquent casts, Fluent string operations, CORS support, and many more features like below.

1. Custom Eloquent Casts
2. Route Caching Speed Improvements
3. HTTP Client
4. Query Time Casts
5. Blade Component Tags & Improvements
6. Laravel Airlock
7. CORS Support
8. Fluent string operations
9. Multiple Mail Drivers
10. New Artisan Commands etc

Question: How to extend login expire time in Auth?
Open config\session.php file and add/update following key's value.

'lifetime' => 180

Question: What is middleware in Laravel?
Middleware operates as a bridge and filtering mechanism between a request and response.


Question: How to pass CSRF token with ajax request?
In between head, tag put

[meta name="csrf-token" content="{{ csrf_token() }}"]

In Ajax, we have to add

$.ajaxSetup({
   headers: {
     'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
   }
});

Question: What is laravel Service container?
Service Container is a powerful tool which is used to manage class dependencies and perform dependency injection. Also known as the IoC container.


Question: How to use session in laravel?
Retrieving Data from session

session()->get('key');

Retrieving All session data

session()->all();

Remove data from session

session()->forget('key');

Storing Data in session

session()->put('key', 'value');