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 :: how to get alternate records from a table in sql 
Sql :: subquery in select 
Sql :: how to select multiple columns in sql 
Sql :: phpmyadmin access denied 
Sql :: SQL LIKE With Wildcards 
Sql :: how to run sql query in mysql workbench 
Sql :: java.sql.sqlexception: access denied for user 
Sql :: cast float mysql 
Sql :: Data type and their numeric form 
Sql :: bigquery routine 
Sql :: Insert results of a stored procedure into a temporary table 
Sql :: sql id serial primary key 
Sql :: guid string to binary better 
Sql :: how to retrive image from sql to picturebox usinf image location 
Csharp :: how to load the active scene unity 
Csharp :: unity change tag in script 
Csharp :: Point to mouse 2D Unity 
Csharp :: c# random number 
Csharp :: unity get all by tag 
Csharp :: how to remove a component from an object in unity 
Csharp :: c# center text 
Csharp :: how to set a custom size for window in monogame 
Csharp :: unity editor select object in script 
Csharp :: unity check if key pressed 
Csharp :: unity wait for seconds 
Csharp :: path desktop c# 
Csharp :: c# remove last value from list 
Csharp :: check if number is even or odd c# 
Csharp :: generate random number c# 
Csharp :: how to split and get last index values in c# 
ADD CONTENT
Topic
Content
Source link
Name
8+8 =