in reply to How to do some query with sqlite.bz2 file
$sq_1 = "select * from tbl_xxx";
Side comment on the SQL. * should be used in EXISTS, COUNT(), and ad-hoc queries, but not elsewhere. It is good practice (and self-documenting!) to specify the required columns. It also helps avoid bugs do to unhandled columns or column reordering.
|
|---|