#멋쟁이사자처럼 #부트캠프 #백엔드 #JAVA

URLs to Check

• MySQL: JOINS are easy (INNER, LEFT, RIGHT)
• IN, ANY, ALL 설명

Indexes

Viewing Indexes

SHOW INDEX FROM employees;

Creating Indexes

CREATE INDEX ind_employees_first_name ON employees(first_name);

Dropping Indexes

DROP INDEX ind_employees_first_name ON employees;

Functions

LPAD, RPAD

SELECT LPAD('hi', 5, '?');
SELECT LPAD(ename, 10, '*') FROM emp;

SELECT empno, LPAD(CAST(sal AS CHAR), 10, '*') FROM emp;

SELECT RPAD('hi', 5, '?');
SELECT RPAD(ename, 10, '*') FROM emp;

TRIM