CODEWITHSUNDEEP
mysqlsql
skirsch00
skirsch00

Reputation: 29

SQL key related error

There's an error in this code probably related to the key, I'm doing something wrong here. (AAAAAA is my test string)

insert ignore into ARCUS (COMPANY_CD, CUSTOMER_NO, RECORD_KEY.COMPANY_CD.CUSTOMER_NO.OPTIONAL_SHIPTO) values ('CU', 'AAAAAA', 'CUAAAAAA    ');

Upvotes: 1

Views: 45

Answers (1)

J Sidhu
J Sidhu

Reputation: 677

Surround with ` (quote). In this case, RECORD_KEY.COMPANY_CD.CUSTOMER_NO.OPTIONAL_SHIPTO

Upvotes: 1

Related Questions