CodeIgniter 4 has a handy solution for migrations and seeders. Without the usage of foreign keys, everything is working perfectly. But when I use foreign keys I
After beating my head against the wall for a bit, I've decided I need help from the gurus here on stackoverflow. It's very possible I'm missing something incre
Is it possible this? I have the following table: Col1 Col2 col3 code1 US 9 code1 0 5 code2 US 4 code2 0 11 code3 0 11 and I'm trying to get the higher col3 va
I want to run a mysql container in windows server 2019. For that, Im using this image: vdkhiem/advancedmysqlcore:5.7.27 When I use this docker-compose file it w
I try to use View to create a constraint on a Mysql Table. I have one table with cinemas sessions and one other for tickets, the goal is we can't sell tickets w
I have a column which is in varbinary. I tried select cast(msg as varchar) from table WHERE DATE(datestr) > CURRENT_DATE - INTERVAL '7' DAY which threw C
I am trying to connect to my Google Cloud SQL instance with PHP (I am using PDO). When running my PHP file (from in the Google Cloud terminal), I receive the fo
I am receiving the error of SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 i
Here What I did is I have a user entity and a role entity. Every user can have one role. I have set up many-one relationship in role entity. I have create an en
Surveys table: enter image description here Questions table: enter image description here My sql query: SELECT s.id, q.question FROM questions q JOIN surveys s
Looks like my ORM, Prisma, does not allow for rolling back a migration. How have folks using Prisma rolled back a migration? Is there a way to manually rollback
I have two tables in a MySQL database: address that includes a description field which at most has a city name and a country buried somewhere inside it. There a
I will be very grateful for any help. My situation.. I have a table with students (I write only main columns for this question): | Id | Lastname | Firstname | _
I am making a cinema booking system for my dbms project. for the bookings table , I only want a certain number of inserts in a table to be possible. How can i a
I'm creating a simple php program and I'm trying to find a way to be able to go from the page 2 back to the page 1 with a button. I tried by making a button in
The SNO seems to be misdirecting So, I simplified the question even further --creation CREATE TABLE LAB (JOB_ID int, LAB_ID VARCHAR(50)); CREATE TABLE SPR (JOB_
I need to fill multiple different arrays by using a MySQL query. This would have up to 16 different arrays. I want to specify each array with
I have this Existing table tb1 in my database Now new data comes and new data is stored in another table tb2 Earlier Account_Number 9988 was Level 2, But now
I have a table like below with two columns Person and Supervisor. Person Supervisor 1 3 2 3 3 4 I want to select rows where the Supervisor column only has val
I opened PopSQL and the there is a red dot at my connection. If I go into it and test it, it tells me Unknown database 'giraffe'. I opened mySQL and typed 'show