ultrus Posted April 28, 2008 Share Posted April 28, 2008 Hello, I work with a team where the developers place their database changes in files, where they are run later to update the live website. However, there's usually at least one file that has an error, causing time issues when trying to update the database. Is there a way I can test run a query or set of queries on a database before actually running them? I know I could back up the current one and test it separately. That however takes just as much time as it would to just troubleshoot the bad queries. This really isn't a huge deal, but any tips would be appreciated. Thank you Quote Link to comment Share on other sites More sharing options...
fenway Posted April 28, 2008 Share Posted April 28, 2008 You can tack on a "LIMIT 0" to just about any SELECT statement. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.