I created this little stored procedure that deletes a row from my 'qrcode' table. Due to the constraint, I update all child rows before, it works fine. However, performing this procedure....deletes all rows from the table!!!! I added a log…
I am using this query to show all the departments and their managers, including the departemnts with no managers, that's why I am using left join. Now I need to delete the departements where there is no manager. This is…
I ran a simple delete query on a telemetries table to clear up some data but cancelled as it was taking really long. I noticed that after I cancelled the query some of the tables (all partitions of the telemetries…
please help me delete from the 'Component' table all records that have the same 'country' and they belong to the same 'Page', leave only one record with the country that has the newest createdAt? Relationship between tables: Page -> PageComponent.pageId…
Very new to PHP. I am trying to delete database entry with DELETE http request sent from axios in REACT. function Delete() { const form = new FormData(); for (var i = 0; i < selected.length; i++) { form.append(i, selected[i]);…
I have a example of cascade delete but it looks too big and complicated, is there a way to shorten this code? protected static function boot() { parent::boot(); static::deleted(function ($parent) { // $versions = $parent->game_versions(); $versions = $parent->game_versions; foreach($versions as…
I have the following query: select u.* from users u left join customers_cards cc on cc.user_id = u.id where u.belongs_to = "ezpay" and cc.id is null It returns users who have not added any card yet. I need to delete…
I have a table with 30 columns. I want to remove all the rows in the table where a subset of columns have all the values in the row as either 0 or NULL. I know that I can write…
I'm trying to delete the records where jsonb have one or more keys. My Data- id jsonb_col 1 [{"unit": "sale", "group": ["spares"]}] 2 [{"unit": "sale"}] 3 [{"member": "j1"}] after deleting for key in (unit, group), my data should be like…
I have a Postgres table with these columns: id int8 , user_id varchar , is_favorite boolean , join_time timestamptz I want to delete some rows in this table with some conditions: Keep a maximum of 10 rows for each user_id.…