laravel migration insert code example
Example 1: insert rows in migrations laravel
public function up()
{
// Create the table
Schema::create('users', function($table){
$table->increments('id');
$table->string('email', 255);
$table->string('password', 64);
$table->boolean('verified');
$table->string('token', 255);
$table->timestamps();
});
// Insert some stuff
DB::table('users')->insert(
array(
'email' => '[email protected]',
'verified' => true
)
);
}
Example 2: how create migration in laravel
//to create migration file in PHP use the artisan command "make"
php artisan make:migration create_users_table
// migration file must follow the naming convention "operation_tableName_table"
//Migration file to add column naming convention would be "add_tablename_table"
Example 3: laravel migrate in production
\Artisan::call('migrate',
array(
'--path' => 'database/migrations',
'--database' => 'dynamicdb',
'--force' => true));
Example 4: Generate Laravel Migrations from an existing database
composer require --dev "xethron/migrations-generator"