/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 vote158 views2 answers
How change default value for enum colun in laravel
PHP Laravel
0 vote93 views1 answer
How to remove one element from array
PHP
8 votes123 views6 answers
Php isset
PHP
0 vote132 views1 answer
How to restrict user to some pages using php
PHP
1 vote156 views2 answers
Is home page if wordpress
PHP Wordpress
0 vote245 views1 answer
Drupal 9 check if UUD is valid
PHP Drupal
33 votes170 views4 answers
Php unset array key
PHP
63 votes314 views6 answers
Laravel artisan clear cache
PHP Laravel
0 vote126 views1 answer
Illuminate/container requires php your php version (X.X.XX) does not satisfy that requirement.
PHP
-1 vote124 views1 answer
Php current datettime us time zone
PHP

Share