1 2
| LOAD DATA LOCAL INFILE 'C:\\Users\\alaeddine\\Desktop\\TT (2).csv'
INTO TABLE incident FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\\r\\n' (ID_Incident, Status, Vendor, Priority, Criticality_Tt, Title, Description, Affected_CI, Affected_Service, Assignee, Assignment_Group, Reassignment_Count, Open_Time, Close_Time, Outage_Start, Reassignment_Time, Outage_End, Impact, Solution, Assignment_Manager_Name,Assign_Deptmgr, Opened_By, Closed_By, Closure_Code, Update_Action, Last_Updated_By) |
Partager