How to use mysql function concatenation to query concat functions, mysqlconcat

How to use mysql function concatenation to query concat functions, mysqlconcat

As follows:

// Query the year and month of the managefee_managefee table. Use the concat function to combine them into year-month. For example, splice 2017 and 1 into 2017-01 .. Select CONCAT (. year, '-', if (. month <= 9, CONCAT ('0',. month),. month) as date,. * from managefee_manage1_as a; // query the data of the period from to in managefee_manage1_select * from (select CONCAT (. year, '-', if (. month <= 9, CONCAT ('0',. month),. month) as date,. * from managefee_manage%as a) bwhere B. date between '2014-01 'and '2014-07 ';

The usage of the above mysql function concatenation query concat function is all the content that I have shared with you. I hope to give you a reference and support for the help house.