/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 vote150 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel
17 votes156 views3 answers
Laravel order by desc
PHP Laravel
1 vote181 views1 answer
Laravel validation types for float
PHP Laravel
0 vote125 views1 answer
Phplinit config
PHP
0 vote169 views1 answer
Include Custom Post Types Categories to the main query
PHP
0 vote126 views1 answer
Acf get sub field
PHP
0 vote105 views0 answer
Laravel
PHP Laravel
0 vote182 views1 answer
Str_replace smarty template
PHP
2 votes169 views2 answers
How to use stored procedure in laravel
PHP Laravel
0 vote151 views1 answer
Import class route laravel
PHP

Share