mysqlpasswordscreate-tableidentity-columnreserved

Creating a table with a column named ''PASSWORD"


Here is my script and the error I am getting. What am I doing wrong?

create table PHONE_USERS (
 TELEPHONE_NUMBER VARCHAR2(80)  NOT NULL, PRIMARY KEY 
 FIRST_NAME VARCHAR2(80),
 LAST_NAME VARCHAR2(80),
 KEYMAP_LASTNAME CHAR(4), 
"PASSWORD" VARCHAR2(80),
 CONSTRAINT LAST_NAME UNIQUE (TELEPNONE_NUMBER)
 );

Error at Command Line : 7 Column : 31
Error report -
SQL Error: ORA-00904: "TELEPNONE_NUMBER": invalid identifier 00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:


Solution

  • TELEPNONE_NUMBER is misspelled. Is must be TELEPHONE_NUMBER

    create table PHONE_USERS (
     TELEPHONE_NUMBER VARCHAR2(80)  NOT NULL PRIMARY KEY, 
     FIRST_NAME VARCHAR2(80),
     LAST_NAME VARCHAR2(80),
     KEYMAP_LASTNAME CHAR(4), 
    "PASSWORD" VARCHAR2(80),
     CONSTRAINT LAST_NAME UNIQUE (TELEPHONE_NUMBER)
     );