Tuesday, September 14, 2010

MySQL - little tips - concat function

mysql sharing

this one is correct
SELECT CONCAT('tag_history_' , date_format(sysdate() , '%Y%m%d%H'));

this one is incorrect as concat( is not allow to leave a space in query browser.
SELECT CONCAT ('tag_history_' , date_format(sysdate() , '%Y%m%d%H'));

No comments:

Post a Comment