Think Very Carefully About What the SQL Commands are Doing

FAP is company that slaughters animals and turns their skin into overpriced products which are then sold to rich bastards! Help animal rights activists increase political awareness by hacking their mailing list.

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

Post by hdwnygkz on Wed Aug 16, 2017 8:31 am
([msg=94107]see Re: Think Very Carefully About What the SQL Commands are Doing[/msg])

hdwnygkz
New User
New User
 
Posts: 1
Joined: Wed Aug 16, 2017 8:26 am
Blog: View Blog (0)


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

Post by mona101 on Wed Aug 16, 2017 1:18 pm
([msg=94110]see Re: Think Very Carefully About What the SQL Commands are Doing[/msg])

mona101
New User
New User
 
Posts: 1
Joined: Wed Aug 16, 2017 12:37 pm
Blog: View Blog (0)


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

Post by allmight on Tue Oct 10, 2017 4:00 pm
([msg=94764]see Re: Think Very Carefully About What the SQL Commands are Doing[/msg])

--oops wrong thread--
allmight
New User
New User
 
Posts: 4
Joined: Tue Oct 10, 2017 3:56 pm
Blog: View Blog (0)


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

Post by BLKglass on Fri Jan 05, 2018 6:04 pm
([msg=95122]see Re: Think Very Carefully About What the SQL Commands are Doing[/msg])

So apparently the order of the columns matters for viewing purposes :oops:
BLKglass
New User
New User
 
Posts: 1
Joined: Wed May 28, 2014 12:15 pm
Blog: View Blog (0)


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

Post by why tspace on Mon Feb 12, 2018 3:38 am
([msg=95248]see Re: Think Very Carefully About What the SQL Commands are Doing[/msg])

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.
why tspace
New User
New User
 
Posts: 13
Joined: Sun Feb 11, 2018 10:31 pm
Blog: View Blog (0)


Previous

Return to (Real 4) Fischer's Animal Products

Who is online

Users browsing this forum: No registered users and 0 guests