Re: Why isn't this working?

[John Frank]

Peter Brawley Wrote:
-------------------------------------------------------
> My mistake, I misread the code.
>
> "Timestamp" is a `Lighting Schedule` column? Or
> are you trying to set `Lighting`.`Last Updated` to
> the current time? In that case you need
> Current_Timestamp or Now().
>
> And btw, spaces and other illegal chars in MySQL
> database identifier names are error opportunities;
> don't use them. Likewise Hungarian notation style
> capitalisation of MySQL identifier names... it
> opens yet more error opportunities.

I'm trying to put the current time into `Lighting`.`Last Updated`

so how would I syntax the trigger?

also, I am pretty early on in the project. Thanks for the advice, switching that around won't take a lot of time