/PHP/How to make primary key and foreign key in phpmyadmin

How to make primary key and foreign key in phpmyadmin

Create foreign key phpmyadmin

ALTER TABLE table_name
ADD CONSTRAINT fk_foreign_key_name
FOREIGN KEY (foreign_key_name)
REFERENCES target_table(target_key_name);

9

Source: bobcares.com

How to make primary key and foreign key in phpmyadmin

go to phpmyadmin
 select a table
  go to structure
  select the column you want to make primary
  click on the primary written beside check all

1

Similar codes

0 vote201 views1 answer
Non-static method Barryvdh\DomPDF\PDF::loadView() should not be called statically
PHP
2 votes104 views1 answer
Laravel model id string
PHP
0 vote97 views1 answer
Laravel request protected prop
PHP
1 vote123 views1 answer
String to uppercase laravel
PHP Laravel
0 vote108 views1 answer
Select max id laravel
PHP Laravel
0 vote117 views1 answer
Laravel 8 db like query
PHP Laravel
0 vote107 views1 answer
Laravel handle queryexception
PHP Laravel
0 vote97 views4 answers
Get_adjacent_post wordpress
PHP
1 vote115 views1 answer
Laravel pusher broadcasting/auth 403
PHP Laravel
8 votes97 views5 answers
Time function in php
PHP

Share