/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 vote176 views1 answer
Laravel emial unique igration error
PHP
0 vote204 views1 answer
Data type for price in laravel
PHP Laravel
0 vote264 views1 answer
Wordpress get post body
PHP
0 vote201 views1 answer
Withsuccess laravel 8
PHP Laravel
17 votes199 views6 answers
Php sha256
PHP
10 votes233 views6 answers
Laravel blade date format
PHP Laravel
5 votes205 views2 answers
Php artisan preset react
PHP
0 vote196 views1 answer
Fetch email from url contact form 7
PHP
4 votes200 views4 answers
Chunk in laravel
PHP Laravel
0 vote329 views2 answers
Http://www.finalclap.com/faq/81-php-afficher-date-heure-francais
PHP

Share