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 Link to comment https://forums.phpfreaks.com/topic/103289-test-a-query-for-errors-without-affecting-database/ 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. Link to comment https://forums.phpfreaks.com/topic/103289-test-a-query-for-errors-without-affecting-database/#findComment-529069 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.