Convert columns into rows in mysql
I have two tables with same structure. One table contains old value and another table contains new value of all columns. I want to get out out as columns as 1 column and old and new value row wise with…
Make MYSQL query shorter but with the same result
I have a table in which the possible value is null, 0, 1 and 3. I have to select only the null and the value equal to 1 in strict order. The query I have is to long. Can you…
Postgresql – Where is using a table name as a "row value" documented?
SELECT * FROM table WHERE NOT (table IS NOT NULL); finds all the rows in table that have a null value in any column. The logic is clear (see answer), but want to understand this syntax. A statement in an…
Postgresql – Split time range into range for whole days and the remaining hours before / after
In Postgres, given a collection of date ranges like: meter_id device_id start_at end_at meter1 device1 2020-01-02 10:30 2025-01-02 14:00 meter2 device1 2020-01-02 10:30 2020-01-02 11:30 meter3 device1 2020-01-02 10:30 2020-01-03 11:30 I want to bucket the ranges into: a range…
Postgresql – postgres join get data from left table only if no matching found in right table and get matching data also
Hi I am working in postgres. I have below table contract_para contract_para Id 1 2 3 4 5 contract_lines Id | para_id 1 | 1 2 | 2 3 | 3 Output contract_para_id | contract_lines_id | contract_lines_para_id 1 | 1…
Mysql – Selecting dates of month based on existing rows
I have a table with the following schema: `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `bookingDate` date NOT NULL, PRIMARY KEY(`id`) I need to get all dates of the current month where there's less than 5 bookings. (meaning where less than…
Php – Hide out of stock products via cron job in Prestashop
I'm running the code bellow via cron jobs in order to disable out-of-stock products from been displayed on my web site. Could anyone who knows the prestashop's database structure helps me to add an exception for 2 product categories with…
Mysql – How to go through each of the entry for a particular ID in the table and classify the IDs?
I would like to go through all the IDs and classify each ID as Car only, Bike only, both, and ignore anything with truck. In the end I would like to see only one ID with specific Product_category. Structure of…
ERROR: invalid regular expression: invalid character range in postgresql
Trying to insert right row but can't because it violates check constraint Table: CREATE TABLE IF NOT EXISTS public.authors ( au_id character varying(11) COLLATE pg_catalog."default" NOT NULL, au_lname character varying(40) COLLATE pg_catalog."default" NOT NULL, au_fname character varying(20) COLLATE pg_catalog."default" NOT…
Mysql left join and sum of one column issue
I have 2 tables: Table tms_bills id load_id company_name 1 11 company1 2 11 company1 3 11 company2 4 12 company3 Table tms_payments id amount payment_associate_id 11 100 2 12 200 2 13 200 3 14 50 6 I want…