MySQLÊý¾Ýµ¼Èëµ¼³öcsvÎļþÃüÁî
MySqlÊý¾Ý¿âµ¼³öcsvÎļþÃüÁ
mysql> select first_name,last_name,email from account into outfile 'e:\\output1.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';
csvÎļþЧ¹û£º
sunny
Grigoryan
lovechoosesun@gmail.com
Jon
Siegal
sun@riliantech.net
Joe
Siegal
zhao@gmail.com
alejandro
medina
wei@gmail.com
cvsÎļþµ¼ÈëMySqlÊý¾Ý¿âÃüÁî:
mysql> load data local infile 'e:\\input1.csv' into table test1 fields termin
ated by ','lines terminated by '\n'(first_name,last_name,email);
Query OK, 1 row affected, 1 warning (0.00 sec)
Records: 69 Deleted: 0 Skipped: 68 Warnings: 0
mysql> select * from test1;
+----+------------+-----------+--------------------------+
| id | first_name | last_name | email |
+----+------------+-----------+--------------------------+
| 0 | sunny | Grigoryan | lovechoosesun@gmail.com
+----+------------+-----------+--------------------------+
FIELDS TERMINATED BY ---- ×Ö¶ÎÖÕÖ¹×Ö·û
OPTIONALLY ENCLOSED BY ---- ·âÌ×·û
LINES TERMINATED BY ---- ÐÐÖÕÖ¹·û
Ïà¹ØÎĵµ£º
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
ÆäʵÈç¹ûÄã·þÎñÆ÷ÖØÐ°²×°ÁË,Ò²²»±ØÖØÐ°²×°mysql ¼¸¸öСÃüÁî¾Í¸ã¶¨ÁË
Ê×ÏÈÊǰ²×°mysql·þÎñ:
mysql-nt –install
net start mysql
µ±È»Ó´ÔÚbinĿ¼ÔËÐÐÕâ¸öÃüÁîÁË
Ð¶ÔØµÄÃüÁîÊÇ:
net stop "MySQL"
mysqld-nt.exe –remove "MySQL"
ΪʲôÓеÄÅóÓÑÐ¶ÔØ²»ÁËÄØ,ÒòΪËûÒѾ°ÑÔ´Îļþ¶¼É¾³ýÁË »òÕßÔËÐÐÐ ......
***function(/*³£Óú¯Êý*/)***
----ͳ¼Æº¯Êý----
AVG --Ç󯽾ùÖµ
COUNT --ͳ¼ÆÊýÄ¿
MAX --Çó×î´óÖµ
MIN --Çó×îСֵ
SUM --ÇóºÍ
--AVG
use pangu
select avg(e_wage) as dept_avgWage
from employee
group by dept_id
--M ......