/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

0 vote260 views2 answers
Upload_max_filesize in wordpress
PHP Wordpress
4 votes223 views1 answer
Laravel deployment
PHP
0 vote236 views1 answer
How to superscript th in php date
PHP
49 votes252 views6 answers
Laravel add column to existing table
PHP Laravel
0 vote263 views1 answer
Laravel store multiple files
PHP
-1 vote205 views1 answer
ERROR: Module mpm_event is enabled - cannot proceed due to conflicts. It needs to be disabled first! Considering conflict mpm_worker for mpm_prefork: ERROR: Could not enable dependency mpm_prefork for php7.2, aborting
PHP
3 votes196 views3 answers
Laravel make view
PHP
19 votes215 views2 answers
Parse json phph
PHP
37 votes265 views4 answers
Foreign key in laravel migration
PHP Laravel
0 vote218 views1 answer
Php round function Passing parameters with mode.
PHP

Share