Technical Development - Tiveloper.

로그파일이 3기가나 쌓여 있는것도 모르고, 서버가 해킹 당한줄 알았다. 가상서버 호스팅을 사용하는데, mysql을 위한 공간조차 모자라게 된것이다. 덕분에 몇몇 테이블이 손상이 되어 버렸다. ./mysqlcheck -u아이디 -p비번 --auto-repair -B 디비명 명령어로 겨우 회복시켰다. 아직 불안 불안하다.. 더 두고 봐야할듯..T_T 이런걸 바로 무지에서 오는 고생이라고 하는건가?

로그파일이 3기가나 쌓여 있는것도 모르고, 서버가 해킹 당한줄 알았다. 가상서버 호스팅을 사용하는데, mysql을 위한 공간조차 모자라게 된것이다. 덕분에 몇몇 테이블이 손상이 되어 버렸다. ./mysqlcheck -u아이디 -p비번 --auto-repair -B 디비명 명령어로 겨우 회복시켰다. 아직 불안 불안하다.. 더 두고 봐야할듯..T_T 이런걸 바로 무지에서 오는 고생이라고 하는건가?

NEXTVAL : The NEXTVAL pseudocolumns is used to extract successive sequence numbers from a specified sequence. sequence.NEXTVAL CURRVAL : The CURRVAL pseudocolumn is used to refer to a sequence number that the current user has just generated. After you generated a sequence object, you have to call NEXTVAL first because the initiatied pointer of the sequence object is pointing the head of the obje..

NEXTVAL : The NEXTVAL pseudocolumns is used to extract successive sequence numbers from a specified sequence. sequence.NEXTVAL CURRVAL : The CURRVAL pseudocolumn is used to refer to a sequence number that the current user has just generated. After you generated a sequence object, you have to call NEXTVAL first because the initiatied pointer of the sequence object is pointing the head of the obje..

Table : Basic unit of storage; composed of rows View : Logically represents subsets of data from one or more table Sequence : Generates numeric values Index : Improves the performances of some queries Synonym : Gives alternative names to objects

Table : Basic unit of storage; composed of rows View : Logically represents subsets of data from one or more table Sequence : Generates numeric values Index : Improves the performances of some queries Synonym : Gives alternative names to objects

Use the ALTER TABLE statement to:Add a new columnModify an existing columnDefine a default value for the new columnDrop a column

Use the ALTER TABLE statement to:Add a new columnModify an existing columnDefine a default value for the new columnDrop a column

Defines a condition that each row must satisfy The following expressions are not allowed: - References to CURRVAL, NEXTVAL, LEVEL, and ROWNUM pseudocolumns - Call to SYSDATE, UID, USER, and USERENV functions - Queries that refer to other values in other rows ..., salaryNUMBER(2) CONSTRAINTemp_salary_min CHECK (salary > 0),...

Defines a condition that each row must satisfy The following expressions are not allowed: - References to CURRVAL, NEXTVAL, LEVEL, and ROWNUM pseudocolumns - Call to SYSDATE, UID, USER, and USERENV functions - Queries that refer to other values in other rows ..., salaryNUMBER(2) CONSTRAINTemp_salary_min CHECK (salary > 0),...