DB::enableQueryLog(); $mines = Cranks::where([['crank_id', '=', $this->crank_id], ['mine_id', 'like', '%'.$script_value->mine_id.'%'] ])->get(); $query
The idea is I'm making a little restaurant app in Java so in this class is given the option to make an order. It works this way: the user writes which products
The query I am supposed to form has to accomplish the following task: Retrieve the names of all employees who work on every project. I currently have three t
I have a HubSpot account where my team updates my customers' details in three sheets such as Contacts, activities etc. Now I want to integrate the data availabl
I have a HubSpot account where my team updates my customers' details in three sheets such as Contacts, activities etc. Now I want to integrate the data availabl
My code against SQL injection isn't working (error message in title). I simplified my code, but its still not working. <?php include "con
Test platform Used - HackerRank | MySQL/MSSQL Recently attempted an code assessment for a job post involving SQL questions. I was able to get the correct output
I had one admin user with username = root (had admin privileges) and password =admin then i created new user with username =root (have no privileges) and passwo
I have a function deployed in GCF which is executed in node js. And it works with Cloud SQL instance of MySQL. And I receive this warning from time to time. Cl
I've started learning SQL on Friday. I'm using pgAdmin4 I'm having trouble with one line on this code: SELECT first_name, last_name, nationality, date_of_birth
I have a table, has field named date with type date. I have a row with date=2021-08-11, I want to perform an update, if table.date is more than 2 days from curr
So I have a query that produces a table like the below, without the avg column. I'm trying to figure out how to add the avg column. The average should be from t
I have created 3 tables: accounts, products, claims. These are the relationships: Accounts: PK - username Products: PK - serial number, FK - username Claims: FK
I'm using Fedora 29. I'm try to run mariadb.service with command:systemctl start mariadb, and give error:Failed to start mariadb.service: Unit mariadb.service n
When trying to install composer in laravel project get this error. Illuminate\Foundation\ComposerScripts::postAutoloadDump @php artisan package:discover
The size of the null value list is one byte in mysql Innodb with compact row format. If there are many columns with null values, won't they overflow.
I want to update the specific column in MySQL after any change occurred in a row. I use below query to create trigger but when to change record data, an error h
I want to merge two tables and subtract the number of orders in resulting table from left join from the resulting table in inner join. This is what I have done
I'm still fairly new to XAMPP and it has been running great until I started work this morning. Here is the error log file information. When I try to start MySQL
I'm running a Docker mysql container on my Mac laptop. Previously I was able to connect to it from the host OS with the mysql client. However, somehow it got de
elasticsearch-watcher