× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2015-05-12T15:34:09Z  · last modified 2015-08-17T19:54:23Z

MySQL: add now() to mysql default


customer request
Priority Low
Complexity Unknown
Component App - Visual Editing
Version 17.0

MySQL

if the datatype is date, time, timestamp, datetime and the default value is one of [current_date, current_time, current_timestamp, current_curtime, current_sysdate, current_unix_timestamp, current_row] it does not put a quote. 

Can we add now() to the list as well ? Currently if we try to alter the table and add now() ADS adds a quote around 'now()' which on execution gives incorrect syntax

3 attachments

Issue #13317

Closed
Fixed
Resolved 2015-08-08T22:36:04Z
 
 
Completion
No due date
Fixed Build v17.0.0-alpha-9
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017