How to create a unique identifier without using AUTOINCREMENT

Question

I export data from csv to mysql database, I want the database to create a unique identifier for each imported record. I want to use a unique field when generating the receipt number in the crystal report.

What do you suggest as the best way to do this?

Answer 1

If you do not want auto-increment, the only way to guarantee uniqueness is to use a GUID as an identifier.

"", , GUID , . :

(21 ²⁸ 3.4 × 10 ³⁸) , , , , , .

Answer 2

- MySQL, ?

, Oracle, .