mysql select row between 2 time
i have a table with time slots, one column with start time, one colun with end time, 12 slots time per day, example : start end value 101 230 10 231 400 11 401 500 12 2216 100 9 integer…
How can I do this query in sequelize – Mysql
SELECT * FROM item_master WHERE project_id IN (SELECT id FROM project_master WHERE workspace_id in (SELECT id FROM workspace_master WHERE company_id = 4)); How can I do this mysql query in sequelize - node js without using raw query?
Duplicate records after multiple table join in SQL – Mysql
I have a table called main_table and it has the following records cust_id start_date end_date 10001 2022-12-01 2022-12-30 10001 2023-01-03 2023-02-01 I have another table called penalty_a_type and it has the following records cust_id start_date end_date penalty_a 10001 2022-12-01 2022-12-30…
mysql subselect on group by
I have a table of locations CREATE TABLE `asset_location_rel` ( `a_id` int(11) NOT NULL, `asset_id` int(11) NOT NULL, `location_id` int(11) NOT NULL, `deleted` int(11) NOT NULL DEFAULT 0, `units` int(11) NOT NULL DEFAULT 1, `unit_type` tinyint(4) NOT NULL ) ENGINE=InnoDB…
Including All Fields in MIN/Group By Query – Mysql
I have created my first MySQL query to get the minimum LTP by MarketName/SelectionName. It works ok but I'm struggling to work out how to get the rest of the fields from the original table (checktable). I just want the…
import csv with backslash – Mysql
I am trying to import a csv file inside mysql using a php page. I have a problem with it being ignored. How can I do to solve it? I leave the code of the import.php file, thanks in advance.…
Empty table row when location id changes – Mysql
I have a data table which contains hundreds of records and each record has a location id. What I am trying to do is echo out all the records with a line break when the location id changes. The SQL…
Inserting a column value in between row value – Mysql
In my database I have 1000+ rows of data that I need to modify a bit. The content column. I've given it try and the closest i've come was using RPAD UPDATE TABLE_NAME SET content = RPAD("mySlides/", LENGTH(username)+9, username); Using…
Regenerate all integers in a pk column from zero and keep previous value in another column – Mysql
I need to regenerate all primary key numbers from zero and keep previous amount in ex column but the query doesnt work : update mh_product AS p,(select p.id AS oldid,row_number() OVER (order by p.id asc)-1 AS newid from p) AS…
Mysql join showing wrong result in sql
I am working on PHP with mysql, Right now i have following two tables,And i want to display minimum value according to collection id,Here is my first table "nft_info" id collection_id name 1 18 abc 2 18 xyz 3 19…