I have the following table and i am supposed to count the entries(5,4,3,2,1) per column name ID ClientID Responsiveness1 Responsiveness2 Reliability1 1024 3511 5 4 3 1025 4571 5 3 5 1026 3827 4 5 4 1027 7652 1 1…
I'm new to MySQL, and I'm struggling with a homework problem: Get the name and initials of each player who has incurred two or more penalties of more than $40. Hint: use subquery that has an aggregate I can get…
I have a log table that records user events. These are ordered by a timestamp. id event user context timecreated 5 login 234 0 65535 8 open 234 5 65536 13 open 234 9 65539 17 open 234 8 65512…
here i need an help like how to optimize this union all query the table has index for where clause column but it's not picking it up and i even tried with force index none of that works any better…
In my laravel project I am currently doing some testing with database seeders to check the performance with many database entries. In my project I have a Model FlightView using a SQL view as database by doing protected $table =…
Edit: EXPLAIN result for the first two queries when using src_cus_lang: EXPLAIN result for the last two queries when using cust_lang_src: Original post: I'm using MySQL and have a table as follows: CREATE TABLE tm( id INT AUTO_INCREMENT PRIMARY KEY,…
I've created my first api in Laravel, and I'm having trouble generating the database from the migations. Every time I run php artisan migrate even after using composer dump-autoload and generating again the database it doesn't work. It gives me…
Let's say that I want to send the following SQL query to the MySQL server: SELECT * FROM students; Which character set will be used to encode the above statement, and which character set will be used to encode the…
In MySQL I have a table with zipcodes and cities. In the database fx. Copenhagen (København) i shown as København, but written in PHP it is correctly shown as København. The table is utf8_general_ci. When I want to get the…
so here is the schema for the JSON : { "ts": 1677330162, "uuid": "75e4917d-69cd-49e1-963f-380ea031a88b", "moderators": [ { "userId": "000001", "timeAdded": 1677332262, "permissions": { "all": true, "tag": true, "mail": true, "posts": true, "access": true, "config": true, "analytics": true } } ],…