loop on a group concat on MYSQL
Issue I am trying to see if this is possible. I have three columns (NAME, TYPE, RATING). I am trying…
Category: MySQL
MySQL query to select items in a linked table based on AND
Issue I have a table tblPhotos of photo details: | photoID | photoName | | ——- | ——— | |…
Fetch dates within the next 5 days from today, from a column of dates
Issue I have a table with dates from last year: ID start_date 1 2020-09-06 11:21:00 2 2020-10-12 01:43:00 3 2020-09-07…
What is the maximum length of string for CONCAT in MySQL (Aurora-MySql)?
Issue I currently have an MySQL (Aurora MySQL based on MySQL 5.7.x) PROCEDURE that takes a stringified list of ids…
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
Issue The problem Im facing while trying to connect to database for mysql. I have also given the database settings…
Get records with max value for each group of grouped SQL results
Issue How do you get the rows that contain the max value for each grouped set? I’ve seen some overly-complicated…
What's the best practice to design a table that would have different fields on different conditions?
Issue I need advice in creating tables where there would be different fields based on a condition. I’m pretty new…
Radio Button Returns 0 Boolean Value Every Time Laravel 8 Bootstrap
Issue Hello, The following code segment is intended to ask the user if they want to be a guest author…
MySQL query – to display higher 'salary'
Issue I have 5 tables: employee table , company table , works table , manages table and dependent table. So,…
How can I execute multiple procedures continuously?
Issue Here is my code: $query = "CALL user_top_categories_score(?, ‘ALL’, 0, 1)"; $sth = $this->dbh->prepare($query); $sth->execute([$user_id]); $category = $sth->fetchAll(PDO::FETCH_ASSOC); $query…