linux:mysql_command
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
linux:mysql_command [2022/04/07 16:50] manu |
linux:mysql_command [2022/04/22 17:19] (current) manu |
||
|---|---|---|---|
| Line 103: | Line 103: | ||
| +------------------------+-----------------------------------+------+-----+---------+-------+ | +------------------------+-----------------------------------+------+-----+---------+-------+ | ||
| 44 rows in set (0.00 sec) | 44 rows in set (0.00 sec) | ||
| + | </cli> | ||
| + | |||
| + | <cli prompt='>'> | ||
| + | MariaDB [information_schema]> select TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLLATION_NAME from COLUMNS where TABLE_SCHEMA = 'storage' order by TABLE_NAME; | ||
| + | +--------------+------------------+----------------+-------------+-----------+--------------------------+-------------------+ | ||
| + | | TABLE_NAME | COLUMN_NAME | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | COLLATION_NAME | | ||
| + | +--------------+------------------+----------------+-------------+-----------+--------------------------+-------------------+ | ||
| + | | svc_copy | date | NULL | NO | date | NULL | NULL | | ||
| + | | svc_copy | vdisk_id | NULL | NO | int | NULL | NULL | | ||
| + | | svc_copy | vdisk_name | NULL | YES | varchar | 48 | latin1_general_ci | | ||
| + | | svc_copy | copy_id | NULL | NO | tinyint | NULL | NULL | | ||
| + | | svc_copy | status | NULL | NO | varchar | 16 | latin1_general_ci | | ||
| + | | svc_copy | sync | NULL | NO | enum | 3 | latin1_general_ci | | ||
| + | |||
| </cli> | </cli> | ||
linux/mysql_command.1649343047.txt.gz ยท Last modified: 2022/04/07 16:50 by manu
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
