We're in a MySQL forum with a question on MySQL - I figured I was pretty safe going for a MySQL response. I'm guessing that most smaller projects once started in MySQL will never leave MySQL (why should they?). So why ignore half the syntax? Even in large companies when they decide to change their main RDBMS supplier it really just means that new projects will use the new RDBMS. Few people are insane enough to go to the expense of rewriting an existing system to use a new RDBMS for no real gain.
I personally work with 3 different RDBMs (Sybase, MS SQL and Oracle) - the MySQL bit I only do as a hobby as there isn't much money in it. 18 minutes before you responded to one of my posts with a near identical bit of SQL - are you getting a little slow Rudy?
I guess it's best to simply allow people to help others in what ever way they can. If posters do make a mistake then sure, correct them. However if it's just a difference in style then is it really worth arguing over? However if there is a serious error in using some MySQL commands then it might be best to argue your case with the MySQL developers, rather than those that use (and quite like) the language.
thanks guys, but what do you about this, its just checking mathematical functions of MySQL & it comes to my mind:
SELECT name,CEIL(ABS(SIN(num_child))) AS has_child from tbClekrs
it returns 1 for num_child>0 and 0 for num_child=0.
I'm sure Rudy will be much happier with this
Though traditionally we rarely calculate the sine (cosine or tangent) of our children. When they get a little annoying I do occasionally get the urge to just floor them - I find this restores peace and order around the house almost immediately.