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 template, and I often 
just leave it there when making views or bookmarking queries.


No one can hurt you without your consent. -- Eleanor Roosevelt
 Jan Steinman, EcoReality Co-op 





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



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 recommended course of action to keep data synchronized 
between the two platforms?




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql