/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

15 votes310 views6 answers
Laravel create request
PHP Laravel
0 vote280 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP
7 votes306 views2 answers
Date time format for laravel validation
PHP
0 vote361 views1 answer
Laravel has many limit
PHP Laravel
0 vote314 views1 answer
Return last inserted id mysql opencart
PHP
0 vote292 views2 answers
Old codestar text field
PHP
0 vote315 views1 answer
Php make text id attribute safe
PHP
0 vote301 views1 answer
Php put print_r into variable
PHP
7 votes359 views3 answers
Laravel - Query Builder Left join
PHP Laravel
0 vote320 views1 answer
Fixing unclosed html tags
PHP

Share