douqian6315 2018-01-08 04:57
浏览 31
已采纳

在laravel 5中使用cmd插入原始数据

I want to insert data into a table 'adminuser' using command line in laravel 5.

DB::table(`adminuser`)->insert([`id`:`1`,`username`:`admin`,`password`:`password`,`userlevel`:`1`])

But got this error

The filename, directory name, or volume label syntax is incorrect.

May be the syntax is error. But can't find the correct syntax.

Anybody help please

  • 写回答

1条回答 默认 最新

  • dongmu5920 2018-01-08 05:28
    关注

    You can use php artisan tinker:

    in terminal write this command and press enter > php artisan tinker
    
    DB::table('adminuser')->insert(['id'=>'1','username'=>'admin','password'=>'password','userlevel'=>'1']);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?