In my business, there is a demand to save a set of Numbers, but these Numbers are need to be searched, don't know the following two way save
the good performance(the first) a digital line by line to save
(2) Numbers respectively by commas
If late content increased, the method of performance is good?
Search is the needs of the business in the late 7009 or 7001 or combination query needs to get 46182
CodePudding user response:
The second way is obviously not desirable, it isn't in line with the basic principles of database table design,1 way data redundancy, can be solved through the open table,
Table 1, xx_id is a primary key
Xx_id user_id wx_replay_id
1 2 46182
Table 2 zlkey is the primary key
Zlkey xx_id
7009 1
7001 1
.
CodePudding user response:
The first kind of.
CodePudding user response:
The first method is better