But how to get the rows in the same order of insertion? Say, I will insert 2 3 4 and it will store in 2 4 3. But I need in the order 2 3 4. Is it possible?
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Michael Schlenker Sent: Friday, May 15, 2009 3:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] How sqlite will store the data? Pramoda M. A schrieb: > In which order, SQLite will store the data? In any order it likes, it might use the insertion order if thats convenient. > > I am using SQLite 3.6.5 and which is storing data in some other manner > than I am inserting? > > How to make it to store in the same way as insertion? > You usually don't. Simply use ORDER BY when retrieving your data, it was made for that. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax: +49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
