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.

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.

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;