Browse the archive

MySQL

How to implement a unique key for a long VARCHAR column in MySQL

October 27, 20192 min read

Question I need to let MySQL to check the uniqueness of a VARCHAR column which is 5000 max length and is not the primary key. I can use an index of length 500 on the column to speed up query, but how to create an unique key that works?

Databases

What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology?

December 20, 20161 min read

Question What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology or is there anything similar in MySQL that can act as AE? Asked2016-12-20bydwkd Answer The Always Encrypted feature provides end-to-end encryption, which encrypts data both …