/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 vote205 views1 answer
Use smarty variable in php
PHP
14 votes143 views6 answers
Laravel Password Validation
PHP
8 votes136 views1 answer
Php split string along spaces
PHP
1 vote166 views1 answer
Not required a field when checked not applicable checkbox in laravel
PHP Laravel
0 vote161 views1 answer
Show images laravel 8 showJobImage($filename)
PHP Laravel
1 vote132 views1 answer
Fopen(F:\xampp\htdocs\Escubydu\storage\fonts//themify_normal_f60486608aadd4e36c92c9895f99838f.ufm): failed to open stream: No such file or directory
PHP
1 vote158 views1 answer
Laravel inverse seeder
PHP Laravel
0 vote126 views1 answer
Failed to open stream permission denied in php
PHP
6 votes132 views4 answers
Laravel create project command
PHP
0 vote165 views1 answer
Livewire call another component
PHP

Share