/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

5 votes116 views2 answers
Laravel access controller method from another controller
PHP
1 vote152 views1 answer
How to get current location in laravel
PHP Laravel
1 vote132 views1 answer
Static function model laravel
PHP
0 vote128 views1 answer
"Illuminate\Database\Eloquent\MassAssignmentException"
PHP
4 votes305 views5 answers
Get numbers from string php
PHP
0 vote154 views1 answer
Laravel repository error
PHP Laravel
3 votes141 views2 answers
Creating default object from empty value
PHP
7 votes180 views4 answers
Laravel is route name
PHP Laravel
4 votes123 views5 answers
Insert data
PHP
0 vote156 views1 answer
Drupal 8 custom form image field
PHP Drupal

Share