I have 2 Tables Like these: region Table: +----------+-------------+ |region_id | region_name | +----------+-------------+ |1 | RN1 | |2 | RN2 | |3 | RN3 | +----------+-------------+ and role Table: +----------+-------------+ |role_id | role_name | +----------+-------------+ |1 | admin |…
I need to know if the following can be resolved with a SQL query and how. I have done it with PHP in different ways but the memory skyrockets and the server takes a long time to return the results.…
I have this code: <?php $count_item = mysql_query("SELECT * FROM stdevice JOIN stlocation ON stdevice.location = stlocation.stdev_id JOIN device_name ON stdevice.dev_id = device_name.dev_id WHERE dev_name LIKE '%$dev_name%' AND stdev_location_name LIKE '%$stdev_location_name%' AND dev_serial LIKE '%$dev_serial'"); $count = mysql_num_rows($count_item); ?> This…
I have upgraded MySQL database to 8.1 release But I can’t extract two random days from month and year from my MySQL table On this table, I have stored all days from each month of the year and for each…
I am trying to store Google Map Circle data in MySql Database. I choose text data type to store Center Coordinate and int to store radius of the center. Now I am using below code to fetch data from those…
I upgraded to php 8.2 from 7.4 (tried 8.0 after as well but same issue) I get a 500 error and my host won't allow me to revert back to 7.4 now so I need to figure this out but…
I want to convert a date time field which is in UTC format to IST time format. This is the query which I have. select file_name,Process_start_time,Process_end_time from Process_logs where process_Start_time and process_end_time are in UTC format which I want in…
In SQL I'm looking for a potential function which I can use to apply a row number each time a certain criteria is met. Each time the Unique ID is the same (i.e. same person) and the Dep_Group is WES…
I have 9 fields to my user interface , each one is representing a column in my database table. So the problem is that i need to cover all the possible combinations of the 9 fields and send specific queries…
I am working on an SQL problem for a class - "Provide a student/parent list. Formatted child name, parent name 1, parent name 2. If a child doesn’t have a parent, just display null." The expected result should look like…