Re: Calls to SQl from Foxpro

[Badita Alexandru Stefan]

But can I make in MySql something like this:

Set @aaa = 1;
Set @DynamicColumnName = Concat('Day',1);

Insert Into MyTable (@DynamicColumnName) Values (@aaa)

It is giving me an error

Basically all I want to be able to do is to make a dynamic column headder that I know it corresponds to one of my columns and update that column with some value. Can this be done in MySql ?