/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

7 votes179 views5 answers
Laravel foreach loop index
PHP Laravel
19 votes145 views3 answers
Print array on php
PHP
0 vote168 views1 answer
Laravel check if api request
PHP Laravel
3 votes111 views2 answers
Php link to page
PHP
0 vote139 views1 answer
2 days left format in laravel
PHP
0 vote164 views1 answer
Php pass variable to anonymous function
PHP
13 votes201 views2 answers
Laravel turn off timestamps
PHP Laravel
0 vote297 views1 answer
Laravel not rollback even has error
PHP Laravel
0 vote147 views1 answer
Magento2 move Exception #0 (Exception): Notice: Undefined offset: 2 in /var/www/nucleus/htdocs/vendor/magento/framework/Encryption/Encryptor.php on line 591
PHP
0 vote143 views1 answer
Magento 2 print php error
PHP

Share