connect to mysql server via command line

[Duy Dinh]

mysql --host=localhost --port=3306 -u root -p

[Duy Dinh]

#to load data from file, connect to mysql with option --local-infile=1

mysql --local-infile=1 --host=127.0.0.1 --port=3306 -u root -p

load data local infile '/home/duy/programs/openemr-4.1.2/internationalization/openemr_language_table - Sheet1.csv'
into table lang_definitions
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
(cons_id, lang_id, definition)
SET def_id = NULL;

#if you have an auto incremental key, set the id to null;