Skip to content

Tag: sql

Using classes from /target

I am using JOOQ. JOOQ generates meta classes, using with database requests. It’s recommended to generate classes into /target/generated-sources/jooq. But when I try to call these meta classes in code, they are not accessible. Please, tell me what to do. Answer This is the default output location because…

Multiple Join not working on two string attributes

I have the following issue: I have several tables in my Database, in order to check for a specific criteria I have to join several tables, where I use the following statement: This statement fails. But when I remove one the following two join-conditions in the last Left JOIN, it works as intended: F.risk = ta…

Wrongly closed SQL parentheses [closed]

sql

I’m fairly new at writing SQL commands so I don’t exactly know where I’m going wrong here. I closed all the parentheses, but I still get the following error message: Syntax error: Expected “)” but …

How to check if an int contains another one as part of it?

The question is fairly clear. I wanna check if for example a number x is contained in another number y. And I wanna do it in SQL (also in LINQ if possible). Additionally those integer values(y values) are Ids from a table. So when LINQ is concerned, I am not looking for some general solution like: Examples: A…

IS NULL in CASE in predicates

tell me pls, that’s real – use the CASE construct, where the expression with IS NULL/IS NOT NULL will be returned in TNEN? I have a procedure in a package that receives an input parameter and it is …

convert full date string to date mysql

I have database which contains string like this 22 Jan 2019 11:03 I would like to convert this string to date so I apply this query select DATE_FORMAT(STR_TO_DATE(’22 Jan 2019 11:03′,’%d-%m-%Y’…