/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 vote171 views1 answer
Unable to call component method
PHP
6 votes172 views3 answers
Php file_put_contents
PHP
2 votes206 views2 answers
Laravel get column field name
PHP Laravel
0 vote209 views1 answer
Remove repeated columns laravel
PHP Laravel
-1 vote183 views1 answer
Php: foreach loop
PHP
7 votes208 views1 answer
Laravel auth user_id
PHP Laravel
1 vote211 views1 answer
Clear cache using laravel controller
PHP Laravel
-2 votes190 views3 answers
Inner join codeigniter
PHP
1 vote180 views1 answer
Get the category wp
PHP
0 vote165 views1 answer
Php: Güvenlik Fonksiyonu
PHP

Share