/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 vote220 views1 answer
Convert stdclass to json in php
PHP
1 vote143 views1 answer
Composer require laravel/ui not working laravel 8
PHP Laravel
0 vote276 views1 answer
Login with email or username codeigniter 4
PHP CodeIgniter
0 vote199 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
2 votes163 views1 answer
Laravel mix purge css
PHP
1 vote191 views2 answers
Php iterate folder
PHP
0 vote183 views1 answer
Migration not found laravel
PHP Laravel
9 votes169 views4 answers
Add another field in existing migration laravel
PHP
3 votes164 views3 answers
Php best debugging functions
PHP
3 votes163 views2 answers
Replace multiple characters one string php
PHP

Share