Re: Query query

2011-12-06 Thread Jan Steinman
From: Arthur Fuller fuller.art...@gmail.com You should still lose the pointless WHERE 1. Besides being pointless, is there any harm in having a superfluous WHERE 1 beyond the few microseconds it takes to parse it and throw it away? Just curious, because phpMyAdmin includes it in its query

mysql/sql server migration

2011-12-06 Thread Adam Lanier
I'm involved with a project that is migrating data from sql server to mysql. The project will take up to a year to complete. During that period of time, we will need to synchronize data from sql server to mysql as we migrate windows based functionality to linux based servers. What is the