Hello Everybody, I am totally new to MySQL. Wanted to know if MySQL supports any options using which users can specify the row storage order. For instance, Let us consider the Employee table, Now I want to store rows of this table in EmpId column order. The rows should be physically stored in ascending EmpId column order. Let us assume that the table has 2 rows having EmpIds say 1 & 5 to start with. Now if I insert another row having EmpId 3, The rows should be physically stored in EmpId order of 1, 3 & 5 which means that I expect row with EmpId 3 to be inserted between rows with EmpIds 1 & 5.
It would also help a lot if somebody could provide a complete working example of how to accomplish this. Thanks In Advance, Sanjaya Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]