IT Base of Knowledge’s Weblog

November 11, 2009

Find duplicate in a database

Filed under: Uncategorized — itbdc @ 7:10 pm


SELECT my_key, count(*) FROM my_table GROUP BY my_key HAVING count(*) > 1;

April 7, 2009

Draw a rectangle on an image

Filed under: Uncategorized — itbdc @ 5:44 pm

convert -draw “rectangle x0 y0 x1 y1″ -fill none -stroke red -strokewidth 5

October 17, 2008

How to know size of a binarie in sql

Filed under: Uncategorized — itbdc @ 4:52 pm

datalength(binary)

Blog at WordPress.com.