For the artists currently in bands, the value is null. How can I calculate how long they have been in the band if the value is null using mySQL? I was thinking of doing something like this, which only works for artists who have left a band. Answer I haven’t done SQL for a while so please bear with me.
Tag: database
MYSQL: Insert with Select not working properly
I can’t seem to debug this issue. I am currently running to set person_id to -1, but also utilize a select statement with this person_id value. Using this statement, I cannot find any reason online …
MYSQL – How to check if a column has value or is it null and another column has value like 10
Lets say i have a table with 3 columns id, user and status. I need to find rows which have status as 1 or null and user = ‘someName’ I am lookin for a condition like this: if (user == ‘name’ && status == 1 || status == null) How do i do this in mysql Answer Just: This can
MySQL – removal of duplicate results in JSON_ARRAYAGG in the presence of GROUP BY
I have query: The result of this query duplicates the same image urls in column urlLinks: How can I leave as a result only unique image urls? GROUP BY cannot be removed from the request!!! Answer JSON_ARRAYAGG() does not support DISTINCT. You can SELECT DISTINCT in a subquery, and then aggregate: Demo on DB F…
Do triggers take a lot of computation?
When implementing “Triggers” , is it required to check the criteria/condition for trigger WHENEVER a change is made? If it is so, can someone have a large number of triggers? Or else, how is it done?
Difference between using a database driver and subprocess [closed]
I always using a driver for database adapter because thread safety. But I have seen that some developers (specially system engineers) using subprocess for database queries, something like this: …
How to minimize my query to fast the query time in my navicat?
FROM table p WHERE p.column = 0 ) as zxc ORDER BY zxc.column DESC Answer Please try this change-
How to represent X and Y axis data in an SQL table
I have a table of data in excel that looks like this: I need to get this data imported into an SQL table. Eventually I need to be able to query the table by saying something like: Select the value where x-axis equals 762 and y-axis equals 889 – this should return 30.60. What is the best way to represent
My SQL Python ProgrammingError: 1064 (42000) [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 2 years ago. Improve this question I am trying to store scraped data with scrapy to a sql database but I…
MySQL Query Help for Multiple Tables
Alright so I’m working on a final assignment and I’m super stuck on this one task. I’ve tried looking it up and reading guides and I got nowhere. To make matters worse, my professor hasn’t bothered to teach us how to do this particular type of task and I can’t bother asking him f…