/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 vote162 views1 answer
Print array to a file
PHP
0 vote130 views1 answer
Laravel where between cluse
PHP Laravel
2 votes104 views1 answer
Change key with the value php
PHP
1 vote109 views1 answer
Wordpress image text acf
PHP
0 vote117 views2 answers
How to remove duplicate values from an array in php
PHP
0 vote141 views1 answer
Laravel optional params
PHP Laravel
1 vote151 views1 answer
Laravel set config value dynamically
PHP
0 vote110 views2 answers
Script inside php
PHP
10 votes126 views2 answers
Array to string conversion in laravel controller
PHP
2 votes109 views2 answers
Wordpress add jquery script
PHP

Share