I am sure there is a similar question, but I am unsure what to search to find my answer (If you know what I am looking for, please just comment with the link or whatever you do). I need a…
The table has columns English, Spanish and French. Each with yes or no values and i want to count the number of yes and no for each column into one table. I tried using distinct count but it cannot put…
So I dropped all the users in mysql.user and restarted the mysql database. Now I can't seem to get into the mysql again or how to reset it as if it was a clean install. I tried uninstalling it with…
I want to update the sort_id for all my users. For example, since there are 10 users, I want to specify sort_id from 0-9 respectively. I can do it using foreach in PHP, but it causes a lot of performance…
I am struggling to figure this out, I have a simple MySQL table (test_scores) that is three columns, id(students), date and test grade. id date grade 1 10/20/22 A 2 10/20/22 B 1 11/1/22 F 2 11/1/22 C 3 11/1/22…
I have the following SQL table called 'content': language contentId text en 1 Hello de 1 Hallo en 2 World My goal is to query all rows which match language='de'. But if a row with language='en' exists which has no…
Before anything, thanks you, english isn't my native language and i'm sorry for any mitsake i would make. If my question is stupid, i'm sorry too. I'm making an application, that allow to export some tables in different format csv:…
I have a problem on my application, it is a social network. The user can create a post with a message and an image, stored in a backend images folder thanks to Multer. I use sequelize and MySql. When I…
I am facing a problem while calculating the quotation amount for my photography project. Assume an Indian wedding has many events like Engagement, Haldi,Marriage, Reception etc., Pricing will be determined based on the number of events selected. A user can…
How could I convert this: SELECT CONCAT (c.first_name, ' ', c.last_name) AS customer, SUM(CAST(p.amount as float)) AS total_amount FROM customer c INNER JOIN payment p ON c.customer_id=p.customer_id GROUP BY c.customer_id ORDER BY total_amount desc LIMIT 1; Into a subquery that…