/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 votes256 views3 answers
Php knoww if array has duplicate values
PHP
0 vote261 views1 answer
Upgrade php linux
PHP
0 vote338 views1 answer
Comment supprimer les éléments liés à WordPress oEmbed
PHP Wordpress
3 votes254 views3 answers
Newline not working php
PHP
0 vote232 views1 answer
How to conditional values in old value or edit new value with validsation faild to redirect back in laravel
PHP
10 votes249 views6 answers
Array_filter php
PHP
0 vote220 views1 answer
Supprimer un cookie avec un input en php
PHP
0 vote225 views1 answer
Wordpress set category front end
PHP
1 vote318 views1 answer
Wordpress get page slug
PHP Wordpress
0 vote312 views1 answer
CURL error 6: Could not resolve host: api.themoviedb.org (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://api.themoviedb.org/3/movie/popular?api_key=5cb73b68870b70a436b10ea06298de07
PHP

Share