/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 vote214 views2 answers
Recaptcha v3 laravel 8
PHP
0 vote269 views1 answer
How to install or setup sanctum for laravel api authentication
PHP Laravel
2 votes240 views1 answer
Laravel app get locale
PHP Laravel
1 vote221 views1 answer
Php foreach string in array
PHP
1 vote267 views2 answers
Re migrate laravel
PHP Laravel
0 vote266 views1 answer
Laravel Validate unique column
PHP Laravel
0 vote221 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000]: General error: 3780 Referencing column
PHP
3 votes212 views1 answer
DB::raw('SUM(subtotal) as total sales', 'SUM(discount) as d')
PHP
4 votes267 views1 answer
Get client size in laravel
PHP Laravel
1 vote275 views1 answer
Wordpress echo the excerpt
PHP Wordpress

Share