I've been given a connection to a MySQL database on a Linux server - the version appears to be 5.1.52. I'm able to run "select" statements with no problem. I think everything has to be in lower case. I'm trying to create variables and getting an error: "Fatal error encountered during command execution." Each of the following statements, for example, will yield the error:
Where are you running this from? Are you using the command line program mysql or some other application?
I'm using "some other application" - Logi Info. I know my access rights to the database are limited to read-only. I just tried creating a temp table and it told me I didn't have rights - so I wonder if I don't have rights to create variables, since I'm using common examples which should ordinarily work. I wonder if defining variables is something you have to be granted special rights to do.
I can work around the problem by copying the entire MySQL table into an MS SQL database, where I'm allowed to define variables.