Background Image
마이그레이션
2013.07.12 00:26

CUBRID vs MySQL vs ORACLE SQL 타입별 비교

조회 수 69109 추천 수 0 댓글 0
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄

CUBRID vs MySQL vs ORACLE SQL 타입별 비교

 

CUBRID 8.4.1 vs MySQL 5.5.27 vs  ORACLE 10g 에 대한 SQL 관련 정보들을 비교한다.

 

 

1.    CUBRID와 데이터 타입     

    

           1). DBMS 데이터 타입 비교

구분

CUBRID

MySQL

Oracle

수치형

-

-

BINARY_FLOAT

BIGINT

BIGINT

-

NUMERIC(20)

DECIMAL

DECIMAL

DECIMAL

DOUBLE

DOUBLE

BINARY_DOUBLE

DOUBLE PRECISION

DOUBLE PRECISION

-

FLOAT

FLOAT

FLOAT

INT

MEDIUMINT

-

INT, INTEGER

SMALLINT

INTEGER

INTEGER

-

MONETARY

-

-

NUMERIC(p, s)

-

NUMBER(p, s)

NUMERIC(38, 0)

-

NUMBER(p,0)

NUMERIC(38, 15)

-

NUMBER

NUMERIC(M,D)

FLOAT(M,D) or REAL(M,D) 

-

REAL

-

-

SHORT

-

-

SMALLINT

BIT(1) (>MySQL-5.0)

-

BOOL, BOOLEAN

TINYINT

SMALLINT[(M)]

비트열

BIT VARYING (1073741823)

LONGBLOB

BLOB

LONG RAW

BIT VARYING(16277215)

MEDIUMBLOB

 

BIT VARYING(255)

TINYBLOB

-

BIT VARYING(65535)

BLOB

-

BIT(n)

BIT( > 1) (>MySQL-5.0)

-

BITVARYING(n)

BINARY(M)

RAW(n)

VARBINARY(M)

날짜/시간

DATE

DATE

DATE

: MM/DD/YYYY

: YYYY-MM-DD

: YY/MM/DD

DATETIME

DATETIME

TIMESTAMP

: YYYY-MM-DD HH:MI:SS.FFF 

: YYYY-MM-DD HH:MI:SS

TIMESTAMP WITH LOCAL TIMESTAMP WITH TIME ZONE

 

 

: YY/MM/DD HH:MI:SS.FFFF

TIME

TIME

-

: HH:MI:SS

: HH:MI:SS

TIMESTAMP

TIMESTAMP

TIMESTAMP

: YYYY-MM-DD HH:MI:SS

: YYYY-MM-DD HH:MI:SS

: YY/MM/DD HH:MI:SS.FFFFFFFFF

-

YEAR[(2|4)]

-

: YYYY

문자열

CHAR

CHAR

CHAR

NCHAR VARYING

-

-

NCHAR

-

NCHAR

VARCHAR(16277215)

MEDIUMTEXT

-

VARCHAR(255)

TINYTEXT

INTERVAL DAY TO SECOND

VARCHAR(255)

ENUM('value1','value2',...)

INTERVAL YEAR TO MONTH

VARCHAR(64)

-

ROWID

VARCHAR(64)

-

UROWID

VARCHAR(65535)

TEXT

-

VARCHAR

VARCHAR

NVARCHAR2

VARCHAR2

BLOB

BLOB

BLOB

BLOB

/CLOB

CLOB

-

CLOB

집합형

SET(VARCHAR(255))

SET('value1','value2',...)

-

MULTISET

-

-

LIST

-

-

SEQUENCE

-

-

STRING

LONGTEXT

CLOB

-

-

LONG

-

-

NCLOB

 
           2). 마이그레이션 권장하는 데이터 타입 맵핑 테이블- MySQL to CUBRID

Date Types in MySQL

Date Types in CUBRID

BIT(1) (>MySQL-5.0)

SMALLINT

BIT( > 1) (>MySQL-5.0)

BIT(n)

TINYINT

SMALLINT

BOOL, BOOLEAN

SMALLINT

SMALLINT[(M)]

SMALLINT

INT

