使用sqoop将hdfs数据导出到mysql

--------------------export	导出---------------------------------
[root@mihaoyu151 tmp]# sqoop export 
> --connect jdbc:mysql://mihaoyu151:3306/mybatisdb 
> --username root 
> --password root 
> --table teacher 
> --export-dir /sqoop/exportdata/
-------------------------修改----------------------------
[root@mihaoyu151 tmp]# sqoop export 
> --connect jdbc:mysql://mihaoyu151:3306/mybatisdb 
> --username root 
> --password root 
> --table teacher 
> --export-dir /sqoop/exportdata2/ 
> --update-key id 
> --update-mode updateonly
------------------------修改，添加-----------------------------
[root@mihaoyu151 tmp]# sqoop export 
> --connect jdbc:mysql://mihaoyu151:3306/mybatisdb 
> --username root 
> --password root 
> --table teacher 
> --export-dir /sqoop/exportdata3/ 
> --update-key id 
> --update-mode allowinsert