84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
在设计一个订单表,用算法生成唯一的订单号可以保证不重复,那么是否还需要自增长的ID呢,还是直接就用订单号作为主键就可以
走同样的路,发现不同的人生
For mysql, obviously, even if you have a unique order ID, you must have a primary key that automatically increments the id.
Mysql has high efficiency in incrementing the primary key.
It is recommended to use physical primary key id instead of logical primary key to facilitate system expansion
You definitely need a self-increasing ID
It is recommended to retain the default id auto-increment primary key at all timeshttp://imysql.com/2014/09/14/mysql-faq-why-innodb-table-using-autoinc-int-as-pk .shtml
For mysql, obviously, even if you have a unique order ID, you must have a primary key that automatically increments the id.
Mysql has high efficiency in incrementing the primary key.
It is recommended to use physical primary key id instead of logical primary key to facilitate system expansion
You definitely need a self-increasing ID
It is recommended to retain the default id auto-increment primary key at all times
http://imysql.com/2014/09/14/mysql-faq-why-innodb-table-using-autoinc-int-as-pk .shtml