e****l
发帖数: 204 | 1 Can I select a specific row from the a table according to index, without cre
ating a field for index?
Say, the 1st row, the 331st row, or 52nd row.
I have a data vector with around 200,000,000 elements and want to store it i
n MySQL. The table should be as small as possible.
Thanks. | I******e
发帖数: 101 | 2 Create an InnoDB table with your ID as the primary key. Then, you do not
need another index. Is this what you want? | e****l
发帖数: 204 | 3 But I still have to create a field for the ID, right?
Or the first will natural have an id of "1"? if so, how should I call this p
roperty?
【在 I******e 的大作中提到】
: Create an InnoDB table with your ID as the primary key. Then, you do not
: need another index. Is this what you want?
| I******e
发帖数: 101 | 4 Then, you should use auto_increment on ID, work for you? | e****l
发帖数: 204 | 5 Thanks. It worked.
【在 I******e 的大作中提到】
: Then, you should use auto_increment on ID, work for you?
|
|
