On 8 May 2011, at 4:09pm, Simon Slavin wrote: > On 8 May 2011, at 4:00pm, Sam Carleton wrote: > >> Is there a >> way to find out the id of a particular column? > > It depends what you think a column's id is. But SQLite maintains a > pseudo-column of INTEGERs called 'id' or 'rowid' (several other names) which > you can ask for by name. For instance > > SELECT rowid,* FROM myTable
Whoops. Sorry I somehow understood that as 'rowid'. Columns don't have ids. See Jean-Christophe's reply for better details. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users