MEDIUMINT[(M)]

INT

INT, INTEGER[(M)]

INT

BIGINT

BIGINT[(M)]

BIGINT

NUMERIC(20)

FLOAT[(M,D)]

FLOAT

DOUBLE[(M,B)]

DOUBLE

DECIMAL[(M[,D])]

DOUBLE

DATE

DATE

DATETIME

DATETIME

TIMESTAMP[(M)]

TIMESTAMP

TIME

TIME

YEAR[(2|4)]

CHAR(4)

CHAR(M)

CHAR(n)

VARCHAR(M) [BINARY]

VARCHAR(n)

BINARY(M)

BIT VARYING(n)

VARBINARY(M)

BIT VARYING(n)

TINYBLOB

BIT VARYING(255)

TINYTEXT

VARCHAR(255)

BLOB

BIT VARYING(65535)

TEXT

VARCHAR(65535)

MEDIUMBLOB

BIT VARYING(16277215)

MEDIUMTEXT

VARCHAR(16277215)

LONGBLOB

BIT VARYING (1073741823)

LONGTEXT

STRING

ENUM('value1','value2',...)

VARCHAR(255)

SET('value1','value2',...)

SET(VARCHAR(255))

FLOAT(M,D) or REAL(M,D) or DOUBLE PRECISION(M,D)

NUMERIC(M,D)

 

 

           3). 마이그레이션 권장하는 데이터 타입 맵핑 테이블- ORACLE to CUBRID

Date Types in Oracle

Date Types in CUBRID

BINARY_DOUBLE

DOUBLE

BINARY_FLOAT

FLOAT

BLOB

BIT VARYING (1073741823)

CHAR(n)

CHAR(n)

CLOB

STRING

DATE

DATE

DECIMAL(p, s)

NUMERIC(p, s)

FLOAT

FLOAT

INTERVAL DAY TO SECOND

VARCHAR(255)

INTERVAL YEAR TO MONTH

VARCHAR(255)

LONG

STRING

LONG RAW

BIT VARYING (1073741823)

NCHAR(n)

CHAR(n)

NCLOB

STRING

NUMBER(p, s)

NUMERIC(p, s)

NUMBER

NUMERIC(38, 15)

NUMBER(p,0)

NUMERIC(38, 0)

NVARCHAR2(n)

VARCHAR(n)

RAW(n)

BIT VARYING(n)

ROWID

VARCHAR(64)

TIMESTAMP

DATETIME

TIMESTAMP WITH LOCAL TIME ZONE

DATETIME

TIMESTAMP WITH TIME ZONE

DATETIME

UROWID

VARCHAR(64)

VARCHAR2(n)

VARCHAR(n)

 
 

2.    CUBRID 지원 연산자와 함수

           1). CUBRID 지원연산자

구분

CUBRID 연산자

MySQL 지원여부

논리 연산자

AND, &&

O

OR, ||

O

XOR

O

NOT, !

O

비교 연산자

=

O

<=>

O

<>, !=

O

O

O

>=

O

<=

O

IS boolean_value

O

IS NOT boolean_value

O

산술 연산자

+

O

-

O

*

O

/

O

DIV

O

%, MOD

O

포함 연산자

A SETEQ B

X

A SETNEQ B

X

A SUPERSET B

X

A SUBSET B

X

A SUPERSETEQ B

X

A SUBSETEQ B

X

비트 연산자

&

O

|

O

^

O

~

O

<< 

O

>> 

O

 
           2). CUBRID 지원함수

구분

CUBRID 함수(옵션)

MySQL지원여부

비트함수

BIT_AND(expr)

O

BIT_OR(expr)

O

BIT_XOR(expr)

O

BIT_COUNT (expr)

O

문자열 함수

ASCII(str)

O

BIN( n )

O

BIT_LENGTH ( string )

O

CHAR_LENGTH( string )

O

CHARACTER_LENGTH( string )

O

CHR( number_operand )

CHAR

CONCAT( string1, string2 [,string3 [, ... [, stringN]...]])

O

CONCAT_WS( string1, string2 [,string3 [, ... [, stringN]...]])

O

ELT(N, string1, string2, ... )

