linux:mysql_command
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
linux:mysql_command [2021/01/01 21:25] 127.0.0.1 external edit |
linux:mysql_command [2022/04/22 17:19] (current) manu |
||
|---|---|---|---|
| Line 49: | Line 49: | ||
| Database changed | Database changed | ||
| MariaDB [mysql]> | MariaDB [mysql]> | ||
| + | </cli> | ||
| + | |||
| + | List the creation commands for a table: | ||
| + | <cli prompt='>'> | ||
| + | MariaDB [mysql]> show create table <table>; | ||
| </cli> | </cli> | ||
| Line 98: | 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> | ||
| Line 238: | Line 257: | ||
| mysql> DROP TABLE tutorials_tbl | mysql> DROP TABLE tutorials_tbl | ||
| Query OK, 0 rows affected (0.8 sec) | Query OK, 0 rows affected (0.8 sec) | ||
| + | </cli> | ||
| + | |||
| + | ===== query content of tables ===== | ||
| + | |||
| + | Export to a file | ||
| + | <cli prompt='$'> | ||
| + | [user@lnx01 ~]$ mysql -user -pass -e "select cols from table where cols not null" > /tmp/output | ||
| </cli> | </cli> | ||
linux/mysql_command.1609532708.txt.gz · Last modified: 2021/01/01 21:25 by 127.0.0.1
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
