Data Extraction Using a union query [DB: MySQL, Level: Basic]

This lab illustrates the use case of an order by clause to identify the number of columns present in the current table and, also elucidate the process of extracting the data using a union query.

Lab: Identify the number of columns using the “order by” clause and extract database information using a union query.

Database: MySQL

Technique Used: Union and Order by query

Limitations: SQL Injection characters blacklist is in place

Video Demonstration

Download full PDF Challenge

Back to challenges