/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 vote233 views1 answer
Developer polyglots
PHP
0 vote337 views1 answer
Wordpress Simple Membership button name
PHP Wordpress
8 votes278 views4 answers
Laravel unique validation on multiple columns
PHP Laravel
20 votes249 views4 answers
Get url with php
PHP
1 vote247 views1 answer
How to take last entry in database in laravel Method ONe
PHP
1 vote256 views1 answer
Laravel nigerian time zone
PHP
7 votes267 views2 answers
String compare in php
PHP
0 vote222 views1 answer
What is carriage return in php
PHP
0 vote256 views1 answer
Laravel delete controller still cached
PHP
0 vote225 views1 answer
Union type php does not work
PHP

Share