/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 vote350 views1 answer
Laravel request validation rules for create and update
PHP
1 vote329 views1 answer
Session_destroy not working
PHP
0 vote325 views1 answer
Escape class wordpress
PHP
0 vote420 views2 answers
Option selected in laravel blade
PHP Laravel
14 votes425 views6 answers
How to install laravel
PHP Laravel
0 vote328 views2 answers
Laravel return new tab
PHP
2 votes354 views1 answer
Wp display custom fields
PHP
0 vote329 views3 answers
Passing data from controller to blade view laravel
PHP
0 vote306 views3 answers
Laravel collection sort
PHP Laravel
0 vote359 views2 answers
Validate contact us page 2021 php coding
PHP

Share