MYSQL command from Alpine containner

Twenty Four O Clock

·

Follow

Nov 3, 2020

--

Listen

Share

### mysql connect
bash-4.4# mysql -h foxgw-test-b.asiaplus.co.th -P 3306 -u itefox -D NTFEX -p
Enter password: <enter password>
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 1269
Server version: 5.6.43 Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
### List All Database
show databases;
### Switch database
use dbname;
### List All table in current database
show tables;
### Show Field in table
describe tablename;
### show current datetime or date
MySQL [NTFEX]> select NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2020-11-03 16:38:19 |
+---------------------+
1 row in set (0.020 sec)MySQL [NTFEX]> select CURDATE();
+------------+
| CURDATE()  |
+------------+
| 2020-11-03 |
+------------+
1 row in set (0.008 sec)
### exit command
\q