• To display information and usage instructions related to export command
    • sqoop help export
  • Command to connect to my sql
    • mysql -u retail_user -h ms.itversity.com -p
  • Command to get list of databases
    • show databases;
  • Command to connect to a database
    • USE retail_export;
  • Command to create a table
    • CREATE TABLE testing(i INT);
  • Command to drop a table
    • drop table testing;
  • Select query on a table
    • SELECT * FROM testing;

Share this post