/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 vote157 views1 answer
Send multiple db notification same function in laravel
PHP Laravel
7 votes118 views3 answers
Self submit form php
PHP
10 votes128 views6 answers
Array_filter php
PHP
0 vote179 views1 answer
Comment php laravel template blade
PHP
1 vote140 views1 answer
How to give optional parameter in route
PHP
1 vote123 views2 answers
How to remove token while logout using laravel 8
PHP
0 vote125 views1 answer
Get session token in wp_login hook
PHP
2 votes155 views2 answers
Laravel 8 websockets
PHP Laravel
1 vote115 views1 answer
Laravel set config value runtime
PHP
0 vote128 views1 answer
Remove public or index file from url in laravel
PHP

Share