All public logs

Combined display of all available logs of Littledamien Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 11:28, 7 January 2022 Video8 talk contribs created page SQL Best Practices (Created page with "== Determining if a record exists == <syntaxhighlight lang="sql"> SELECT EXISTS (SELECT 1 FROM users_table WHERE user_table.userid = p_userId) INTO p_isPresent; </syntaxhighlight> Not <syntaxhighlight lang="sql"> SELECT COUNT(*) FROM users_table WHERE user_table.userid = p_userId INTO p_isPresent; </syntaxhighlight> `SELECT EXISTS` stops as soon as it finds a match. `COUNT` counts all matches. Category:MySQLCategory:MariaDB")