"GitBash": {
"path": "D:\\Git\\bin\\bash.exe",
"args": []
}"GitBash": {
"path": "D:\\Git\\bin\\bash.exe",
"args": []
}CREATE USER 'user'@'%' IDENTIFIED BY 'pass';
GRANT ALL PRIVILEGES ON db_name.db TO 'user'@'%';
where('TimeP1', '>', 'vol1')where('TimeP1', '>', table.fieldName)$raw1 = DB::select("SELECT COUNT(*), AssignedUserName FROM `sla` WHERE (`TimeP1`>`vol1` OR `TimeP2`>`vol2` OR `TimeP3`>`vol3` OR `TimeP4`>`vol4`) AND ((`Status`!=vol5 AND `Status`!=vol6) OR (`Case_new` = vol7)) AND `del`=vol8 GROUP BY `AssignedUserName` ORDER BY `AssignedUserName` ASC");$raw2 = DB::select("SELECT COUNT(*), AssignedUserName FROM `sla` WHERE (`TimeP1`>? OR `TimeP2`>? OR `TimeP3`>? OR `TimeP4`>?) AND ((`Status`!=? AND `Status`!=?) OR (`Case_new` = ?)) AND `del`=? GROUP BY `AssignedUserName` ORDER BY `AssignedUserName` ASC", [
'vol1', 'vol2', 'vol3', 'vol4', 'vol5', 'vol6', 'vol7', 'vol8'
]);