웹이야기

MySQL 문자열 함수와 연산자 REPEAT() - 문자열 반복 REPEAT(str, count) 의 형태 Returns a string consisting of the string str repeated count times. If count is less than 1, returns an empty string. Returns NULL if str or count are NULL. mysql> SELECT REPEAT('오늘은', 5); +-----------------------------------------------+ | REPEAT('오늘은', 5) | +-----------------------------------------------+ | 오늘은오늘은오늘은오늘은오늘은 | +-------..

MySQL 문자열 함수와 연산자 QUOTE() - QUOTE(str) 의 형태 Quotes a string to produce a result that can be used as a property escaped data value in an SQL statement. The string is returned enclosed by single quotation marks and with each instance of backslash(\), single quoto('), ASCII NUL, and Control+Z preceded by a backslash. If the argument is NULL, the return value is the world "NULL" without enclosing si..

MySQL 문자열 함수와 연산자 POSITION() - POSITION(substr IN str) 의 형태 POSITION(substr IN str) is synonym for LOCATE(substr, str). https://webobj.tistory.com/184 [MySQL] LOCATE() MySQL 문자열 함수와 연산자 LOCATE() - LOCATE(substr, str) LOCATE(substr, str, pos) 의 형태 The first syntax returns the position of the first occurence of substring substr in string str. The second.. webobj.tistory.com

이제는 모바일 공통컴포넌트를 셋팅해보자. 프로그램 준비는 (데이타베이스, jdk, 톰캣) 아래 URL을 참고한다. 이 글을 더 보기전에 준비가 다 되어 있어야 한다. https://webobj.tistory.com/70 전자정부 표준프레임워크 3.9 all-in-one 처음 셋팅해보기 -1( 프로그램 준비) 전자정부 표준프레임워크 3.9 도 3.8 과 거의 동일하게 셋팅을 진행할 수 있다. 전자정부 표준프레임워크 all-in-one을 셋팅하기 위한 준비 - 데이타베이스(Oracle, MySQL) - Jdk1.8(Java SE 1.8) - Tomcat 8.5 1... webobj.tistory.com 이클립스도 준비가 되어 있어야 한다. https://webobj.tistory.com/71 전자정부 표준프..

MySQL 문자열 함수와 연산지 ORD() - ORD(str) 의 형태 If the leftmost character of the string str is a multibyte character, returns the code for that character, calculated from the numeric values of its constituent bytes using this formula : (1st bye code) + (2nd byte code * 256) + (3rd byte code * 256^2).... If the leftmost character is not a multibyte character, ORD() returns the same value as the ASCII() f..

MySQL 문자열 함수와 연산자 OCTET_LENGTH() - OCTET_LENGTH(str) 의 형태 OCTET_LENGTH() is a synonym for LENGTH().

MySQL 문자열 함수와 연산자 OCT() - OCT(N) 의 형태 Returns a string representation of the octal value of N. where N is a longlong(BIGINT) number. This is equivalent to CONV(N, 10, 8). Returns NULL if N is NULL. mysql> SELECT OCT(12); +---------+ | OCT(12) | +---------+ | 14 | +---------+ 1 row in set (0.00 sec)

MySQL 문자열 함수와 연산자 MID() - MID(str, pos, len) 의 형태 MID(str, pos, len) is a synonym for SUBSTRING(str, pos, len).

MySQL 문자열 함수와 연산자 MAKE_SET() - MAKE_SET(bits, str1, str2, ...) 의 형태 Returns a set value(a string containing substrings separated by , characters) consisting of the strings that have the corresponding bit in bits set. str1 correspondes to bit 0, str2 to bit 1, and so on. NULL values in str1, str2, ... are not appended to the result. mysql> SELECT MAKE_SET(1, 'a', 'b', 'c') ; +--------------------..

MySQL 문자열 함수와 연산자 LTRIM() - LTRIM(str) 의 형태 Returns the string str with leading space characters removed. This function is multibyte safe. mysql> SELECT LTRIM(' aaaa'); +-------------------+ | LTRIM(' aaaa') | +-------------------+ | aaaa | +-------------------+ 1 row in set (0.00 sec)

MySQL 문자열 함수와 연산자 LPAD() - LPAD(str, len, padstr) 의 형태 Returns the string str, left-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters. mysql> SELECT LPAD('hi', 4, '??') ; +---------------------+ | LPAD('hi', 4, '??') | +---------------------+ | ??hi | +---------------------+ 1 row in set (0.00 sec) mysql> SELEC..

MySQL 문자열 함수와 연산자 LOWER() - LOWER(str) 의 형태 Returns the string str with all characters changed to lowercase according to the current character set mapping. The default is utf8mb4. (MySQL 8. x 버전 이상부터 일 것이다.) mysql> SELECT LOWER('ABCD') ; +---------------+ | LOWER('ABCD') | +---------------+ | abcd | +---------------+ 1 row in set (0.00 sec) LOWER() (and UPPER()) are ineffective when applied to b..

MySQL 문자열 함수와 연산자 LOCATE() - LOCATE(substr, str) LOCATE(substr, str, pos) 의 형태 The first syntax returns the position of the first occurence of substring substr in string str. The second syntax returns the position of the first occurence of substring substr in string str, starting at position pos. Returns 0 if substr is not in str. Returns NULL if any argument is NULL. mysql> SELECT LOCATE('bar',..

MySQL 문자열 함수와 연산자 LOAD_FILE() - LOAD_FILE(file_name) 의 형태 Reads the file and returns the file contents as a string. To use this function, the file must be located on the server host, you must specify the full path name to the file, and you must have the FILE privilege. The file must be readable by the server and its size less than max_allowed_packet bytes. If the secure_file_priv system variable..

MySQL 문자열 함수와 연산자 LEFT() - LEFT(str, len) 의 형태 Returns the leftmost len characters from the string str, or NULL if any argument is NULL. mysql> SELECT LEFT ('foobarbar', 5) ; +-----------------------+ | LEFT ('foobarbar', 5) | +-----------------------+ | fooba | +-----------------------+ 1 row in set (0.00 sec) mysql> SELECT LEFT ('foo', 5) ; +-----------------+ | LEFT ('foo', 5) | +------------..

MySQL 문자열 함수와 연산자 LCASE() - LCASE(str) 의 형태 LCASE() is a synonym for LOWER(). LCASE() used in a view is rewritten as LOWER() when storing the view's defination. (Bug #12844279)

MySQL 문자열 함수와 연산자 INSTR() - INSTR(str, substr) 의 형태 Returns the position of the first occurence of sustring substr in string str. This is the same as the two-argument form of LOCATE(), except that the order of the arguments is reversed. This function is multibyte safe, and is case-sensitive only if at least one argument is a binary string. mysql> SELECT INSTR('foobarbar', 'bar') ; +-------------..

MySQL 문자열 함수와 연산자 INSERT() - INSERT(str, pos, len, newstr) 의 형태 Returns the string str, with the substring beginning at position pos and len characters long replaced by the string newstr. Returns the original string if pos is not within the length of the string Replaces the rest of the string from position pos if len is not within the length of the rest of the string. Returns NULL if any argumen..

MySQL 문자열 함수와 연산자 HEX() - HEX(str) HEX(N) 의 형태 For a string argument str, HEX() returns a hexadecimal string representation of str where each byte of each character in str is converted to two hexadecimal digits. (Multibyte characters therefore become more than two digits.) The inverse of this operation is performed by UNHEX() function. For a numeric argument N, HEX() returns a hdxadecimal string..

MySQL 문자열 함수와 연산자 FROM_BASE64() - FROM_BASE64(str) 의 형태 Takes a string encoded with the base-64 encoded rules used by TO_BASE64() and returns the decoded result as a binary string. The result is NULL if the argument is NULL or not a valid base-64 string. mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc')) ; +------------------+-------------------------------+ | TO_BASE64('abc') | FROM_..