测试用的表CREATE TABLE testtbl2
(
id uuid NOT NULL DEFAULT uuid_generate_v4(),
intarray integer[],
int2array integer[],
CONSTRAINT testtb2_pk PRIMARY KEY (id )
)
WITH (
OIDS=FALSE
);
ALTER TABLE testtbl2
OWNER TO postgres;
GRANT ALL ON TABLE testtbl2 TO postgres;
GRANT ALL ON TABLE testtbl2 TO public;插入数据INSERT INTO testtbl2(
intarray, int2array)
VALUES ('{10000,10000,10000,10000}','{20000,20000,20000,20000}');查找数据SELECT id, intarray, int2array
FROM testtbl2;结果
"2da36aad-c9ff-439a-b7eb-2ba3429c30af";"{10000,10000,10000,10000}";"{20000,20000,20000,20000}"------------------------------------------------------------------------------------------------
插入和查找数据应该怎么搞?为了防止sql注入要求使用参数化操作
(
id uuid NOT NULL DEFAULT uuid_generate_v4(),
intarray integer[],
int2array integer[],
CONSTRAINT testtb2_pk PRIMARY KEY (id )
)
WITH (
OIDS=FALSE
);
ALTER TABLE testtbl2
OWNER TO postgres;
GRANT ALL ON TABLE testtbl2 TO postgres;
GRANT ALL ON TABLE testtbl2 TO public;插入数据INSERT INTO testtbl2(
intarray, int2array)
VALUES ('{10000,10000,10000,10000}','{20000,20000,20000,20000}');查找数据SELECT id, intarray, int2array
FROM testtbl2;结果
"2da36aad-c9ff-439a-b7eb-2ba3429c30af";"{10000,10000,10000,10000}";"{20000,20000,20000,20000}"------------------------------------------------------------------------------------------------
插入和查找数据应该怎么搞?为了防止sql注入要求使用参数化操作
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货