O

ELT(N, string1, string2, ... )

O

FIELD( search_string, string1 [,string2 [, ... [, stringN]...]])

O

FIND_IN_SET(str, strlist)

O

INSERT( str, pos, len, string )

O

INSTR( string , substring [, position] )

O

LCASE ( string )

O

LEFT( string , length )

O

LENGTH( string )

O

LENGTHB( string )

X

LOCATE ( substring, string [, position] )

LOCATE

LOAD_FILE

LOWER ( string )

O

LPAD( char1, n, [, char2 ] )

O

LTRIM( string [, trim_string])

O

MID( string, position, substring_length )

O

OCTET_LENGTH ( string )

O

POSITION ( substring IN string )

O

REPEAT( string, count )

O

REPLACE( string, search_string [, replacement_string ] )

O

REVERSE( string )

O

RIGHT( string , length )

O

RPAD( char1, n, [, char2 ] ) 

O

RTRIM( string [, trim_string])

O

SPACE(N)

O

STRCMP( string1 , string2 )

O

SUBSTR( string, position [, substring_length])

O

SUBSTRING( string FROM position [FOR substring_length] )

O

SUBSTRING( string, position [, substring_length])

O

SUBSTRING_INDEX (string, delim, count)

O

TRANSLATE( string, from_substring, to_substring )

X

TRIM ( [ [ LEADING | TRAILING | BOTH ] [ trim_string ] FROM ] string )

O

UCASE ( string )

O

UPPER ( string )

O

수치 연산 함수

ABS( number_operand )

O

ACOS( x )

O

ASIN ( x )

O

ATAN ( [y,] x )

O

ATAN2 ( y, x )

O

CEIL( number_operand )

CEILING

CONV(number,from_base,to_base)

O

COS( x )

O

COT ( x )

O

DEGREES ( x )

O

DRAND( [seed] )

X

DRANDOM( [seed] )

X

EXP( x )

O

FLOOR( number_operand )

O

FORMAT ( x , dec )

O

GREATEST ( expression [, expression]* )

O

HEX(num)

O

HEX(str)

O

LEAST( expression [, expression]* )

O

LN ( x )

O

LOG10 ( x )

O

LOG2 ( x )

O

MOD(m, n)

O

PI()

O

POW( x, y )

O

POWER( x, y )

O

RADIANS ( x )

O

RAND( [seed] )

O

RANDOM( [seed] )

X

ROUND( number_operand, integer )

O

SIGN(number_operand)

O

SIN( x )

O

SQRT( x )

O

TAN( x )

O

TRUNC( x[, dec] )

X

TRUNCATE( x, dec )

O

날짜/시간 함수

ADD_MONTHS ( date_argument , month )

X

ADDDATE(date, days)

O

ADDDATE(date, INTERVAL expr unit)

O

ADDTIME(expr1, expr2)

O

CURDATE()

O

CURRENT_DATE

O

CURRENT_DATE()

O

CURRENT_DATETIME

X

CURRENT_DATETIME()

X

CURRENT_TIME

O

CURRENT_TIME()

O

CURRENT_TIMESTAMP

O

CURRENT_TIMESTAMP()

O

CURTIME()

O

DATE(date)

O

DATE_ADD (date, INTERVAL expr unit)

O

DATE_SUB  (date, INTERVAL expr unit)

O

DATEDIFF (date1, date2)

O

DAY(date)

O

DAYOFMONTH(date)

O

DAYOFWEEK(date)

O

DAYOFYEAR(date)

O

EXTRACT ( field FROM date-time_argument )

O

FROM_DAYS(N)

O

FROM_UNIXTIME ( unix_timestamp[, format] )

O

LAST_DAY ( date_argument )

O

LOCALTIME

O

LOCALTIME()

O

LOCALTIMESTAMP

O

LOCALTIMESTAMP()

O

MAKEDATE(year, dayofyear)

O

MAKETIME(hour, min, sec)

O

MINUTE(time)

O

MONTH(date)

O

MONTHS_BETWEEN (date_argument, date_argument)

X

NOW()

O

QUARTER(date)

O

SEC_TO_TIME(second)

