>I have problems with column aliasing using AS when I select
>rows with the same string:
>
>.headers ON
>CREATE TABLE TEST1 (name TEXT,value TEXT);
>INSERT INTO TEST1 VALUES ("name1","value1");
>SELECT value AS name1 FROM TEST1 WHERE name="name1"; // gives no result
>SELECT value AS name1_ FROM T
Hello everybody,
I have problems with column aliasing using AS when I select
rows with the same string:
.headers ON
CREATE TABLE TEST1 (name TEXT,value TEXT);
INSERT INTO TEST1 VALUES ("name1","value1");
SELECT value AS name1 FROM TEST1 WHERE name="name1"; // gives no result
SELECT value AS name
2 matches
Mail list logo