-
https://blog.naver.com/jam_jaming/223297392193
4-1) CONCAT(구분자, 문자열1, 문자열2, ~) : 구분자와 함께 문자열 이어줌 5) ELT(위치, 문자열1... CREATE OR REPLACE VIEW~ AS SELECT 뷰의 삭제 : DROP VIEW 4. 인덱스 데이터를 쉽고 빠르게 찾을 수 있도록 만든...
-
https://calebpro.tistory.com/640
BIT_COUNT BIT_LENGTH BIT_OR BIT_XOR CASE CAST CEIL CEILING CHAR Function CHAR_LENGTH CHARACTER_LENGTH CHARSET COALESCE COMPRESS CONCAT CONCAT_WS CONNECTION_ID CONTAINS CONV CONVERT...
-
https://blog.naver.com/heroiron/80015303546
SQL> SELECT 1+1 FROM DUAL; 1+1 ---------- 2 SQL> SELECT 'A' || 'B' FROM DUAL; 'A -- AB SQL> SELECT 'A... (N_or_S) : 16진수로 변환 CONCAT_WS(separator, str1, str2,...) : 분리기호와 함께 사용 OCTET...
-
https://blog.naver.com/enanim/80017387751
+--------+ | !(1+1) | +--------+ | 0 | +--------+ mysql의 함수 MYSQL -3- 1 row in set (0.01 sec) mysql> SELECT ! 1+1; +-------+ | ! 1+1 | +-------+ | 1 | +-------+ 1 row in set (0.00 sec) 6.3.2 || (OR)...
-
https://dbrang.tistory.com/907
Complement of function field is function elt: CREATE OR REPLACE FUNCTION elt(int, VARIADIC text[]) RETURNS text AS $$ SELECT $2[$1]; $$ LANGUAGE sql; The first from groups (with windows...
-
https://blog.naver.com/aseep3/222709529907
CONCAT('1','2') => '12' SELECT CONCAT_WS('/','1','2') => '1/2' : ELT(위치,문자열1,문자열2...) : 위치... : FOUND_ROWS() : 조회된 행 개수 구함 : ROW_COUNT() : 바로 앞의 INSERT, UPDATE, DELETE문에서 입력 수정...