O

SECOND(time)

O

STR_TO_DATE(string, format)

O

SUBDATE(date, days)

O

SUBDATE(date, INTERVAL expr unit)

O

SYS_DATE

X

SYS_DATETIME

X

SYS_TIME

X

SYS_TIMESTAMP

X

SYSDATE

X

SYSDATETIME

X

SYSTIME

X

SYSTIMESTAMP

X

TIME(time)

O

TIME_TO_SEC(time)

O

TIMEDIFF(expr1, expr2)

O

TIMESTAMP(date [,time])

O

TO_DAYS(date)

O

UNIX_TIMESTAMP( [date] )

O

UTC_DATE()

O

UTC_TIME()

O

WEEK(date[, mode])

O

WEEKDAY(date)

O

YEAR(date)

O

데이터 타입 변환 함수

DATE_FORMAT(date, format)

O

TIME_FORMAT(time, format)

O

TO_CHAR( date_time [, format[, date_lang_string_literal ]] )

X

TO_CHAR(number_argument[, format_argument ])

X

TO_DATE(string_argument[,format_argument[,date_lang_string_literal]])

X

TO_DATETIME(string_argument[,format_argument[,date_lang_string_literal]])

X

TO_NUMBER(string_argument[, format_argument ])

X

TO_TIME(string_argument[,format_argument [,date_lang_string_literal]]):

X

TO_TIMESTAMP(string_argument[, format_argument[,date_lang_string_literal]])

X

집계함수

AVG  ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

COUNT ( * | [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

GROUP_CONCAT ([DISTINCT] {col | expression}     

O

                   [ORDER BY {col | unsigned_int} [ASC | DESC]]

                   [SEPARATOR str_val])

MAX  ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

MIN  ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

STDDEV_POP ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL] expression )

STD

SUM  ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

VAR_POP ( [ DISTINCT | UNIQUE | ALL] expression )

O

VAR_SAMP( [ DISTINCT | UNIQUE | ALL] expression )

O

VARIANCE

O

클릭 카운터 함수

INCR

X

정보함수

CURRENT_USER

O

DATABASE()

O

DEFAULT(column_name)

X

INDEX_CARDINALITY (table, index, key_pos)

X

LAST_INSERT_ID()

O

LIST_DBS()

X

ROW_COUNT()

O

SCHEMA()

O

SYSTEM_USER()

O

USER

X

USER()

O

VERSION()

O

암호화 함수

MD5(string)

O

조건 연산식과  함수

CASE control_expression simple_when_list[ else_clause ] END

O

CASE searched_when_list [ else_clause ] END

COALESCE(expression [, ...])

O

DECODE( expression, search, result [, search, result]* [, default] )

O

IF( expression1, expression2, expression3 )

O

IFNULL( expr1, expr2 )

O

NULLIF(expr1, expr2)

O

NVL( expr1, expr2 ) 

X

NVL2( expr1, expr2, expr3 )

X

CUBRID미지원 함수

ATN2

O

CRC32

O

DATENAME

O

LOAD_FILE

O

LOG

O

MAKE_SET

O

NCHAR

O

REPLICATE

O

SQUARE

O

UNICODE

O

 

 

 

3.    CUBRID 예약어

1). DBMS별 예약어 비교

CUBRID

MySQL

ORACLE

ABSOLUTE

-

-

-

-

ACCESS

ACTION

ACTION

-

ADD

ADD

ADD *

ADD_MONTHS

-

-

AFTER

-

-

ALIAS

-

-

ALL

ALL

ALL *

ALLOCATE

-

-

ALTER

ALTER

ALTER *

-

ANALYZE

-

AND

AND

AND *

ANY

-

ANY *

ARE

-

-

AS

AS

AS *

ASC

ASC

ASC *

ASSERTION

-

-

-

ASENSITIVE

-

ASYNC

-

-

AT

-

-

ATTACH

-

-

ATTRIBUTE

-

-

 

-

AUDIT

 

AUTO_INCREMENT

-

AVG

-

-

-

BDB

-

BEFORE

BEFORE

-

-

BERKELEYDB

-

BETWEEN

BETWEEN

