Mercurial > sci
diff sql/project-find-id.sql @ 19:de4bf839b565
misc: revamp SQL
author | David Demelier <markand@malikania.fr> |
---|---|
date | Fri, 15 Jul 2022 11:11:48 +0200 |
parents | 3051ef92173a |
children |
line wrap: on
line diff
--- a/sql/project-find-id.sql Tue Jul 12 20:20:51 2022 +0200 +++ b/sql/project-find-id.sql Fri Jul 15 11:11:48 2022 +0200 @@ -16,7 +16,8 @@ -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. -- -SELECT * - FROM project - WHERE id = ? +SELECT rowid + , * + FROM `project` + WHERE `rowid` = ? LIMIT 1