/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 vote351 views2 answers
Laravel 8 login logout
PHP
4 votes341 views2 answers
Call api with php
PHP
0 vote362 views1 answer
Php curl upload linkedin image
PHP
1 vote361 views3 answers
Laravel title dynamic
PHP
0 vote376 views1 answer
Check php and wordpress version before activation
PHP Wordpress
0 vote329 views1 answer
Get record of last 24 hours in laravel
PHP
3 votes329 views1 answer
Does xampp install php
PHP
1 vote292 views1 answer
Prestashop get all products
PHP
0 vote323 views2 answers
Laravel project make
PHP Laravel
1 vote363 views2 answers
Unzip file php
PHP

Share