'2019/01'에 해당되는 글 34건

노란색까지는 상호연결 가능

Key:

Yes	Supported
ES	Supported but fixes only possible for customers with Extended Support.
Was	Was a supported combination but one of the releases is no longer covered by any of Premier Support , Primary Error Correct support , Extended Support nor Extended Maintenance Support so fixes are no longer possible.
No	Has never been Supported

오라클 버전별 출시년도

Oracle : 

LIKE '%' || #searchKeyword# || '%'

MySQL(MariaDB) : 

LIKE CONCAT('%', #{searchKeyword}, '%')

Sql Server (MSSQL) : 

LIKE '%' + #searchKeyword# + '%'

1. 원본테이블로부터 임시테이블을 만들고

CREATE TABLE TEMP

AS

SELECT 

칼럼2, 

칼럼3, 

칼럼1 

FROM 원본테이블;

2. 원본 테이블을 삭제하고

DROP TABLE 원본테이블;

3. 임시테이블 이름을 원본테이블 이름과 동일하게 변경한다.

RENAME TEMP TO 원본테이블;