MySQL - How auto-complete datetime field value in MySQL Workbench?

1 answers

3 points

Asked by:

518

How can I set DATETIME type row value autocomplete?

I need default value to be automatically added when the row is created.

I'm working with MySQL Workbench.

1 answer

3 points

Answered by:

518

Set Default/Expression value to:

CURRENT_TIMESTAMP()

Practical example

Open settings of the table you want to alter. Then add CURRENT_TIMESTAMP() to the Default/Expression of the DATETIME data type row.

0 comments Add comment

Donate to Dirask

Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!

Direct link

Join to our subscribers to be up to date with content, news and offers.

Get your tech brand or product in front of software developers.

For more information Contact us

Join