A common SQL habit is to use SELECT * on a query ... For instance, if you insert data into a table and then use UPDATE to change it, like I’ve just shown, that’s two separate transactions.