Tag: foreign-keys

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row in Laravel9

foreign-keys laravel laravel-9 mysql php

I have an integrity constraint violation when I run the php artisan db:seed command in Laravel 9. Error PDOException::(“SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (hunger-db.restaurants, CONSTRAINT restaurants_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE)”) setup_users_table setum_restaurants_table User Model Restaurant Model Answer I see some things to change

Determine name of table referenced by a foreign key from another table using PHP?

foreign-keys mysql php

Just learning mysql and php and having to create a test project for my exam. How do I determine the name of a table (target) a foreign key from another table (source) references, and how would I go about that with PHP? I have been googling this as well as browsing SO for it for hours, but have not found

How to add constraints to existing keys using laravel migration

constraints foreign-keys laravel migration php

I currently have a database in my project which has already been put in production. But I didn’t use constraints in the previous migrations. Now I have tables products, shops and an intermediate table product_shop. The problem is that if I delete any product, that has been put on some shop, the pivot is still kept in the intermediate table.

Foreign key codes are not working in migrations of Laravel 8

foreign-keys laravel laravel-8 mysql php

I tried to make a foreign key, however, it is not working. Posts Migration Users Migration I am trying to make a “user_id” column for posts that should be connected with an id of a user via a foreign key. But, when I migrate I am getting errors like the following IlluminateDatabaseQueryException SQLSTATE[HY000]: General error: 1005 Can’t create table mytest_db.posts

Inserting data into a table using foreign keys in MySQL

foreign-keys mysql php sql sql-insert

I am trying to insert data into a contacts table using foreign keys in mysql, the structure of tables are as follows CONTACTS TABLE id contactname phone_number fk_id USERS TABLE pers_id …

Inserting to multiple mysql table based on an primary key from first table

foreign-keys mysql php

I am trying to write to two mysql tables. Table 1: vehicles The field vehicle_id is auto incremented. I need to use this field in the next table speed_log. This is the other table that. Table 2: speed_log As above, the id is auto incremented but I need to pick the vehicle_id from the first table when the script runs.