![]() In the second line you have to mention the database name and table, In My case testing is the database name and employee is the table name.Please replace it with the path of the file. After ‘ load data local infile‘ statement I have mentioned the path of the CSV file.(emp_id,first_name,last_name,email,gender,age,salary,designation,department,joining_date) Load data local infile 'C:\\Users\\Vishvajit Rao\\OneDrive\\Documents\\employee.csv' This is a statement that I will use to import CSV data into the table employee. ![]() I have a CSV file called employee.csv having some records which I want to import into the employee table.In my case, A table employee has been created. ![]() You can use the SHOW TABLES statement to check whether the table has been created or not.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |