Specified key was too long error in laravel 5.4 in case of old mysql / mariadb

use Illuminate\Support\Facades\Schema;

public function boot()
{
    Schema::defaultStringLength(191);
}



changed to AppServiceProvider.php file

mysql default database

mysql has 4 default database

• information_schema
• mysql
• performance_schema
• says

export and import in mysql

mysqldump -p -uroot <databasename> > location/backup.sql
mysql -p -uroot <databasename> < location/backup.sql;

Seeding database in Laravel

Using php artisan make:seeder
=========================

php artisan make:seeder PeopleTableSeeder
inside PeopleTableSeeder class

<?php

use Illuminate\Database\Seeder;
use Faker\Factory as Faker;
use Carbon\Carbon;

class PeopleTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
      $faker = Faker::create();
      DB::table('people')->insert(
          [
            'first_name' => $faker->firstname,
            'last_name' => $faker->lastname,
            'age' => rand(10, 44),
            'created_at' => Carbon::now()->format('Y-m-d H:i:s'),
            'updated_at' => Carbon::now()->format('Y-m-d H:i:s')
          ]
        );
    }
}

In DatabaseSeeder class

$this->call(PeopleTableSeeder::class);


For multiple entry
======================
 DB::table('people')->insert([
   [], []
 ]);


Using PHP factory
====================
$factory->define(App\Person::class, function (Faker\Generator $faker) {
    return [
        'name' => $faker->name,
        'first_name' => $faker->firstname,
        'last_name' => $faker->lastname,
        'age' => rand(10, 44)
    ];
});

In DatabaseSeeder class

factory(Person::class, 100000)->create();

sass variable completion in sublime all auto completion

just add a new setting in side user setting json file

"word_separators": "./\\()\"':,.;<>~!@#%^&*|+=[]{}`~?",