masalachol
Technical User
Hello:
I am new to MYSQL and my knowlege base is from reading online documentatation. I found that the quickest and most convinient manner to load data to existing tables is using the
load data infile <filename>
into table <table_name>
fields terminated by ' '
lines terminated by ' '
My questions is the following... How safe is it to use the syntax above? Where can I find the load log to see if there were any errors?
Also what are some other suggestions on how to load data to MYSQL?
In addition, I have some fields in the import file that are nulls. Is there syntax that allows me to tell MYSQL if there is a null value prior to loading fill in the field space with a "NOVALUE" string?
Looking forward to your replies.
I am new to MYSQL and my knowlege base is from reading online documentatation. I found that the quickest and most convinient manner to load data to existing tables is using the
load data infile <filename>
into table <table_name>
fields terminated by ' '
lines terminated by ' '
My questions is the following... How safe is it to use the syntax above? Where can I find the load log to see if there were any errors?
Also what are some other suggestions on how to load data to MYSQL?
In addition, I have some fields in the import file that are nulls. Is there syntax that allows me to tell MYSQL if there is a null value prior to loading fill in the field space with a "NOVALUE" string?
Looking forward to your replies.