SELECT * FROM BATCH_INFO20 WHERE FIND_IN_SET(DATE_FORMAT(NOW(), '%H'), EXEC_HOURS);

 

(stackoverflow.com/questions/18710921/mysql-find-in-set-with-array-string)


with recursive T as ( select 'a,b,c,d,e,f' as items), N as ( select 1 as n union select n + 1 from N, T where n <= length(items) - length(replace(items, ',', ''))) select distinct substring_index(substring_index(items, ',', n), ',', -1) group_name from N, T

 

(stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows)


The question mark means the code is not yet added and committed to your repository

(community.openhab.org/t/solved-eclipse-ide-meaning-of-symbols-in-package-explorer-creating-a-jar-file/66620)



linux, source

카테고리 없음 2021. 4. 14. 15:28


mysql -NB -u root my_database -e 'show create procedure `myProcedure`' |\
xargs -n 1 -d '\t' echo |\
egrep '^CREATE' |\
xargs --null echo -e >

stackoverflow.com/questions/2518459/mysql-mysqldump-routines-to-only-export-1-stored-procedure-by-name-and-not/7080270#7080270


mysql -NB -u root my_database -e 'show create procedure `myProcedure`' |\
xargs -n 1 -d '\t' echo |\
egrep '^CREATE' |\
xargs --null echo -e >

stackoverflow.com/questions/2518459/mysql-mysqldump-routines-to-only-export-1-stored-procedure-by-name-and-not/7080270#7080270