Page 19 of 19

Re: Think Very Carefully About What the SQL Commands are Doing

PostPosted: Wed Aug 16, 2017 8:31 am
by hdwnygkz

Re: Think Very Carefully About What the SQL Commands are Doing

PostPosted: Wed Aug 16, 2017 1:18 pm
by mona101

Re: Think Very Carefully About What the SQL Commands are Doing

PostPosted: Tue Oct 10, 2017 4:00 pm
by allmight
--oops wrong thread--

Re: Think Very Carefully About What the SQL Commands are Doing

PostPosted: Fri Jan 05, 2018 6:04 pm
by BLKglass
So apparently the order of the columns matters for viewing purposes :oops:

Re: Think Very Carefully About What the SQL Commands are Doing

PostPosted: Mon Feb 12, 2018 3:38 am
by why tspace
I guessed the name of a column in a table, and just kept adding more columns to select from until I got the list of emails (to match the number of columns from the other table when loading the products).

One thing that troubled me was that UNION produced a bunch of blank fields, but UNION ALL gave me the correct emails. UNION should give me distinct rows, and UNION ALL includes all rows. I have no idea how my result set from using UNION without ALL would have failed giving me back the emails.

Re: Think Very Carefully About What the SQL Commands are Doing

PostPosted: Sat Jun 22, 2019 6:55 am
by ZanmatoOverdrive
So, I was able to get the address by guessing a specific column, is there a way to retrieve all columns?

Re: Think Very Carefully About What the SQL Commands are Doing

PostPosted: Tue Jul 09, 2019 7:11 am
by xyz3lt
I'd like to note that 'UNION ALL' and 'SELECT ALL' are 2 very different things
Also i need this as my second post

Re: Think Very Carefully About What the SQL Commands are Doing

PostPosted: Fri Jul 12, 2019 11:22 am
by brunogiordannof
Really nice misson! If u are stuck just try more. I tryed for 4 days. Study more about SQLi and UNION ALL operator. I'm sure it will be worthy.