laravel foreign key constraint failed

1. The existing slave table score foreign key player_id is associated with the main table playerinfo primary key id. 2. When adding data to the slave table, Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (racesys.sco...

高洛峰 2017-05-16 16:46:55 0  1  884

How to query the foreign key name in MYSQL

Why can't I get the foreign key name?

Adolph 2018-06-21 17:49:27 0  1  1168

Questions about foreign keys to tables

The teacher would like to ask, why not create foreign key links directly in MySQL? It is the relationship between the foreign key that directly links the two tables.

clean 2020-04-15 00:05:35 0  1  1041

MySQL Error 150: Troubleshooting foreign key constraints when creating table

I'm trying to create a table in MySQL with 2 foreign keys that reference primary keys in 2 other tables, but I'm getting an errno:150 error and it won't create the table. Here is the SQL for all 3 tables: CREATETABLErole_groups(`role_group_id`int(11)NOTNULL`AUTO_INCREMENT`,`name`varchar(20),`descrip...

P粉254077747 2023-10-16 16:59:12 0  1  774

MySQL, check if foreign key is assigned to any table

I have a table called files. Additionally, I have more than 100 tables in which I use association/foreign key file_id. How can I get all files for which no association exists (that is, the file is not attached to any table)?

P粉993712159 2023-08-17 12:51:10 0  1  547

Add foreign keys to big data types such as varchar(2000) mysql tables

I have two tables "affiliate_stats" and "transaction", 'affiliate_stats' has column 'affiliate_sales' varchar(2000) (child table), and 'transaction' has column '_id' varchar(100) primary key (parent table) when I Add constraint fk_affili_ by changing table affiliate_stats when ad...

P粉378264633 2023-09-05 17:33:34 0  2  562

Steps to remove a foreign key entry

I have two tables Employee and Address. Employee is my main table and Address is a subtable related to Employee via the foreign key AddressId. When I delete the Employee record, the record from Address is not deleted. How can I rewrite my code to do this? Employee:[Id](PrimaryKey)[FirstName][LastNam...

P粉845862826 2024-04-04 14:15:44 0  1  510

MYSQL I want to know how to query the name of the foreign key

I use show create table myforeign; statement query but I can’t see the name of the foreign key. The mysql I use is from the PHP toolbox.

Adolph 2018-06-21 17:54:54 0  2  1082

python - Writing Django restful api, there is a field in the model table that contains a foreign key, how can the frontend POST submit data get the value from this foreign key?

Hello, seniors. I am writing an interface for a Django project. I want to release a table called info through the interface, so that other platforms can pass data to the info table through this interface. However, the org field in the info table has a primary and foreign key relationship with anothe...

PHP中文网 2017-05-18 10:57:29 0  1  793

mysql - How to solve the problem that two tables refer to each other as foreign keys in a database table

I have two tables, one is the employee table and the other is the department table. The employee table has two attributes: employee number and department number. The department has two attributes: department number and manager number. Obviously, the manager number should use the employee number in t...

伊谢尔伦 2017-06-08 11:03:31 0  2  1176

Adding foreign key columns to a MySQL table: step-by-step guide

I have a table named payment_request in MySQL DESCRIBEpayment_request giving the following output, orderbook table is provided below, I want to add the id from the payment_request table in the orderbook as a foreign key with the name payment_request_id after the id column (second position). What is ...

P粉494151941 2023-10-29 18:54:01 0  2  602

Automatically add logged in user's ID to KeystoneJS foreign key field

I'm creating an application using the documentation provided by the KeystoneJS framework. So, in my application I have two tables, one is users and the other is posts. So, I'm wondering, when I create a post by logging into the admin area, there is a field with a foreign key column, and that field i...

P粉239164234 2023-09-14 12:23:19 0  1  693

Cannot drop index '*': required -> in foreign key constraint but which one?

Context I have a problem deleting a row from a table. I use these queries to first delete its foreign key and then delete the column that the key points to. ALTERTABLEresourcesdropforeignkeyfk_res_to_addr;ALTERTABLEresourcesdropcolumnaddress_id; Dropping constraints works well. Dropping column fails...

P粉155710425 2024-03-25 23:27:49 0  2  426

Laravel foreign keys not outputting expected results

I'm developing a Laravel9 web application with two tables (users and feedbacks) that are joined using a foreign key called username. A user can have a lot of feedback. As far as I know, if I get the user's details, the data also contains relevant feedback. My problem is that the user data is being f...

P粉924915787 2024-03-31 16:45:38 0  1  498

Ways to avoid errors when adding foreign keys in Laravel

Can you help me? I want to add a foreign key to the posts table that has a reference in the categories table. But when I enter the command phpartisanmigrate:fresh, it always fails. The error message I get is this PDOException::("SQLSTATE[HY000]:Generalerror:1005Can'tcreatetable'handconsulting'....

P粉311617763 2023-09-09 00:27:09 0  1  525

mongodb - Can mongo non-primary key objectid be empty?

2. {Code...} What if the foreign key is empty and can only store string type?

代言 2017-06-08 11:02:05 0  1  884

mysql: key reference and table reference do not match

Error message: SQLSTATE[42000]: Syntax error or access violation: 1239 Incorrect foreign key definition for 'fk.faq.product_id': key reference and table reference do not match product table: CREATE TABLE `product` (`id` BINARY( 16) NOT NULL, `version_id` BINARY(16) NOT NULL, `created_

P粉798010441 2023-07-18 15:17:02 1  1  677

How can I add a relationship to these two tables when there is an id and a prefix in the primary key?

I don't know how to link these two tables. Can anyone help? I want to add a relationship in these two tables but since I am using id and prefix as primary key it is not accepting it as foreign key. I keep getting "Foreign key constraint is malformed". CREATETABLEDonor(idint(3)ZEROFILLNOTNU...

P粉675258598 2023-09-15 15:03:48 0  1  555

MySQL: Two tables joined using primary key and foreign key, how to get all records even if the foreign key is not populated yet

I hope to find a solution I have one table with primary key stock stkid(pk),name second table (share) price,quantity,stkid(fk) I ran this query but it only shows the records that are already in the share I want to display all stocks even if there are no records in shared records selectname,0,sum(pri...

P粉486743671 2023-08-09 14:15:07 0  1  453

Workaround: How to resolve Unable to delete or update parent row: Foreign key constraint violated?

I want to delete users based on phone number. So I made a custom query to delete that specific user. But an error occurred that the foreign key could not be deleted or updated. Below is my user entity. Below is my custom query trying to delete a user. @Modifying@Query("DELETEfromUseruwhereu.pho...

P粉458913655 2024-03-25 18:47:47 0  1  634