Tag: mysql

Mysql many to many relations. Filter exact match

Hello. I want to select dishes which has the only the exactly selected ingredient alias? For example: Ingredient alias table: +—-+———-+ | id | Name | +—-+———-+ | 22 | potato | | …

Calculate read pages through select query in reading progress table

database mysql sql

I have a small program that I use to track my progress in reading books and stuff like goodreads to know how much I read per day. I created two tables for that, tbl_materials(material_id int, name …

How do I display two different sums of the same price with different parameters?

mysql sql ssms

I need to get the SUM of 2 different Totals. One is just the Total and the second one is the Total that only includes products that are sold for less than $25. SELECT SUM(Price) AS Total FROM Sales (…

Use of Regex in SQL query

mysql regex sql

create table numbers (number varchar(10)); insert into numbers (number) values (‘9999999999’), (‘5532003644’), (‘1212121205’), (‘1103220311’), …

Allowed memory size exhausted when I use “OR”

mysql phpmyadmin sql

In my database, I want to filter the data by date : I have multiple checkbox for that. When I check 2018-2019 for example, I want to get every information between ‘2018-09-01’ and ‘2019-08-31’. I …

SQL group by get latest results

mysql mysql-workbench sql

My question is in the picture: SQL query

SQL (?) How to parse parent category from breadcrumb to update fields with parentIDs?

command-line mysql parsing sql

I have a bit of a tricky problem hoping someone can help me with. I have a category structure that includes: id category path category name Example: 1 Root/Arts Arts 2 Root/Arts/Animation …

Select data that wont expire in the next 60 days

mysql select sql

I’m trying to select data that won’t expire in the next 60 days so far I have this $sql = “SELECT id FROM cooler WHERE expiry_date > CURDATE()”; which only shows data that has not expire.

MySQL to select max value between on and off time stamps plus 3 seconds

mysql sql

There’s a transporter inlet valve sensor which data is collected to a MySQL DB table showing the intake valve open and close cycles with the time stamps. There’s also a live weight sensor which data …

My Left Join Query in mySql gives duplicate results even after using DISTINCT?

inner-join left-join mysql select sql

I have tried many solutions to get rid of Duplicate results in Query but no use. Here are my tables: sparepartorderdetails d table: id —– SparePartID ——–OrderID ——– Qty —– Price 101-…