For some reasons my query is running perfectly in MySQL WorkBench but when added to the repository I am getting syntax error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version…
If I have a column with different values called vStatus (member-staus with value 100 - 200 - 300 etc.) in MySQL with diferent values, and I want to place those users in 3 columns in a table like this: <tr>…
I'm trying to optimise the Digital Ocean droplet that my Laravel web app is running on, and have noticed that MySQL is constantly using ~50% of its 1GB RAM. By far the most common and well-attested method for decreasing MySQL's…
I've the following table. CREATE TABLE Worker ( WORKER_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, FIRST_NAME CHAR(25), LAST_NAME CHAR(25), SALARY INT(15), JOINING_DATE DATETIME, DEPARTMENT CHAR(25) ); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (001, 'Monika', 'Arora', 100000,…
I have a virtual machine with 64 vCPUs and 256GB of memory. Recently, I decided to perform some stress tests on the website that is running on this virtual machine. The entire VM is only for this website. The first…
I need a database with two tabels. I need to JOIN them, group the records and then display top 5 rows from each group. Here is my initial query without top N records: SELECT customerId, itemId, count(itemId) as num FROM…
Table01 with columns | Id1 | CommaSeparated | | 1 | 1,2,3 | | 2 | 4 | | 3 | 7,8 | Table02 with columns | Id2 | SomeValue | | 1 | Value01 | | 7 | Value02…
This is my current code, when executed will return no results. (Query1) // Get all product categories that has a relation $product_categories = ProductCategory::whereExists(function($query) { $query->select('id') ->from('restaurants') ->whereJsonContains('restaurants.restaurant_categories', 'product_categories.name'); })->get(); // Log dd($product_categories->toSql()); Here an sql query dump select *…
could here someone know please? Wordpress redirected to similar parent page if this exists, I need to add redirect to 404 For example I’ve created page Website.com/parent1/child2 If I put Website.com/parent2/child2 It’s redirected me to Website.com/parent1/child2 So I need to…
I want to use CodeIgniter 4's Models' ability to automatically set the created_at, updated_at, and deleted_at fields in database tables. For that, should I set those fields as TIMESTAMP in MySQL or DATETIME? If I set them as TIMESTAMP, I…