Issue
In Laravel 6.x is any way to run raw SQL query without any expected result?
Like this one:
$query = 'INSERT INTO product_copys (SELECT '. implode(',', $myColumArray) .' FROM products)';
I tried this:
DB::run($query);
...but it said FatalThrowableError: Call to protected method Illuminate\Database\Connection::run() from context 'Illuminate\Database\DatabaseManager'
.
Any idea?
Solution
did you try DB::statement() ?
$query = 'INSERT INTO product_copys (SELECT '. implode(',', $myColumArray) .' FROM products)';
DB::statement($query);
Answered By - Sok Hai Answer Checked By - Willingham (PHPFixing Volunteer)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.