Some command used in my BTP

commands.txt

Importing a file into my local phpmyadmin

sumanth@harekrsna:~$ mysql --local-infile -h localhost -u root -p project
Enter password: asd

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 262
Server version: 5.5.40-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> load data local infile '/home/sumanth/btp/Algeria/friends2.txt' into table FriendsAlgeria fields terminated by ',' enclosed by '"'  lines terminated by '\n';