|
4 | 4 |
|
5 | 5 | <title>sqlmap user's manual |
6 | 6 | <author>by <htmlurl url="mailto: [email protected]" name="Bernardo Damele A. G."> |
7 | | -<date>version 0.6.4, DDth of MMM 2009 |
| 7 | +<date>version 0.6.4, 3rd of February 2009 |
8 | 8 | <abstract> |
9 | 9 | This document is the user's manual to use <htmlurl url="http://sqlmap.sourceforge.net" name="sqlmap">. |
10 | 10 | Check the project <htmlurl url="http://sqlmap.sourceforge.net" name="homepage"> |
@@ -362,7 +362,7 @@ $ python sqlmap.py -h |
362 | 362 |
|
363 | 363 | sqlmap/0.6.4 coded by Bernardo Damele A. G. < [email protected]> |
364 | 364 | and Daniele Bellucci < [email protected]> |
365 | | - |
| 365 | + |
366 | 366 | Usage: sqlmap.py [options] |
367 | 367 |
|
368 | 368 | Options: |
@@ -3698,27 +3698,39 @@ back-end DBMS: PostgreSQL |
3698 | 3698 | sql> SELECT COUNT(name) FROM users |
3699 | 3699 | [10:11:57] [INFO] fetching SQL SELECT statement query output: 'SELECT COUNT(name) FROM users' |
3700 | 3700 | [10:11:57] [INPUT] can the SQL query provided return multiple entries? [Y/n] n |
3701 | | -[10:11:59] [INFO] query: SELECT COALESCE(CAST(COUNT(name) AS CHARACTER(10000)), CHR(32)) FROM users |
| 3701 | +[10:11:59] [INFO] query: SELECT COALESCE(CAST(COUNT(name) AS CHARACTER(10000)), CHR(32)) |
| 3702 | +FROM users |
3702 | 3703 | [10:11:59] [INFO] retrieved: 4 |
3703 | 3704 | [10:11:59] [INFO] performed 13 queries in 0 seconds |
3704 | 3705 | SELECT COUNT(name) FROM users: '4' |
3705 | 3706 |
|
3706 | 3707 | sql> INSERT INTO users (id, name, surname) VALUES (5, 'from', 'sql shell'); |
3707 | 3708 | [10:12:35] [INFO] testing stacked queries support on parameter 'id' |
3708 | 3709 | [10:12:40] [INFO] the web application supports stacked queries on parameter 'id' |
3709 | | -[10:12:40] [INFO] executing SQL data manipulation query: 'INSERT INTO users (id, name, surname) VALUES (5, 'from', 'sql shell');' |
| 3710 | +[10:12:40] [INFO] executing SQL data manipulation query: 'INSERT INTO users (id, name, surname) |
| 3711 | +VALUES (5, 'from', 'sql shell');' |
3710 | 3712 | [10:12:40] [INFO] done |
3711 | 3713 | sql> SELECT COUNT(name) FROM users |
3712 | 3714 | [10:12:51] [INFO] fetching SQL SELECT statement query output: 'SELECT COUNT(name) FROM users' |
3713 | 3715 | [10:12:51] [INPUT] can the SQL query provided return multiple entries? [Y/n] n |
3714 | | -[10:12:53] [INFO] query: SELECT COALESCE(CAST(COUNT(name) AS CHARACTER(10000)), CHR(32)) FROM users |
| 3716 | +[10:12:53] [INFO] query: SELECT COALESCE(CAST(COUNT(name) AS CHARACTER(10000)), CHR(32)) |
| 3717 | +FROM users |
3715 | 3718 | [10:12:53] [INFO] retrieved: 5 |
3716 | 3719 | [10:12:54] [INFO] performed 20 queries in 0 seconds |
3717 | 3720 | SELECT COUNT(name) FROM users: '5' |
3718 | 3721 | </verb></tscreen> |
3719 | 3722 |
|
3720 | 3723 | <p> |
3721 | | -TODO |
| 3724 | +As you can see from this last example, when the user provides a SQL |
| 3725 | +statement other than <tt>SELECT</tt>, sqlmap recognizes it, tests if the |
| 3726 | +web application supports stacked queries and in case it does, it executes |
| 3727 | +the provided SQL statement in a multiple statement. |
| 3728 | + |
| 3729 | +<p> |
| 3730 | +Beware that some web application technologies do not support stacked |
| 3731 | +queries on specific database management systems. For instance, PHP does not |
| 3732 | +support stacked queries when the back-end DBMS is MySQL, but it does |
| 3733 | +support when the back-end DBMS is PostgreSQL. |
3722 | 3734 |
|
3723 | 3735 |
|
3724 | 3736 | <sect1>File system access |
|
0 commit comments