Notes for learning MySQL

MySQL is installed in two parts: client and server. After the MySQL server and client are installed, the database tables and the table structures in the database are imported and exported, some SQL commands used now:

> MySQL-u busiusr-p enters the MySQL database

> Set names gbk;

MySQLdump-uroot newdrmdb tacts> tacts. SQL exports the table tacts data in the newdrmdb database;

Source absolute path/*. SQL imports data into the table;

MySQL-uroot-pheli098 <... (absolute path); execute the database script in linux;

Select * from tmonthfees limit 1000 into outfile '/*. csv 'fields terminated by', '; export 1000 records from the tmonthfees table to the file;
Load data local infile ''into table table_name fields terminated by ','; import the data in the file to the table;

Delete from tmonthfees;
Delete from tusers;
Delete from tusersongs;
Delete from tsubscribers;

Load data local infile 'C:/SQL/tmonthfees.13942529339.txt 'into table tmonthfees fields terminated ',';
Load data local infile 'C:/SQL/tusers.13942529339.txt 'into table tusers fields terminated ',';
Load data local infile 'C:/SQL/tusersongs.13942529339.txt 'into table tusersongs fields terminated ',';
Load data local infile 'C:/SQL/tsubscribers.13942529339.txt 'into table tsubscribers fields terminated ',';

Import data from text files to tables in the database;