/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

2 votes206 views1 answer
Change field name in validation laravel 8
PHP Laravel
2 votes194 views2 answers
Get all data eloquent laravel
PHP Laravel
29 votes189 views3 answers
Random String Function PHP
PHP
1 vote177 views1 answer
PHP Warning: Module 'grpc' already loaded in Unknown on line 0
PHP
0 vote180 views1 answer
Laravel telescope tutorial
PHP
0 vote216 views1 answer
Boot add schema in laravel
PHP Laravel
0 vote163 views1 answer
How to check if PHP variable contains non-numbers?
PHP
21 votes276 views6 answers
Php print array
PHP
0 vote222 views1 answer
Laravel old value not working in textarea
PHP Laravel
0 vote183 views2 answers
Obtener datos de usuario registrado en WordPress
PHP Wordpress

Share