Friends, I am trying to divide two COUNT(*) from MySQL: I have this query: SELECT 'Total ', COUNT(*) FROM root4 WHERE str_to_date(DATE, '%d.%m.%Y') = CURDATE() UNION SELECT 'Good', COUNT(*) FROM root4 WHERE str_to_date(DATE, '%d.%m.%Y') = CURDATE() AND testresult ='OK' The…
I have a Mysql junction table user_connections which maps the users table with the following columns: user_from and user_to, both are foreign keys in users table. user_from and user_to are both primary keys therfore a parttern like (1,2) and (1,2)…
` import datetime now = datetime.datetime.now () tgl = now.strftime("%Y-%m-%d") y = now.strftime ('%H:%M:%S') print(y) >>> 20:01:10 crsr.execute("SELECT * FROM tblsolar WHERE tanggal LIKE '%s' AND id LIKE '1001' ;" % (tgl)) res = crsr.fetchall() for i in res: z…
Suppose I have these MySql tables: TABLE_PEOPLE id name 1 John 2 Albert 3 Joanna 4 Mike 5 Norton TABLE_COLOR id people_id colors 1 1 Green 2 1 Red 3 3 Yellow 4 3 Blue 5 2 Green 6 4…
I am trying to put a regexp constraint on a field "StaffAdress" such that it should only end with " street". This is my attempt, but it still doesn't seem to be valid. I tried regexp '.*street$' and regexp 'street$'…
I'm looking to improve the query performance of the following mysql query: SELECT * FROM items WHERE items.createdAt > ? AND items.createdAt + items.duration < ? What are the best indexes to use here? Should I have one for both…
So i'm trying to make a old project work again but when i put back my tables to the new database i'm having this issue ERROR 1005 (HY000) at line 777: Can't create table ****.#sql-3f2_45 (errno: 150 "Foreign key constraint…
Hi I would like to add here a case sensitive error trap on my login function, by the way i am using MVC FRAMEWORK anyone be of help ? I want to make the username and password case sensitive so…
Having a couple of syntax errors in this code. I am having the "Loop is not valid at this position expecting if" at "loop", "statement is incomplete" at "END$" and "@commission is not valid at this position". DELIMITER $$ CREATE…
I wrote this query to display the "estado" rows if they don't have the values "entregado" or "cancelado" everything works fine The problem is that if a status row "estado" has the NULL value, it is not displayed, why? How…