/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 vote156 views1 answer
Get action name in yii2
PHP
3 votes131 views3 answers
How to get last id in database codeigniter 4
PHP
1 vote126 views3 answers
Php tags
PHP
0 vote124 views1 answer
Wp get attachment id
PHP
7 votes123 views4 answers
Php info
PHP
63 votes299 views6 answers
Laravel clear cache
PHP Laravel
0 vote110 views1 answer
Php debug backtrace last function
PHP
21 votes171 views4 answers
Php query
PHP
0 vote85 views1 answer
Acf create post with fields
PHP
-2 votes106 views3 answers
Laravel when condition
PHP

Share