MySql用DATE_FORMAT截取DateTime字段的日期值

用 DATE_FORMAT 来格式化日期字段

SELECT DATE_FORMAT(crt_time,'%Y-%m-%d') FROM ad_n_advertise_t

mysql 存储过程输入输出参数示例
dropPROCEDUREifexistsmy_procedure;createPROCEDUREmy_procedure(inmy_idint,outmy_namechar)BEGINselectlist_nameintomy_namefromaa_listwherelist_id=my_id;end;callmy_procedure(24,@a);select@a;

MySQL 存储过程中执行动态SQL语句的方法
dropPROCEDUREifexistsmy_procedure;createPROCEDUREmy_procedure()BEGINdeclaremy_sqllvarchar(500);setmy_sqll='select*fromaa_list';set@ms=my_sqll;PREPAREs1from@ms;EXECUTEs1;deallocateprepares1;end;

mysql如何将多行数据合并成一行
selectgroup_concat(list_name)fromaa_list