BETWEEN *

BIGINT

BIGINT

-

-

BINARY

-

BIT

BIT

-

BIT_LENGTH

-

-

BLOB

BLOB

-

BOOLEAN

-

-

BOTH

BOTH

-

BREADTH

-

-

BY

BY

BY *

CALL

CALL

-

CASCADE

CASCADE

-

CASCADED

-

-

CASE

CASE

-

CAST

-

-

CATALOG

-

-

CHANGE

CHANGE

-

CHAR

CHAR

CHAR *

CHARACTER

CHARACTER

-

CHECK

CHECK

CHECK *

CLASS

-

-

CLASSES

-

-

CLOB

-

-

CLOSE

-

-

CLUSTER

-

CLUSTER

COALESCE

-

-

COLLATE

COLLATE

-

COLLATION

-

-

COLUMN

COLUMN

COLUMN

-

COLUMNS

-

-

CONDITION

-

-

-

COMMENT

COMMIT

-

-

COMPLETION

-

-

-

-

COMPRESS

CONNECT

-

CONNECT *

CONNECTION

CONNECTION

-

CONNECT_BY_ISCYCLE

-

-

CONNECT_BY_ISLEAF

-

-

CONNECT_BY_ROOT

-

-

CONSTRAINT

CONSTRAINT

-

CONSTRAINTS

-

-

CONTINUE

CONTINUE

-

CONVERT

-

-

CORRESPONDING

-

-

COUNT

-

-

CREATE

CREATE

CREATE *

CROSS

CROSS

-

CURRENT

-

CURRENT *

CURRENT_DATE

CURRENT_DATE

-

CURRENT_DATETIME

-

-

CURRENT_TIME

CURRENT_TIME

-

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

-

CURRENT_USER

-

-

CURSOR

CURSOR

-

CYCLE

-

-

DATA

-

-

DATA_TYPE

-

-

DATABASE

DATABASE

-

-

DATABASES

-

DATE

DATE

DATE *

DATETIME

-

-

DAY

-

-

DAY_HOUR

DAY_HOUR

-

-

DAY_MICROSECOND

-

DAY_MILLISECOND

-

-

DAY_MINUTE

DAY_MINUTE

-

DAY_SECOND

DAY_SECOND

-

DEALLOCATE

-

-

DEC

DEC

-

DECIMAL

DECIMAL

DECIMAL *

DECLARE

DECLARE

-

DEFAULT

DEFAULT

DEFAULT *

DEFERRABLE

-

-

DEFERRED

-

-

-

DELAYED

-

DELETE

DELETE

DELETE *

DEPTH

-

-

DESC

DESC

DESC *

DESCRIBE

DESCRIBE

-

DESCRIPTOR

-

-

-

DETERMINISTIC

-

DIAGNOSTICS

-

-

DICTIONARY

-

-

DIFFERENCE

-

-

DISCONNECT

-

-

DISTINCT

DISTINCT

DISTINCT *

DISTINCTROW

DISTINCTROW

-

DIV

DIV

-

DO

-

-

DOMAIN

-

-

DOUBLE

DOUBLE

-

DROP

DROP

DROP *

DUPLICATE

-

-

EACH

-

-

ELSE

ELSE

ELSE *

ELSEIF

ELSEIF

-

-

ENCLOSED

-

END

-

-

-

ENUM

-

EQUALS

-

-

ESCAPE

-

-

-

ESCAPED

-

EVALUATE

-

-

EXCEPT

-

-

EXCEPTION

-

-

EXCLUDE

-

-

-

-

EXCLUSIVE

EXEC

-

-

EXECUTE

-

-

EXISTS

EXISTS

EXISTS

-

EXIT

-

-

EXPLAIN

-

EXTERNAL

-

-

EXTRACT

-

-

FALSE

FALSE

-

FETCH

FETCH

-

FILE

-

FILE

-

FIELDS

-

FIRST

-

-

FLOAT

FLOAT

FLOAT *

FOR

FOR

FOR *

-

FORCE

-

FOREIGN

FOREIGN

-

FOUND

FOUND

-

-

FRAC_SECOND

-

FROM

FROM

