I need to update the value of pm_virtual.meta_value = 'no', only for those products that have pm_downloadable.meta_value = 'yes'. How do I do this? SELECT p.ID, p.post_title, pm_downloadable.meta_value AS downloadable_trait, pm_virtual.meta_value AS virtual_trait FROM xhdps_posts AS p INNER JOIN xhdps_postmeta…
I have a table of data with multiple columns and containing a column named 'weight' set to VARCHAR character type. It contains a mix of characters such as '400', '203.12', and '602.35 grams', and NULL values. Task is to clean…
I have table 1 and table 2, where Table 1 is master table and Table 2 is child table. Relationship of both table has been implemented by primary key of table 1(id) with table_1_id column in table 2. I need…
I have a .sqlite file in a local folder. I would like to update all URLs in this SQLITE file across all tables, indicies, and rows. What is the best way to do this? In a regular sql file I…
According to tests both SQL give the same result. alter table public.company add constraint company_name_key unique ("name") vs. alter table public.company add unique ("name"); PostgreSQL (ver. 12.16)
I am trying to get a count of the below-noted SQL query. It will output the max value of the scan_freq column and I want to get a count of the rows of it. eg: The below query returned 1096…
I have following timeseries data table, Id Object_Id Datetime Sensor1 Sensor2 1 175 '2022-03-24 22:01:00' 0 0 2 175 '2022-03-24 22:02:00' 0 0 3 175 '2022-03-24 22:03:00' 5.5699381666667 81.342836833333 4 175 '2022-03-24 22:04:00' 5.5668366666667 81.281143 ... ... ... ... ...…
I have a text file with several hundred thousand primary IDs of rows I need to delete from a MySQL database of ~20m rows. What's the best way to do this?
I've just started working in an Oracle database after years of using MySQL and I'm a little confused about the grouping differences. As a starting point, let's say I have this project table: id name created 1 Created on September…
I have a query SELECT name FROM people WHERE age IN ('34','34') There is only one row with column age of 34, but I want to return that row 2 times since 34 appears twice in the array. Any solutions?