Linux Query Command

connect

mysql -u <id> -p  enter

password enter

MariaDB [(none)]>

connect!







change DB(from null)




MariaDB [(none)]>USE <DB_name>;

Database changed

MariaDB [DB_name]>

connect > use DB_name!

MariaDB [DB_name]>show tables;

+-----------------------+

| Tables_in_DB_name |

+-----------------------+

| tableName....              |
....

MariaDB [DB_name]>describe tableName;

+-------------------+---------------+------+-----+---------------------+----------------+

| Field             | Type          | Null | Key | Default             | Extra          |

+-------------------+---------------+------+-----+---------------------+----------------+

| id                | int(11)       | NO   | PRI | NULL                | auto_increment |

| type              | varchar(50)   | NO   |     | NULL                |                |

....