[大数据]使用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