Mysql unique two columns

Mysql two column combination unique

CREATE TABLE `content_html` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_box_elements` int(11) DEFAULT NULL,
  `id_router` int(11) DEFAULT NULL,
  `content` mediumtext COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_box_elements` (`id_box_elements`,`id_router`)
);

Source: stackoverflow.com

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;

Similar codes

14 votes361 views3 answers
Sql trim from string
SQL
19 votes357 views6 answers
Sql drop table if exists
SQL
3 votes357 views2 answers
Oracle drop column
SQL
1 vote356 views2 answers
Mysql allow remote connections
SQL
0 vote372 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote356 views1 answer
Hibernate with springboot mysql
SQL
1 vote341 views3 answers
Reset sql primary key
SQL
0 vote351 views1 answer
Sql get user account
SQL
1 vote381 views1 answer
Pl sql create table from another table
SQL
0 vote360 views1 answer
How to order result of subquery in select
SQL