/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

-1 vote370 views1 answer
How to check if there is an authenticated user laravel
PHP Laravel
0 vote406 views1 answer
Check null in laravel blade
PHP Laravel
0 vote308 views1 answer
Trying to get property 'id' of non object in laravel api
PHP
2 votes316 views2 answers
Laravel include config
PHP Laravel
0 vote274 views1 answer
Carbon parse with timezone
PHP
1 vote329 views1 answer
Get key of last element php
PHP
0 vote420 views1 answer
Warning: sprintf(): Too few arguments in /opt/lampp/htdocs/wordpress/wp-admin/includes/class-bulk-upgrader-skin.php on line 152
PHP Wordpress
0 vote316 views1 answer
Get git branch by php
PHP
8 votes399 views6 answers
Laravel session
PHP
2 votes317 views2 answers
Stristr php
PHP

Share