forum-informatico
Gostaria de reagir a esta mensagem? Crie uma conta em poucos cliques ou inicie sessão para continuar.
Ajude a Asast
Patrocinadores
Últimos assuntos
» Artigo ethereum
Composed PRIMARY key EmptyTer Set 24, 2019 1:16 pm por jpmartins

» Artigo Bitcoin
Composed PRIMARY key EmptyTer Set 24, 2019 1:13 pm por jpmartins

» Novo site para desportistas / New site for athletes
Composed PRIMARY key EmptyTer Dez 04, 2018 8:19 am por Admin

» Check used port with the command line
Composed PRIMARY key EmptyTer Dez 04, 2018 8:10 am por Admin

» Check the port where mariaDB is running
Composed PRIMARY key EmptySeg Dez 03, 2018 4:59 am por Admin

» Check the linux version
Composed PRIMARY key EmptySeg Dez 03, 2018 3:12 am por Admin

» Granting rights to a database for a user
Composed PRIMARY key EmptyQui Nov 29, 2018 2:04 am por Admin

» Create new user
Composed PRIMARY key EmptyQui Nov 29, 2018 2:01 am por Admin

» Change level of password security level
Composed PRIMARY key EmptyQui Nov 29, 2018 1:59 am por Admin

AdSense
Contributo

Composed PRIMARY key

Ir para baixo

Composed PRIMARY key Empty Composed PRIMARY key

Mensagem  Admin Qui maio 26, 2016 5:49 am

Here is how to define a composed primary key in MySQL:

Código:

ALTER TABLE table_name ADD PRIMARY KEY(idcol1, idcol2);

and if the table has already a primary key:

Código:

ALTER TABLE table_name DROP PRIMARY KEY, ADD PRIMARY KEY(idcol1, idcol2);
Admin
Admin
Admin

Mensagens : 607
Data de inscrição : 21/01/2008
Idade : 46

https://forum-informatico.forumeiros.com

Ir para o topo Ir para baixo

Ir para o topo


 
Permissões neste sub-fórum
Não podes responder a tópicos