MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Blog MySQL Differences PRIMARY KEY VS UNIQUE in MySQL

Differences PRIMARY KEY VS UNIQUE in MySQL

Печать PDF
Рейтинг пользователей: / 0
ХудшийЛучший 

So what's different from the PRIMARY KEY and UNIQUE CONSTRAINT?

 

1. PRIMARY KEY does not allow NULL in their fields, and UNIQUE - allow.

2. PK - there can be only one. UQ - can be any number.

3. When you create a PRIMARY KEY by default creates a clustered index, and when you create a UNIQUE not.

 


 

Tunnel-heidisql

-

 

 

I used HTTPtunnel GNU package for the organization HTTP tunnel with HeidiSQL. Read more...

'mysql.proc' doesn't exist fixed problem

_

Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...