/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

6 votes304 views1 answer
Debug query builder laravel
PHP Laravel
7 votes292 views2 answers
Laravel how to check if there are record exists
PHP Laravel
0 vote266 views1 answer
Curl exec not working php
PHP
1 vote250 views1 answer
Laravel 6 tymon/jwt-auth
PHP
0 vote371 views2 answers
Drupal set message
PHP Drupal
2 votes263 views2 answers
Php get epoch timestamp of date
PHP
0 vote264 views1 answer
Check mobile or email in laravel
PHP
0 vote282 views2 answers
Php enablem mod
PHP
1 vote274 views1 answer
How to echo line number in php
PHP
3 votes279 views1 answer
Laravel remove controller
PHP

Share