Auto-generated primary key in sql database based on other filled field

I would like to have unique generated primary key that will take info from other field to create that code. For example, let say I would like to generate student ID based on year, and student's name, so my code will consist of string that has 3 letter and 4 digit. Student name: Jone year: 2015 so the generated code will be something like: jon2015

我想拥有唯一生成的主键,它将从其他字段获取信息以创建该代码。例如,假设我想根据年份和学生的姓名生成学生ID,因此我的代码将包含3个字母和4个数字的字符串。学生姓名:Jone年份:2015所以生成的代码将类似于:jon2015

Please advice me how I should do it?

请告诉我应该怎么做?

1 个解决方案

#1

I built a Student Info System based on MySQL. I can tell you right away that building a unique ID based off a date and a name is the fastest way to get duplicates.

我建立了一个基于MySQL的学生信息系统。我可以立刻告诉你,根据日期和名称建立一个唯一的ID是获得重复的最快方法。

I suggest you generate the student IDs as a unique Int, just start the count at a high number, so you don't have an ID of 0001 or 1.

我建议您将学生ID生成为唯一的Int,只需以较高的数字开始计数,因此您没有ID为0001或1。

If you need a visually nicer representation of their ID, you can do something like:

如果您需要在视觉上更好地表示其ID,您可以执行以下操作:

[first initial][last name][last 4 of unique ID]

This will give you a more visually pleasing ID, but it will be based off a unique number. So JSmith1234

这将为您提供更加视觉上令人愉悦的ID,但它将基于一个唯一的数字。所以JSmith1234

1 个解决方案

#1

更多相关文章

随机推荐