I'm having results I don't understand from a MySQL query that should be pretty simple. The goal I want to achieve is more complex, but I have reduced the problem to this: When I am using NOT IN subquery in…
I'm having trouble on joining three tables. First attempt on joining two tables is success, but on third table the results are not correct... I have three tables machine_list is mainTable then applicable_rpm and applicable_product are some details of machine_list…
I am designing a database for a web project in which I am trying to collect users' emotional feelings toward art collections. A hybrid dual list on the website allows users to select three options from 12 options and then…
I am working on node js and mysql here i am using profile incomplete or complete logic so i have to check all the fields or empty or not so i have 28 fields i have used 28 if else…
I have a problem, I am making an insert using the concat to generate multiple inserts, however I realize that a null field is affecting all the queries, since the records that have null in their field, their insert is…
I have two tables Name & Zip, and i want a query to return the zip codes which are having more than 2 plans associated with one different name +------+------+ +------+------+ | TABLE: NAME | | TABLE: ZIP | +------+------+…
Working on an application and it's a bit of a mess with its encoding protocol. The application currently uses php_value default_charset ISO-8859-1 but also in places does <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> The MySql charset is Latin-1 (ISO-8859-1) so explains…
I have several millions of files and each file may have several thousands of functions. I have to store the names of these files and functions in a MySQL table to display this in a UI. The file names will…
SELECT f.user_id, f.item_id, f.status, f.shipped, CASE WHEN f.status = 0 THEN UPDATE f SET f.status = 1 WHERE f.user_id = 1 AND f.item_id = 1 WHEN f.status = 1 THEN UPDATE f SET f.status = 0 WHERE f.user_id = 1…
I want to retrieve all buy orders with a count of matching buy orders in a single query. A match would be a sell order that satisfies all attributes (greater or equal) and is cheaper than the buy order. Is…