FROM *

FULL

-

-

-

FULLTEXT

-

FUNCTION

-

-

GENERAL

-

-

GET

-

-

GLOBAL

-

-

GO

-

-

GOTO

-

-

GRANT

GRANT

GRANT *

GROUP

GROUP

GROUP *

HAVING

HAVING

HAVING *

-

HIGH_PRIORITY

-

HOUR

-

-

HOUR_MILLISECOND

HOUR_MICROSECOND

-

HOUR_MINUTE

HOUR_MINUTE

-

HOUR_SECOND

HOUR_SECOND

-

-

-

IDENTIFIED

IDENTITY

-

-

IF

IF

-

IGNORE

IGNORE

-

IMMEDIATE

-

IMMEDIATE *

IN

IN

IN *

-

-

INCREMENT

INDEX

INDEX

INDEX

INDICATOR

-

-

-

INFILE

-

INHERIT

-

-

-

-

INITIAL

INITIALLY

-

-

INNER

INNER

-

-

INNODB

-

INOUT

INOUT

-

INPUT

-

-

-

INSENSITIVE

-

INSERT

INSERT

INSERT *

INT

INT

-

INTEGER

INTEGER

INTEGER *

INTERSECT

-

INTERSECT *

INTERSECTION

-

-

INTERVAL

INTERVAL

-

INTO

INTO

INTO *

-

IO_THREAD

-

IS

IS

IS *

ISOLATION

-

-

-

ITERATE

-

JOIN

JOIN

-

KEY

KEY

-

-

KEYS

-

-

KILL

-

LANGUAGE

-

-

LAST

-

-

LDB

-

-

LEADING

LEADING

-

LEAVE

LEAVE

-

LEFT

LEFT

-

LESS

-

-

LEVEL

-

LEVEL *

LIKE

LIKE

LIKE *

LIMIT

LIMIT

-

LIST

-

-

-

LINES

-

-

LOAD

-

LOCAL

-

-

LOCAL_TRANSACTION_ID

-

-

LOCALTIME

LOCALTIME

-

LOCALTIMESTAMP

LOCALTIMESTAMP

-

-

LOCK

LOCK

-

LONG

LONG

-

LONGBLOB

-

-

LONGTEXT

-

LOOP

LOOP

-

LOWER

-

-

-

LOW_PRIORITY

-

-

MASTER_SERVER_ID

-

MATCH

MATCH

-

MAX

-

-

-

-

MAXEXTENTS

METHOD

-

-

-

MEDIUMBLOB

-

-

MEDIUMINT

-

-

MEDIUMTEXT

-

-

MIDDLEINT

-

MILLISECOND

-

-

MIN

-

-

MINUTE

-

-

-

-

MINUS

-

MINUTE_MICROSECOND

-

MINUTE_MILLISECOND

-

-

MINUTE_SECOND

MINUTE_SECOND

-

-

-

MLSLABEL

MOD

MOD

-

-

-

MODE

MODIFY

-

MODIFY

MODULE

-

-

MONETARY

-

-

MONTH

-

-

MULTISET

-

-

MULTISET_OF

-

-

NA

-

-

NAMES

-

-

NATIONAL

NATURAL

-

NATURAL

-

-

NCHAR

-

-

NEXT

-

-

NO

NO

-

-

NO_WRITE_TO_BINLOG 

-

-

-

-

-

-

NOAUDIT

NONE

-

NOCOMPRESS

NOT

NOT

NOT *

-

-

NOWAIT

NULL

NULL

NULL *

NULLIF

-

-

-

-

NUMBER

NUMERIC

NUMERIC

-

OBJECT

-

-

OCTET_LENGTH

-

-

OF

-

OF *

OFF

-

-

-

-

OFFLINE

OID

-

-

ON

ON

ON *

-

-

ONLINE

ONLY

-

-

OPEN

-

-

OPERATION

-

-

OPERATORS

-

-

-

OPTIMIZE

-

OPTIMIZATION

-

-

OPTION

OPTION

OPTION *

-

OPTIONALLY

-

OR

OR

OR *

ORDER

ORDER

ORDER *

OTHERS

-

-

