In an SQL function I want to create multiple records based on the parameters passed into the function, for example the function takes a member primary ID, a date/time stamp and a number specifying the number of records to create.…
I have three tables 1.) Students (id,firstName,Surname,email) 2.) Course_Student(student_id, course_id) 3.) Courses (id, name, classroom_id) I need to select all students, which have count of curses more or equal = 3. I contstruct this select and it seems that it…
What I want to do : For every migrations executed with php bin/console doctrine:migrations:migrate to be wrapped in a proper transaction (START TRANSACTION / BEGIN / ROLLBACK / ...). My config/doctrine_migrations.yml file contains the following options : doctrine_migrations: migrations_paths: #…
I have 3 tables 1 table with all the information which I want to extract to two tables [flat file] name / team / town [team table] teamID/ team / town [person table] personID/ name / teamID now I can…
I would like to select datas from an alone table with two columns, for a value in the first column there may be only one or multiples different values for the second columnn, but one value in the second can…
I have a list of items. Original items were set a property, but there was a bug in the app where child rows didn't inherit the property. Here is what I've tried to fix it: UPDATE queue_items SET property_value =…
I created test function with the proper characteristic DETERMINISTIC as shown below because it always produces the same result 3 according to the doc: CREATE FUNCTION test() RETURNS INT DETERMINISTIC -- Here RETURN 3; And, I also created test function…
For the last few days, I have been working to write a MySQL query to extract a result. Basically, I have to join two tables log and conditions table based on any column of the log table from the trigger_param_value…
I am trying to start django project using MySQL and Docker to containerize it. But get an error. Here is it's traceback: testcasebooks-backend-1 | Traceback (most recent call last): testcasebooks-backend-1 | File "/usr/local/lib/python3.11/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection testcasebooks-backend-1 | self.connect()…
Recently i got mac m1 i am running a product which uses [email protected] installed through homebrew, the data from the product is connected successfully to mysql and started populating but nearing the end of population there is a connection problem…