Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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`)
);
Comment

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: myswql show full processlist 
Sql :: sql #region 
Sql :: duplicate entry 
Sql :: how to combine diff colmun value using group by postgres 
Sql :: sql remove decimal places 
Sql :: mysql find duplicates in same table 
Sql :: get records in sql according to month name and count 
Sql :: sqlite save db 
Sql :: sql datetime format 
Sql :: how to inner join 4 tables in sql 
Sql :: mysql kill 
Sql :: constraints to columns SQL 
Sql :: mysql decimal allow negative values? 
Sql :: oracle sql concatenate results into string 
Sql :: sqlalchemy postgres timestamp with timezone 
Sql :: sqlite unique 
Sql :: soql last week 
Sql :: PostgreSQL types and C# types 
Sql :: sql constraint check value in list 
Sql :: what is the difference between clustered and non-clustered index in sql server 
Sql :: orcale index size 
Sql :: how to join tables in sql 
Sql :: sql insert column 
Sql :: mysql min value row 
Sql :: oracle insert into where 
Sql :: sample in sql 
Sql :: sql delimiter to columns 
Sql :: oracle current session details 
Sql :: mysql_num_fields in mysqli 
Sql :: select users with same username 
ADD CONTENT
Topic
Content
Source link
Name
6+4 =