Unable to create Mysql TRIGGER with BEFORE UPDATE and set CURRENT_TIMESTAMP [on hold]

I want to create Mysql TRIGGER by setting CURRENT_TIMESTAMP to a column which is going for updated currently. It w

CREATE TRIGGER before_booking_update BEFORE UPDATE ON booking FOR EACH ROW BEGIN SET NEW.lastchange = CURRENT_TIMESTAMP; END;

MySQL said:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5

Replay

Category: mysql Time: 2016-07-29 Views: 4
Tags: mysql

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.198 (s). 12 q(s)