1
I’m trying to name constraints
in the MySQL
but unsuccessfully, I’m doing it this way:
create table if not exists pessoas
(
id int auto_increment,
nome varchar(30) not null,
data_nascimento date,
constraint pk_pessoa primary key(id)
) default charset = utf8;
When I execute the command show create table pessoas
mine constraint
is not defined and when I try to do alter table pessoas drop index pk_pessoa
I get an error. Where I am missing?
If possible click on [Edit] and post his mistake.
– Valdeir Psr