I'm trying to select the row that contains the largest number and have accomplished it using this fairly simple query: SELECT s1.score, name FROM scores s1 JOIN ( SELECT id, MAX(score) score FROM scores GROUP BY id ) s2 ON…
Is there any tool or programming technique to capture the output from Yii2 migrations to up/down SQL scripts, that is, print the migration corresponding raw SQL before finally running php yii migrate? For example, in Laravel you can add a…
I have the below query that takes so much time >> table size 64.31GB are there any rewrite possible for this? SELECT MIN(ut.id) AS minUT, MAX(ut.id) AS maxUT FROM user_tasks ut JOIN user_tasks_metadata utm ON utm.user_task_id = ut.id JOIN ue_events_base…
I would like to insert multiple rows in a table. All of these rows will have the same values. The number of rows is not fixed but come from an input label in the frontend ($Num variable). How can I…
I have a table of users who have subscribed to different plans of a streaming services and other data about the said users. Something similar to this, Name Plan Status Subscription Date Cancel Date Ajax 5-user Active Jan 2021 -…
Suppose I have a table 'results' that looks like this: student | score | passing_grade 1 | 50 | 70 1 | 30 | 50 2 | 90 | 50 2 | 80 | 100 I want to count, for…
Is there a way to set at the time of creating a table a custom ID with some character as prefix and the rest are numbers which is auto incremented so that the first time a record is inserted the…
Probably it's super simple but i've been stuck some hours on this. I have a column called "Publish_Date" which is a varchar, but my date shows like this: 17.01.11 (year.day.month) and I want to convert it to a date (at…
cust_id state 1 CA 2 IL 3 SC 1 PA 3 IA 4 MO 5 VA 4 NY Can any one please advise on SQL Query that return the cust_id that belong to two states as below: The output should…
I experimented if non-repeatable read and phantom read occur or not with SERIALIZABLE on MySQL but against my expectation, both non-repeatable read and phantom read actually occurred with SERIALIZABLE. These below are the definitions of non-repeatable read and phantom read:…