Common Database-related operations

Common Database-related operations

Common Database Operations:

 

1. Import and export data

Method 1:

1. Export query results: select statement into outfile 'Save path + file'
2. Import query results: load data local infile 'Storage path + file name' into table indicates character set utf8;
3. Import query results: import the formatted file to the mysql table: mysqlimport [Options]Db_name Textfile1[Textfile2...] See: https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
4. Import query results: source command: source 'file path + filename 'see: https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html

Method 2:

Export query results:
1. mysqldump command: mysqldump [options]> dump. SQL see: https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html