create table unique type data mysql code example

Example 1: mysql set field unique

ALTER TABLE mytbl ADD UNIQUE (columnName);

Example 2: mysql unique two columns

CREATE TABLE IF NOT EXISTS cliente (
	id bigint primary key auto_increment,
    nome varchar(100) not null,
    email varchar(100) not null unique,
    senha varchar(255) not null,
    documento varchar(50) not null unique,
    dataCadastro date not null
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;

Tags:

Sql Example

Related