by nazham on
September 19th, 2008
I have just found out a nifty little trick regarding MySQL output the other day. I just had to put this up as a reminder to myself, and also to share with the viewers.
Let say, you want to have the output of your SELECT statement created to a text file. The MySQL database server could [...]
by nazham on
September 18th, 2008
I have one problem the other day; Why does my “SELECT * FROM tbl WHERE col IN (@list)” does not work? The col datatype is int, while the @list parameter is a comma-separated varchar.
The Problem
In a stored procedure, I’m composing a SELECT statement with a WHERE clause in which the column condition datatype is integer, while [...]
Tags: SQL
Born and lives my life in the wonderful country of Malaysia. I have been a Software Engineer, and loving it. I built this site as a main purpose of sharing and giving back to the community. Please feel free to give feedbacks and let me know if there's any errata found on this site.
