I have a database which looks like this. My task is to get the columns of dates, number of exams on that date, number of students who write an exam on that date. Something like Date – Exam Count – Student Count. I have done this but in two different queries. Result: edate Exams | =================…
Tag: mysql
SQL entries in French/English and Japanese
I have an old SQL4 database and I’m trying to re-upload it to our newly created database on Phpmyadmin. The characters in the tables are latin and japanese. I tried to change those specific columns but the result is still broken characters for the columns I need to display in Japanese. Here is a screens…
How to Use a Subquery in MySQL in the Where clause that is an argument to an OR operator?
I am trying to filter a table for specific markets by using a subquery. I want to include all null values and exclude the markets that are included in the subquery. This query isn’t filtering out the markets I want to get rid of. And this created a SQL compilation error. When I list the markets I want t…
Variable not defined on VBA about socket
I’m making an edit to a project on VBA that uses a Socket to send information to a program on Netbeans on a specific server. I did not write the code. I’m trying to understand what the original programmer did. I have many forms, and a few send information with that socket. I’m trying to do t…
How to make this Query without using UNION?
I am not very good at making query’s. So could someone explain and help me with this query? I need to inner join 2 tables ‘Slaap’ And ‘Eten’. i need all ‘eten’ where ID = 5 and i need all ‘Slaap’ where ID = 5. I could only achieve this with a UNION but tha…
SQL: join on foreign key between two tables and return only count of items; not actual items
I know there’s lots of questions similar to this out there. I’m writing my first SQL query; and I’ve been looking through SO but I can’t find out specifically what I’m doing wrong, because to me, they …
Can’t delete records from the same table using NOT EXISTS MySQL syntax
I want to perform deletion in the same table. I’ve tried different ways, but I still can’t get it right. So, I got this error You can’t specify target table ‘tb’ for update in FROM clause. I tried aliasing the tables, but nothing done. I can’t figure out what is missing. I …
MySQL trim or get specific set of string using substring locate
I have a column named cea_no from my table. But I want only specific string from it. I already tried several methods but it it wont work for me. Do you have any idea how could I achieve this? Here is my query The result I only want the R017722B part. Removing the “CEA: , the second set of strings
How to check not null date in spring jpa
I have 2 IF. If No 1, is work for me. Because i wont if data is present and get house keeping == null. for action to update condition,status,and housekeeping. IF no 2, no work for me. I wont if getData is present and get housekeeping is availabe / not null. For action only to update condition Only check ̵…
Can SQL replicate Excel’s auto-updating cells based on other cells? [closed]
I have a database of some devices, each with details on their status for things like maintenance schedule, last calibration date, age, warranty status, etc. One of the points of this database is to …