OUT

OUT

-

OUTER

OUTER

-

-

OUTFILE

-

OUTPUT

-

-

OVERLAPS

-

-

PARAMETERS

-

-

PARTIAL

-

-

-

-

PCTFREE

PENDANT

-

-

POSITION

-

-

PRECISION

PRECISION

-

PREORDER

-

-

PREPARE

-

-

PRESERVE

-

-

PRIMARY

PRIMARY

-

PRIOR

-

PRIOR *

PRIVATE

-

-

PRIVILEGES

PRIVILEGES

PRIVILEGES *

PROCEDURE

PROCEDURE

-

PROTECTED

-

-

PROXY

-

-

-

-

PUBLIC *

-

PURGE

-

QUERY

-

-

-

-

RAW

-

-

-

READ

READ

-

REAL

REAL

-

RECURSIVE

-

-

REF

-

-

REFERENCES

REFERENCES

-

REFERENCING

-

-

REGEXP

REGEXP

-

REGISTER

-

-

RELATIVE

-

-

RENAME

RENAME

RENAME

-

REPEAT

-

REPLACE

REPLACE

-

RESIGNAL

-

-

-

-

RESOURCE

-

REQUIRE

-

RESTRICT

RESTRICT

-

RETURN

RETURN

-

RETURNS

-

-

REVOKE

REVOKE

REVOKE *

RIGHT

RIGHT

-

RLIKE

RLIKE

-

ROLE

-

-

ROLLBACK

-

-

ROLLUP

-

-

ROUTINE

-

-

ROW

-

ROW

-

-

ROWID

ROWNUM

-

ROWNUM

ROWS

-

ROWS *

SAVEPOINT

-

-

SCHEMA

-

-

SCOPE

-

-

SCROLL

-

-

SEARCH

-

-

SECOND

-

-

-

SECOND_MICROSECOND

-

SECOND_MILLISECOND

-

-

SECTION

-

-

SELECT

SELECT

SELECT *

SENSITIVE

SENSITIVE

-

-

SEPARATOR

-

SEQUENCE

-

-

SEQUENCE_OF

-

-

SERIALIZABLE

-

-

SESSION

-

SESSION *

SESSION_USER

-

-

SET

SET

SET *

SET_OF

-

-

SETEQ

-

-

-

-

SHARE

SHARED

-

-

-

SHOW

-

SIBLINGS

-

-

SIGNAL

-

-

SIMILAR

-

-

SIZE

-

SIZE *

SMALLINT

SMALLINT

SMALLINT *

SOME

SOME

-

-

SONAME

-

-

SPATIAL

-

-

SPECIFIC

-

SQL

SQL

-

SQLCODE

-

-

SQLERROR

-

-

-

SQL_BIG_RESULT

-

-

SQL_CALC_FOUND_ROWS

-

-

SQL_SMALL_RESULT

-

-

SQL_TSI_DAY

-

-

SQL_TSI_FRAC_SECOND

-

-

SQL_TSI_HOUR

-

-

SQL_TSI_MINUTE

-

-

SQL_TSI_MONTH

-

-

SQL_TSI_QUARTER

-

-

SQL_TSI_SECOND

-

-

SQL_TSI_WEEK

-

-

SQL_TSI_YEAR

-

SQLEXCEPTION

SQLEXCEPTION

-

SQLSTATE

SQLSTATE

-

SQLWARNING

SQLWARNING

-

-

SSL

-

-

-

START

-

STARTING

-

STATISTICS

-

-

-

STRAIGHT_JOIN

-

STRING

-

-

-

STRIPED

-

STRUCTURE

-

-

SUBCLASS

-

-

SUBSET

-

-

SUBSETEQ

-

-

SUBSTRING

-

-

-

-

SUCCESSFUL

SUM

-

-

SUPERCLASS

-

-

SUPERSET

-

-

SUPERSETEQ

-

-

-

-

SYNONYM

SYS_CONNECT_BY_PATH

-

-

SYS_DATE

-

-

SYS_DATETIME

-

-

SYS_TIME

-

-

SYS_TIMESTAMP

-

-

SYS_USER

-

-

SYSDATE

