/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 vote346 views1 answer
How to use “find_in_set” in cakephp 3 find method
PHP
0 vote345 views1 answer
Php docker offical apache
PHP
0 vote246 views0 answer
PHP
3 votes322 views2 answers
Php var exists
PHP
0 vote357 views1 answer
How-to-call-ajax-in-wordpress
PHP Wordpress
0 vote308 views1 answer
Laravel log query for model (full)
PHP
106 votes509 views6 answers
Php strlen
PHP
25 votes309 views6 answers
Laravel use cache
PHP
9 votes299 views4 answers
String match in php
PHP
0 vote285 views1 answer
Laravel mixed content error
PHP

Share