Re: Column default-metadata storage in MySQL 8
Posted by: Frederic Descamps
Date: December 21, 2018 02:35AM

Hi Martijn,

I don't find it very complicated, but sometimes it might be nice to see how expressions will be returned.

Would you like to have the possibility to see something like this?

MySQL   localhost:33060+  Py  mydba.getDefaults('test','default_test')
+--------------------------------+-----------------+----------------------------------------------------+----------------------|
| ColumnName | Type | Default | Example |
+--------------------------------+-----------------+----------------------------------------------------+----------------------|
| bi_col_exp | bigint | (8 * 8) | 64 |
| d_col | date | curdate() | 2018-12-21 |
| d_col_exp | date | (curdate() + 8) | 20181229 |
| dt_col | datetime | CURRENT_TIMESTAMP | 2018-12-21 09:31:44 |
| enum_col | enum | value1 | value1 |
| int_col | int | 44 | 44 |
| t_col | time | curtime() | 09:31:44 |
| vc_col | varchar | test | test |
| vc_col_exp | varchar | concat(_utf8mb4\'test\',_utf8mb4\'test\') | testtest |
+--------------------------------+-----------------+----------------------------------------------------+----------------------|
Total: 9

Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Column default-metadata storage in MySQL 8
40
December 21, 2018 02:35AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.