Телеграмм чат группы mysql

Hi Denis when you are try to have a relationship between two tables like Master and Transaction Table you need to have same column in both tables or you will get a error cannot add Foreign Key Constraint.

источник

05:04пожаловаться #11

Denis Efremov in MySQL

VIJAY WILFRED

What do you mean the same?

источник

05:04пожаловаться #12

VIJAY WILFRED in MySQL

Denis Efremov

What do you mean the same?

The Column name which you have created "whites_id" should be there in "users" table.

источник

05:07пожаловаться #13

Denis Efremov in MySQL

VIJAY WILFRED

The Column name which you have created "whites_id" should be there in "users" table.

Why?

источник

05:08пожаловаться #14

VIJAY WILFRED in MySQL

Denis Efremov

Why?

Hi Denis for this issue you can refer this URL https://www.mysqltutorial.org/mysql-foreign-key/

MySQL Tutorial

An Essential Guide to MySQL Foreign Key By Practical Examples

This tutorial introduces you to MySQL foreign key constraint and shows you how to create a foreign key for a table with various reference options.

источник

05:17пожаловаться #15

Denis Efremov in MySQL

https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html

источник

05:20пожаловаться #16

VIJAY WILFRED in MySQL

Denis Efremov

https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html

Hi Denis please check this URL https://www.hostingadvice.com/how-to/mysql-foreign-key-example/

HostingAdvice.com

MySQL: "Foreign Key" — (EXAMPLE)

Below we will show some simple examples of how to set up foreign keys and how they work in MySQL. In our examples, we will reference the parent and child tables below. The tables labelled “Customer” and “Contact” represent the parent and child tables, respectively. There are basically two ways to define foreign keys in […]

источник

06:47пожаловаться #17

Denis Efremov in MySQL

VIJAY WILFRED

Hi Denis please check this URL https://www.hostingadvice.com/how-to/mysql-foreign-key-example/

HostingAdvice.com

MySQL: "Foreign Key" — (EXAMPLE)

It's bullshit. I found the solution already, and I haven't changed names.

источник

07:08пожаловаться #18

НА

Николай Алиферов... in MySQL

Уран с нами)

источник

08:14пожаловаться #19

Denis Efremov in MySQL

sticker.webp

(22.73 Кб)

источник

08:19пожаловаться #20