Return to Deli shopping http://www.bbuy8.com
Shopping rebate is the natural, return not high, called Mao rebate
(1) SQL state:42831
[Error Code: -542, SQL state:42831] DB2 SQL error:sqlcode=-542, sqlstate=42831, Sqlerrmc=batch_no, driver=3.57.82
Liezi:
Create Table T_user_import_batch (
Batch_no Char (a) NOT NULL primary key,
STATUS Char (1) NOT NULL,
Create_time char () NOT NULL,
creater varchar (+) NOT NULL,
Audit_time Char (14),
Auditer Varchar (30),
file_name Varchar () NOT NULL,
MEMO Varchar (500)
)
Change to the following OK
Create Table T_user_import_batch (
STATUS Char (1) NOT NULL,
Create_time char () NOT NULL,
creater varchar (+) NOT NULL,
Audit_time Char (14),
Auditer Varchar (30),
file_name Varchar () NOT NULL,
MEMO Varchar (500)
)
Error reason: columns that can be empty are not allowed to be included as part of the primary health . This means that the not NULL attribute must be added as the primary key.
(2) Error Code: -104, SQL state:42601
[Error Code: -104, SQL state:42601] DB2 SQL error:sqlcode=-104, sqlstate=42601, Sqlerrmc=table;delete; JOIN
Example:
DELETE TABLE T_user_import_detail
Change to the following syntax OK
DROP TABLE T_user_import_detail;
Cause of error: illegal character in SQL statement is actually a bad syntax error