Think Very Carefully About What the SQL Commands are Doing

[sysgen]

Hello;
I have completed this mission but I am posting in there to be able to message SaveTheWhales.

-- Tue Mar 03, 2015 9:42 am --

Hello;
I have completed this mission but I am posting in there to be able to message SaveTheWhales.

as a said. Feel free to remove these posts, if you can.

[cyberdrain]

Use this system instead.

[Zanna1x9x]

Finally i've resolved this mission but only with some helps taken from this forum and a lucky moment, in fact I haven't understood some things.
I don't know how can i discover the number of columns in the 2 tables, could anyone sent me a PM with some reason?
Thanks at all.

[cyberdrain]

Finally i've resolved this mission but only with some helps taken from this forum and a lucky moment, in fact I haven't understood some things.
I don't know how can i discover the number of columns in the 2 tables, could anyone sent me a PM with some reason?
Thanks at all.

Sure, PM me with what you did and where you need help. You'll need two posts on the forum to do it.

[Zanna1x9x]

Sure, PM me with what you did and where you need help. You'll need two posts on the forum to do it.

Thank you

[NightArcher]

I really enjoyed this mission it is good to be able to practice all the stuff I am reading about. Certainly taught me the importance of checking syntax

One piece of advice is think about the format that the tables are presented in and what any data pulled through from another table will be formatted to look like.

[parado]

I don't understand why we cannot use the "add to list" field to complete this challenge. From what I have read, most people suggest using the URL instead.

I realize that the email field is an insertion, but we could just terminate it and chain our s*****t, right? In this case, we would not need to join any tables either, simply request all emails. However, my command is resulting in an error. I am not sure if my syntax/logic is wrong, or the page simply fakes SQL and is hard coded to react only to the URL solution.

This is the statement(s) I am trying in the add email field (possible spoilers, commands are abbreviated to minimize spoilers):
'; S * F em;
'); S * F em;
dummy@email.com'); S * F e;
dummy@email.com'; S * F em;
'; S * F em;'
'); S * F em;'
dummy@email.com'); S * FR e'''';'
dummy@email.com'; S''' * F''' em''';'

[norville05]

I have finished the mission, but need to unlock PM

[cyberdrain]

I have finished the mission, but need to unlock PM

No you don't. You should use the HTS message centre on the main page instead

[bangkockney]

This has been my favourite so far. Prompted me to do a good deal of reading and I've come away having actually learnt (and can remember!) something.

Have enjoyed the change of pace that this mission has introduced.