csv_data = csv.reader(open('Emp.csv')) for row in csv_data: mycursor.execute("INSERT INTO emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
Code import .CSV file to MySQL table
Code import .CSV file to MySQL table
|
|
Messages In This Thread |
Code import .CSV file to MySQL table - by rtakle - Apr-30-2020, 02:36 PM
RE: Code import .CSV file to MySQL table - by deanhystad - Apr-30-2020, 02:48 PM
RE: Code import .CSV file to MySQL table - by anbu23 - Apr-30-2020, 02:56 PM
RE: Code import .CSV file to MySQL table - by rtakle - Apr-30-2020, 02:58 PM
RE: Code import .CSV file to MySQL table - by anbu23 - Apr-30-2020, 03:16 PM
|
Users browsing this thread: 1 Guest(s)