I have a table 'processes' with the following columns : id date_creation date_lastrun For example I have the following entries: id;date_creation;date_lastrun 1;2022-01-01 00:00:00;2022-02-01 00:00:00 2;2022-03-01 00:00:00;NULL I want to select the element with the bigger date in MySQL I can…
I want to get the list of last n number of table names present in a schema in a particular database. The problem is there are lots of tables and is not convenient to scroll through all of them to…
I have the following table: Day Category Count D1 A 10 D1 B 20 D2 A 8 D2 B 10 D3 A 6 D3 B 5 I'm trying to create a percentage column by dividing the values in the third…
Here is the code <?php $servername = "localhost"; $usrname = "root"; $pwd = ""; $db = "test_db"; // connect to the database $conn= mysqli_connect($servername, $usrname, $pwd,$db); if (!$conn){ die('connection failed' . mysqli_connect_error()); } // Create database $sql = "CREATE DATABASE…
I am pretty new to PHP so please go easy on me. I am receiving this error "SQLSTATE[HY093]: Invalid parameter..." when I am preparing my SQL statement and binding the values. I have a function that takes three parameters: $table,…
I'm trying to join a new column to my current query that uses aggregate functions. I create this column with a new query that also uses an aggregate function from a different table but I'm not sure if a JOIN…
If I run this query: select date, sum(orders) as "Total orders" from tbl where date >=1 and date <= 4 group by date How can I get the expected output as shown in the screenshot?
I want to get the records based on the row value. Please refer to the attached image for a table overview with records. If there is no Execution Project in the column projecttype for a specific ESAProjectID then take the…
I have a table for learner as learner_lesson learnerlessonid learnerid lessonid 1 24 42 and another table as learner_lesson_log lessonlogid learnerlessonid progress maxprogress. interactionType createdAt 1 1 0 15 Start 2022-11-02 07:50:30 1 1 0 15 Start 2022-11-02 07:51:30 2…
Suppose that I have a table with the following two columns: create table contacts ( first_name varchar[], last_name varchar[] ); And I have the following two rows: INSERT INTO contacts (first_name, last_name) VALUES (ARRAY['Samin'] , Array['Var']), (ARRAY['Sara', 'pooya'] , Array['Rad',…