table_name
: the table that will receive data from the file.file_path
: a link to the file location in the server.Header_Syntax
: the specified header options.id,quantity 1,5 2,2 3,1 4,8 5,4 6,3Then, you create a table by specifying the column with an integer data type:
1,5 2,2 3,1 4,8 5,4 6,3
id,qty 1,5 2,2 3,1 4,8 5,4 6,3Then, you will get a mismatched output because it reads “qty” from the CSV file when the expected value is “quantity” as specified in the table.