Re: From Oracle to MySql

[Anders Karlsson]

This is not a feature of the Oracle database in and of itself, but rather a feature of the Oracle Client program SQL*Plus. In MySQL, the interactive mysql client doesn't have this feature, but the MySQL Server DOES. The syntax is a bit different from SQL*Plus though.
The variable is set using the SET Command. Also, MySQL variables are treated as "real" variables in the SQL statement, whereas in Oracle, there is just plain text-substitution going on. This means that the quotes for strings should not be used, for example. MySQL variables are prefixed with a @. For your example, this is what it could look like in MySQL:
SET @X='foo';
SELECT * FROM TABLE1 WHERE TABLE_COLUMN = @X;

Hope this helps
/Karlsson