/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

20 votes297 views6 answers
Create model laravel
PHP Laravel
0 vote430 views1 answer
Get original data without cast laravel
PHP Laravel
0 vote292 views3 answers
Laravel transform object to array
PHP Laravel
0 vote258 views1 answer
Php call protected function from child class
PHP
0 vote274 views1 answer
User input in oop php
PHP
0 vote244 views1 answer
Javascript date to php date
PHP
0 vote299 views1 answer
Laravel ID Generator
PHP Laravel
3 votes295 views2 answers
What is the use of migration file in laravel
PHP Laravel
8 votes270 views1 answer
Last query in laravel
PHP Laravel
4 votes261 views2 answers
Update-alternatives java
PHP

Share