SELECT 'a' = 'A'; -- 1
SELECT BINARY 'a' = 'A'; -- 0
(dev.mysql.com/doc/refman/5.7/en/cast-functions.html#operator_binary)
'분류 전체보기'에 해당되는 글 666건
- 2021.05.07 MySQL, case insensitive (default)
- 2021.04.30 linux, date
- 2021.04.29 vi, 빈 줄 지우기
- 2021.04.20 mysql, FIND_IN_SET
- 2021.04.20 mysql, comma string to multi rows
- 2021.04.19 eclipse, java 물음표
- 2021.04.19 javascript, freeze
- 2021.04.14 linux, source
- 2021.04.07 javascript, ~~
- 2021.04.07 mysql, dump procedure
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
mysql -NB -u root my_database -e 'show create procedure `myProcedure`' |\
xargs -n 1 -d '\t' echo |\
egrep '^CREATE' |\
xargs --null echo -e >
