Python? ???? Excel ??? SQL ??????? ???? ??? ??????.

????? ?? ??? ?? Excel ???? CSV ??? ?????.

1. ?? ??? ???.
2. ?? >? ?????. ?? ???? ?????.
3. ?? ??? CSV(??? ??)(*.csv)? ???? ??? ?????.

? ??? ??? ??? Excel ???? SQL ??????? ???? ???? ???? ??? ? ????.

FIRST_NAME LAST_NAME ??? USER_ID USER_LOGIN_NAME
??01 ?01 ??01 ID001 ?????01
??02 ?02 ??02 ID002 ?????02
??03 ?03 ??03 ID003 ?????03
??04 ?04 ??04 ID004 ?????04
??05 ?05 ??05 ID005 ?????05
??06 ?06 ??06 ID006 ?????06
??07 ?07 ??07 ID007 ?????07
??08 ?08 ??08 ID008 ??? ??08

????? ??? ???? CSV ??? SQL ???? ?????. ?? ?? Python ????? ???? CSV ??? ?? ???? SQL ?? ?? ??? ? ????. ??? ?? ????? ???? ? ??? ?? ?? Python ???????.

import pandas as pd

# Read the CSV file into a DataFrame
df = pd.read_csv('D:/temp/test/TestExcel.csv') # Add the path to your CSV file

# Generate SQL insert statements
table_name = 'Test_Table_Name' # Replace with your desired table name
sql_statements = []

for index, row in df.iterrows():
    columns = ', '.join(row.index)
    values = ', '.join([f"'{str(value)}'" for value in row.values])
    sql_statements.append(f"INSERT INTO {table_name} ({columns}) VALUES ({values});")

# Save to a file
with open('D:/temp/test/insert_statements.sql', 'w') as f:
    for statement in sql_statements:
        f.write(statement + '\n')

??? ? ??? ??? ????? ?????.

INSERT INTO Test_Table_Name(FIRST_NAME, LAST_NAME, EMAIL, USER_ID, USER_LOGIN_NAME) VALUES('First01', 'Last01', 'firstlastname01', 'ID001', 'loginname01');
INSERT INTO Test_Table_Name (FIRST_NAME, LAST_NAME, EMAIL, USER_ID, USER_LOGIN_NAME) VALUES ('First02', 'Last02', 'firstlastname02', 'ID002', 'loginname02');
INSERT INTO Test_Table_Name (FIRST_NAME, LAST_NAME, EMAIL, USER_ID, USER_LOGIN_NAME) VALUES ('First03', 'Last03', 'firstlastname03', 'ID003', 'loginname03');
INSERT INTO Test_Table_Name (FIRST_NAME, LAST_NAME, EMAIL, USER_ID, USER_LOGIN_NAME) VALUES ('First04', 'Last04', 'firstlastname04', 'ID004', 'loginname04');
INSERT INTO Test_Table_Name (FIRST_NAME, LAST_NAME, EMAIL, USER_ID, USER_LOGIN_NAME) VALUES ('First05', 'Last05', 'firstlastname05', 'ID005', 'loginname05');
INSERT INTO Test_Table_Name (FIRST_NAME, LAST_NAME, EMAIL, USER_ID, USER_LOGIN_NAME) VALUES ('First06', 'Last06', 'firstlastname06', 'ID006', 'loginname06');
INSERT INTO Test_Table_Name (FIRST_NAME, LAST_NAME, EMAIL, USER_ID, USER_LOGIN_NAME) VALUES ('First07', 'Last07', 'firstlastname07', 'ID007', 'loginname07');
INSERT INTO Test_Table_Name (FIRST_NAME, LAST_NAME, EMAIL, USER_ID, USER_LOGIN_NAME) VALUES ('First08', 'Last08', 'firstlastname08', 'ID008', 'loginname08');

CSV ??? SQL ?? ??? ???? ? ??? ? ?? ??? ??? ??? ?? ?????. ??? ???? ???? ??? ??? ??? ??? ?? ??? ???? ?? ?????. ??? ?? ??? ???? ??? ?? ????? ?? ??? ??? ? ????.

? ??? Excel ??? ??? SQL ?? ??? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!