Code: Select all
CREATE TABLE biolife(
"Species No" REAL DEFAULT 0.0 ,
Category VARCHAR(15) DEFAULT '' ,
Common_Name VARCHAR(30) DEFAULT '' ,
"Species Name" VARCHAR(40) DEFAULT '' ,
"Length (cm)" REAL DEFAULT 0.0 ,
Length_In REAL DEFAULT 0.0 ,
Notes TEXT ,
Graphic BYTEA
);
dbMonitor have a message:
Code: Select all
INSERT INTO biolife
(Species No, category, common_name, Species Name, Length (cm), length_in, notes, graphic)
values
($1, $2, $3, $4, $5, $6, $7, $8)
It should:
Code: Select all
INSERT INTO biolife
("Species No", category, common_name, "Species Name", "Length (cm)", length_in, notes, graphic)
values
($1, $2, $3, $4, $5, $6, $7, $8)
Code: Select all
??語�??�誤"?��??��? No