logo
Redian新闻
>未名空间
>Database - 数据库
>
MySQL row selection question
avatar
MySQL row selection question# Database - 数据库
e*l
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.
avatar
I*e
2 楼
Create an InnoDB table with your ID as the primary key. Then, you do not
need another index. Is this what you want?
avatar
e*l
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?
avatar
I*e
4 楼
Then, you should use auto_increment on ID, work for you?
avatar
e*l
5 楼
Thanks. It worked.

【在 I******e 的大作中提到】
: Then, you should use auto_increment on ID, work for you?
相关阅读
出道oracle dba 面试题Access to a path is denied across domainsSQL中NOT EXIST和NOT IN有什么区别?刚提升为数据库部门经理，寻同道支持和交流！【急！！！】t-sql EXP()函数溢出一问问一个白痴问题：SSIS, SSAS, SSRSLarry口才一般，说话呼哧带喘的現在特佩服 Oracle / MSSQL 兩邊都牛的人University of California, Merced, Ph.D. positions availablecareer choicesoracle interview请问数据表里筛选变量名的写法Help, multiple EXTPROC_CONNECTION_DATAreplication sp_addpushsubscription_agent 用户名错这里有用teradata的么Think you know deadlock in SQL Server? While..., think again:什么地方有SQL习题集？Patch Set 11.2.0.2 for Linux is now available建了一个有关EXCEL和VBA的俱乐部！mac os x 10.6 下 使用mySQL 一问 (转载)
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。