ubuntu中操作mysql数据库文件

sudo apt update
sudo apt install mysql-server

mysql -u root -p

CREATE DATABASE <database_name>;

USE <database_name>;

SHOW DATABASES;

DROP DATABASE <database_name>;

CREATE TABLE <table_name> (
    <column1> <data_type>,
    <column2> <data_type>,
    ...
);

DESCRIBE <table_name>;

ALTER TABLE <table_name> ADD <column_name> <data_type>;
ALTER TABLE <table_name> MODIFY <column_name> <new_data_type>;
ALTER TABLE <table_name> DROP COLUMN <column_name>;

DROP TABLE <table_name>;

INSERT INTO <table_name> (<column1>, <column2>, ...) VALUES (<value1>, <value2>, ...);

UPDATE <table_name> SET <column_name>=<new_value> WHERE <condition>;

DELETE FROM <table_name> WHERE <condition>;

mysql -u <username> -p <database_name> < <file_path.sql>

mysqldump -u <username> -p <database_name> > <file_path.sql>