The following are a few commands I've been using in the past few days, I'll write them down first, and then I'll put together a detailed documentation of mysql usage.
Note: The [] in [] represents the name, which needs to be replaced by the library name or table name.
Show all libraries:
show databases;
Access to a library.
use [dbname];
Show all tables.
show tables;
Show field configurations for a table.
describe [tbname];
maybe
show full fields from [tbname];
Creating libraries.
create database [dbname];
Delete table.
drop database [dbname];
Delete table.
drop table [tbname];
Import Creation Scripts.
mysql -u[user] -p [dbname] < []
(-p is not needed if there is no password)
Displays the status of each table, such as the amount of data stored.
show table status \G;
That's it.