I have a spring data jpa query that reads a row from a mysql table with a pessimistic lock. In my environment, this table only contains one row so it should be
I have a post and a notification model. notification has a onPostId FK. When a post is deleted how can I let sequelize know to delete all the notifications that
This is working: SELECT * FROM table WHERE name LIKE '%ab_cd%' How to include '%ef_gh%' in a single/multiple statement? My try: SELECT * FROM table WHERE name
Was looking to drop an enum and did it incorrectly by deleting the rows from the pg_enum table. I should have removed it with this: DROP TYPE IF EXISTS "enum_Or
I have a strange problem: There is a price in a JSON column in a table and the following statements give different results while they should give the same thing
I am trying use the data from a column in one table as column aliases of another table. DECLARE var1 VARCHAR(20), var2 VARCHAR(20); BEGIN WITH TABLE1
For example, say I have a clearance pass entity, with basic, intermediate and high level clearance. basic has clearances of x, intermediate has clearances of x
Using a bespoke ERP system with T & A built in. Table 1 has dates with holidays types i.e. bank holidays, user booked holidays - and a user id. Table 2 has
I have a table A with ID's only and another table B with two columns, ID and Product Number. The ID column in table B has nulls and Product Number has Product N
I have a query that upserts the data to the database via Slick. I'd like to return the ids of the entities that were inserted. How can I do this using Slick in
I am getting empty output in the below code but when I remove the part of and I get the desired output. Can anyone clarify if there is any error in syntax of be
I am trying to run the below code. I'm trying filtering on the jira_label field. I'm getting the below error. I know this means I should add aliases and I have
I have files that will be coming in daily that I would like to process as they come in and insert into existing sql tables (using postgres). What is the best wa
i want to add the time, if there is free time as example im doing that with two textboxes where im entering the date Database 20.04.2020 - 20.05.2020 so there s
I have multiple tables, and some do have columns which are related but I am not certain if I have to put the foreign key relations to all columns which are rela
want first 2 occurrence of duplicate ID'S in the output, desired output in image attached. Please help
I am making a join with two tables, tab_usuarios (users) and tab_enderecos (address). tab_usuarios structure: id_usuario nome usuario 1 Administrador admin 2 N
Curent situation Currently I have this PL-SQL script with almost fifty words "hard-coded": DECLARE categoryToSearch VARCHAR2(16); BEGIN catego
So I am trying to run this SQL command Select Replace('[1,2,3,47]','%[0-9]\,|\[|\]%',''); this regex should give the following result 47 however, the original
Over the past day I have been experiencing this error very frequently which results in the cloud instance needing to be reset in order to continue connections: