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

CUBRID vs MySQL vs ORACLE SQL 타입별 비교

조회 수 69110 추천 수 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

-

-

 

 


List of Articles
번호 분류 제목 글쓴이 날짜 조회 수
279 운영관리 csql 데이터 입력방법 정만영 2009.06.09 212717
» 마이그레이션 CUBRID vs MySQL vs ORACLE SQL 타입별 비교 정만영 2013.07.12 69110
277 응용개발 weblogic 8.1 에 CUBRID Connection Pool, DataSource 설정 방법 file 웁쓰 2009.07.01 66305
276 응용개발 WHERE 조건에서 다중 컬럼 IN절 처리 최적화 방법 (cubrid + ibatis) 1 이상신 2015.08.21 55069
275 응용개발 Weblogic 10.0 사용시 JDK 1.5를 사용한 JDBC 드라이버 사용시 주의사항. cubebridge 2012.02.22 51957
274 마이그레이션 타 DBMS를 CUBRID로 마이그레이션 시 varchar,char 컬럼 사이즈 관련 손승일 2010.07.01 38014
273 질의작성 데이터 존재하면 update, 존재하지 않으면 insert 방법(ON DUPLICATE KEY UPDATE) 손승일 2010.08.11 37990
272 질의작성 예약어를 테이블명이나 컬럼명으로 사용시 admin 2008.11.21 37308
271 응용개발 JDBC 사용시 SQL 로깅 - p6spy 사용 1 웁쓰 2009.07.01 35986
270 응용개발 CUBRID AUTO_INCREMENT 컬럼 MySQL LAST_INSERT_ID() 대체 방법 손승일 2009.12.22 33233
269 운영관리 CUBRID에서의 BLOB/CLOB 사용시 백업 및 복구에 대한 주의 점 cubebridge 2012.09.18 33156
268 마이그레이션 MySQL의 limit 명령어 처리 1 admin 2008.11.21 32682
267 기타 좀비 프로세스 일괄 삭제하기 janus 2009.12.12 32097
266 CUBRID 매니저 Java SP사용시 JNI_CreateJavaVM 에러메시지 해결 방법 file seongjoon 2009.07.15 32041
265 응용개발 php에서 serialize/unserialize 사용 시 주의할 점 시난 2009.12.29 31624
264 운영관리 CUBRID 사용시 방화벽 설정 3 admin 2008.11.21 30980
263 마이그레이션 CUBRID 하위버젼에서 CUBRID2008로의 업그레이드 방법 1 남재우 2008.12.06 30153
262 운영관리 큐브리드 사용포트 정리 3 정만영 2009.06.19 29745
261 질의작성 CUBRID DB 내의 auto_increment 값을 초기화 하자. 손승일 2009.10.28 29718
260 응용개발 CUBRID와 Oracle에서의 ''(공백)의 차이 비교 cubebridge 2010.10.01 28582
Board Pagination Prev 1 2 3 4 5 6 7 8 9 10 ... 14 Next
/ 14

Contact Cubrid

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