How can I dump only certain entries of a table based on my condition?

mydriverc2

于 2014-10-22 13:11:15 发布

阅读量439

点赞数

分类专栏： Web类网络

网络同时被 2 个专栏收录

103 篇文章

订阅专栏

Web类

90 篇文章

订阅专栏

本文详细介绍了SQLmap工具的dump功能，特别是如何使用其参数来精细地从数据库中导出表格数据。包括如何使用--dump、--DB、--TBL、--COL等开关进行基本操作，以及如何通过--sql-query和--sql-file选项执行自定义SQL查询以导出特定条件下的数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

https://github.com/sqlmapproject/sqlmap/wiki/FAQ

sqlmap is very granular in terms of dumping entries from a table. The relevant switches are:

--dump              Dump DBMS database table entries
-D DB               DBMS database to enumerate
-T TBL              DBMS database table to enumerate
-C COL              DBMS database table column to enumerate
--start=LIMITSTART  First query output entry to retrieve
--stop=LIMITSTOP    Last query output entry to retrieve
--first=FIRSTCHAR   First query output word character to retrieve
--last=LASTCHAR     Last query output word character to retrieve

However, in some cases you might want to dump all entries given a custom WHEREcondition. For such cases, we recommend using one of the following switches:

--sql-query=QUERY   SQL statement to be executed
--sql-shell         Prompt for an interactive SQL shell
--sql-file=SQLFILE  Execute SQL statements from given file(s)

For example:

--sql-query "SELECT user, password FROM users WHERE privilege='admin'"