/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

22 votes223 views4 answers
Laravel orWhere
PHP Laravel
0 vote185 views2 answers
How to save array of inputs in php
PHP
0 vote186 views1 answer
Omnipay capture
PHP
0 vote206 views1 answer
Orderby total sales woocommerce
PHP
0 vote201 views3 answers
Hide wordpress errors
PHP Wordpress
0 vote205 views1 answer
Php xpath get all tags under a tag
PHP
1 vote212 views1 answer
Php close session
PHP
3 votes193 views2 answers
Current timestamp carbon
PHP
0 vote235 views1 answer
'mix' is not recognized as an internal or external command,laravel 8 npm run dev
PHP Laravel
2 votes183 views1 answer
Laravel vendor:publish not working
PHP

Share