I have a javascript function which is intended to output a 0 if a mysql table doesn't exist and a 1 if it does. But I have not been able to understand why it does not function as intended. function…
I have a regex to validate a decimal value before inserting into MySql database, but there is an issue with it. It is allowing a just the negative symbol with no digits after it. So for example, I'm validating against…
I have a MySQL table, with datetime values in each row. I try to group by two intervals: Date between now and now - 1hour Date betwwen now - 1 hour and now - 2 hour What i do? SELECT…
I have a table with an id column (_id, integer) and a post_id column (_post_id, string) in a tbl_messages table. I would like to make a query where I can know the position of the row in a simple query…
I have the following query: select product_name, (select bid_price from bids where bid_id = current_bid_id) as final_price from items where close_date > '2023/01/01' and close_date < '2023/02/01'; which outputs: product_name final_price ball 20 bat 30 hockey_stick 50 Instead of this,…
I have a jpql as: @Query("SELECT b FROM Booking b WHERE " + "(:officeId is null OR b.officeId = :officeId) AND " + "(:status is null OR b.status = :status) AND " + "(:type is null OR b.officeType = :type)…
I've connected to my MySQL database in a docker container using: docker exec -it ti4-automation-mysql-1 bash And I've logged in using: mysql -u root -p ti4-automation If I want to perform a command: SHOW DATABASES; I get this: It looks…
It wouldn't surprise me if there were already an answer to this type of problem, but I don't know how to ask it. The statement compares the task keys in the task table against the task/tag key combinations in another…
there is a table where some data is populated and have to get single data for every key value Fk| field1 | field2 ==================== 1|r |lo 2 |abcd |mem 3 |efghi |mem 4 |abcd |mem 5 |efghi |mem Trying to…
I cannot see why my defined function does not work. No error message, just no INSERT into the Table... after much help from the community, here is an edit of the intial question with more info: EDIT --------------- TEST 1…