Writing UNION statements in MySQL 3.x - Conclusion

(Page 4 of 4 )

Even though we still wait for the anticipated release of MySQL 4.0, we need not live without UNION statements until then. I hope this is of some use to somebody. I know that when I came up with this idea that it has helped me in many situations. Realize that the dummy table and this method can be employed in many ways to create very complex queries and would have been impossible without it.

About the Author

Michael Bailey (aka jinxidoru)Email: jinxidoru@byu.netWebsite: http://www.nstep.net/~mpbailey

Michael Bailey lives in Provo, UT where he studies math at BYU. He has worked for various companies doing work in PHP, Java, Perl, and various other languages. He is always looking for new subjects on which to write and is always open to answer questions (as long as they're not overly metaphysical).

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Writing UNION statements in MySQL 3.x

>>> Be the FIRST to comment on this article!