How to store the result of a SELECT query in a local variable?

Question

SQL

Tried like this:

SELECT value FROM table WHERE id = :id INTO variable;

and so: But neither one nor the other works.
variable = (SELECT value FROM table WHERE id=:id);

Answer 1

for(unsigned i = 0; i < 200; ++i)
cout << "A variable name should always be preceded by a colon";
In some places the variable was used without a preceding colon, so this error was thrown.