-

SYSDATE

SYSDATETIME

-

-

SYSTEM_USER

-

-

SYSTIME

-

-

TABLE

TABLE

TABLE *

-

TABLES

-

TEMPORARY

-

-

-

TERMINATED

-

TEST

-

-

-

TEXT

-

THEN

THEN

THEN *

THERE

-

-

TIME

TIME

-

TIMESTAMP

TIMESTAMP

-

-

TIMESTAMPADD

-

-

TIMESTAMPDIFF

-

TIMEZONE_HOUR

-

-

TIMEZONE_MINUTE

-

-

-

TINYBLOB

-

-

TINYINT

-

-

TINYTEXT

-

TO

TO

TO *

TRAILING

TRAILING

-

TRANSACTION

-

-

TRANSLATE

-

-

TRANSLATION

-

-

TRIGGER

-

TRIGGER

TRIM

-

-

TRUE

TRUE

-

TRUNCATE

-

-

TYPE

-

-

-

-

UID

UNDER

-

-

-

UNDO

-

UNION

UNION

UNION *

-

-

-

UNIQUE

UNIQUE

UNIQUE *

UNKNOWN

-

-

-

UNLOCK

-

-

UNSIGNED

-

UPDATE

UPDATE

UPDATE *

UPPER

-

-

USAGE

USAGE

-

USE

USE

-

USER

-

USER *

-

USER_RESOURCES

-

USING

USING

-

UTIME

-

-

-

UTC_DATE

-

-

UTC_TIME

-

-

UTC_TIMESTAMP

-

-

-

VALIDATE

VALUE

-

-

VALUES

VALUES

VALUES *

-

VARBINARY

-

VARCHAR

VARCHAR

VARCHAR *

-

-

VARCHAR2

VARIABLE

-

-

-

VARCHARACTER

-

VARYING

VARYING

-

VCLASS

-

-

VIEW

-

VIEW *

VIRTUAL

-

-

VISIBLE

-

-

WAIT

-

-

WHEN

WHEN

-

WHENEVER

-

WHENEVER *

WHERE

WHERE

WHERE

WHILE

WHILE

-

WITH

WITH

WITH *

WITHOUT

-

-

WORK

-

-

WRITE

WRITE

-

XOR

XOR

-

YEAR

-

-

YEAR_MONTH

YEAR_MONTH

-

-

ZEROFILL 

-

ZONE

-

-

 

 


  1. CMT를 이용하여 원본 특정 테이블의 일부 데이터만 가져와 대상 테이블에 넣기

  2. MySQL 테이블 크기 조사하기-공유

  3. CUBRID와 Oracle의 NULL과 '' (empty string)의 처리 차이점

  4. CM(CUBRID Manager)을 이용하여 행정표준코드시스템의 기관코드 가져오기

  5. CUBRID vs MySQL vs ORACLE SQL 타입별 비교

  6. MySQL+XE를 CUBRID+XE로 운영하기 – mysqldump파일과 CMT사용

  7. MySQL에서 CUBRID로 갈아탈 때 알아야 할 것

  8. 오라클의 order by 시 first와 last 대체 사용법

  9. CUBRID Migration Tookit 8.4.1

  10. 데이터베이스 마이그레이션(unloaddb & loaddb) 의 효과적인 수행방법

  11. MySQL에서 사용하는 스키마 변환시 주의 사항

  12. 오라클 to CUBRID로 마이그레이션 수행 시 주의사항

  13. 타 DBMS를 CUBRID로 마이그레이션 시 varchar,char 컬럼 사이즈 관련

  14. 타 DB 에서 마이그레이션시 질의 변경 샘플 - CASE 문

  15. CUBRID는 MySQL의 varchar(255)와 동일한 길이가 아닌가요?

  16. CUBRID 하위버젼에서 CUBRID2008로의 업그레이드 방법

  17. MySQL의 limit 명령어 처리

Board Pagination Prev 1 Next
/ 1

Contact Cubrid

대표전화 070-4077-2110 / 기술문의 070-4077-2113 / 영업문의 070-4077-2112 / Email. contact_at_cubrid.com
Contact Sales