CREATE TABLE "dba". "ys_fymx" (" ysid "char (9) NOT NULL DEFAULT NULL," yssy varchar (50) DEFAULT NULL, "yslx varchar (10) DEFAULT NULL," yf varchar (2) the DEFAULT NULL, "SQR" varchar (10) DEFAULT NULL, "SQSJ" timestamp DEFAULT NULL, "SHBZ varchar (1) the DEFAULT NULL," SHR "varchar (10) DEFAULT NULL," SHRJ "timestamp DEFAULT NULL," ysje "numeric (19, 4) DEFAULT NULL," sjfsje "numeric (19, 4);
According to the above code input, the system error can't create the data table, troublesome everybody the teacher look, in addition, I am a student of accounting informationization, graduation design some problem can't solve independently, willing to help with the teacher, please add me QQ383534737 help remote, online, etc.,

CodePudding user response:

The

refer to the original poster u012146915 response:

CREATE TABLE "dba". "ys_fymx" (" ysid "char (9) NOT NULL DEFAULT NULL," yssy varchar (50) DEFAULT NULL, "yslx varchar (10) DEFAULT NULL," yf varchar (2) the DEFAULT NULL, "SQR" varchar (10) DEFAULT NULL, "SQSJ" timestamp DEFAULT NULL, "SHBZ varchar (1) the DEFAULT NULL," SHR "varchar (10) DEFAULT NULL," SHRJ "timestamp DEFAULT NULL," ysje "numeric (19, 4) DEFAULT NULL," sjfsje "numeric (19, 4);
According to the above code input, the system error can't create the data table, troublesome everybody the teacher look, in addition, I am a student of accounting informationization, graduation design some problem can't solve independently, willing to help with the teacher, please add me QQ383534737 help remote, online, such as

Try the following SQL

The CREATE TABLE ys_fymx (
Ysid char (9), NOT NULL DEFAULT NULL,
DEFAULT NULL yssy varchar (50),
Yslx varchar (10) DEFAULT NULL,
Yf varchar (2) the DEFAULT NULL,
SQR varchar (10) DEFAULT NULL,
SQSJ timestamp DEFAULT NULL,
SHBZ varchar (1) the DEFAULT NULL,
SHR varchar (10) DEFAULT NULL,
SHRJ timestamp DEFAULT NULL,
Ysje numeric (19, 4) DEFAULT NULL,
Sjfsje numeric (19, 4)
);