/SQL/Mysql two column combination unique

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

0 vote245 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote239 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote237 views1 answer
Mysql multiple group by
SQL
-1 vote259 views1 answer
Utf8_encode mysql
SQL
1 vote219 views2 answers
Difference between in and between in sql
SQL
0 vote235 views1 answer
Interview experience as a call?
SQL
0 vote236 views1 answer
Oracle list subpartitions
SQL
0 vote218 views1 answer
Selects all the columns from the sailors table
SQL
0 vote226 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote243 views1 answer
Mysql regex select
SQL