Python Unnk Nocking Undpated Conpent [закрыто] ⇐ MySql

[Anonymous]

Я только начал изучать Python в течение 3 дней, чтобы написать инструмент, который вводит в базу данных MySQL, но после некоторых успешных тестов я попал в проблему с неожиданным отступлением, после нескольких поисков Google и Chatgpt, они все говорят, что я должен был получить вкладку или расстояние.

Код: Выделить всё

import mysql.connector
import pandas as pd

mydb = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="db"
)

mycursor = mydb.cursor()

df = pd.read_csv("ChromisPOS2.csv")
count_row_from_csv = len(df)
#code = df.at[2,"code"]

print(count_row_from_csv)

#print(code)

for x in range(1,count_row_from_csv):
name = df.at[x, "id"]
sql = "INSERT INTO demojava.products (id, reference, code, name, category, taxcat) VALUES (%s, %s, %s, %s, %s, %s)"
val = (name, name,x,name,"ad74edb0-9abf-4c50-aac4-31d670273b11","14c574f9-148f-49c0-911e-4d7a56760cfe")
mycursor.execute(sql, val)
mydb.commit()

< /code>
Я пробовал 4 пробела и 8 пробелов, но ошибка все еще происходит < /p>
Python 3.13.2 (tags/v3.13.2:4f8bb39, Feb  4 2025, 15:23:48) [MSC v.1942 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import mysql.connector
>>> import pandas as pd
>>> mydb = mysql.connector.connect(
...   host="localhost",
...     user="root",
...       password="nam123456",
...         database="demojava"
...         )
>>>
>>> mycursor = mydb.cursor()
>>> df = pd.read_csv("ChromisPOS2.csv")
>>> count_row_from_csv = len(df)
>>> #code = df.at[2,"code"]
>>>
>>> print(count_row_from_csv)
3
>>> #print(code)
>>>
>>> for x in range(1,count_row_from_csv):
...           name = df.at[x, "id"]
...                   sql = "INSERT INTO demojava.products (id, reference, code, name, category, taxcat) VALUES (%s, %s, %s, %s, %s, %s)"
...                           val = (name, name,x,name,"ad74edb0-9abf-4c50-aac4-31d670273b11","14c574f9-148f-49c0-911e-4d7a56760cfe")
...                                   mycursor.execute(sql, val)
...                                           mydb.commit()
...
File "
", line 3
sql = "INSERT INTO demojava.products (id, reference, code, name, category, taxcat) VALUES (%s, %s, %s, %s, %s, %s)"
IndentationError: unexpected indent
>>> import mysql.connector
>>> import pandas as pd
>>> mydb = mysql.connector.connect(
...   host="localhost",
...     user="root",
...       password="nam123456",
...         database="demojava"
...         )
>>>
>>> mycursor = mydb.cursor()
>>> df = pd.read_csv("ChromisPOS2.csv")
>>> count_row_from_csv = len(df)
>>> #code = df.at[2,"code"]
>>>
>>> print(count_row_from_csv)
3
>>> #print(code)
>>>
>>> for x in range(1,count_row_from_csv):
...       name = df.at[x, "id"]
...           sql = "INSERT INTO demojava.products (id, reference, code, name, category, taxcat) VALUES (%s, %s, %s, %s, %s, %s)"
...               val = (name, name,x,name,"ad74edb0-9abf-4c50-aac4-31d670273b11","14c574f9-148f-49c0-911e-4d7a56760cfe")
...                   mycursor.execute(sql, val)
...                       mydb.commit()
...
File "", line 3
sql = "INSERT INTO demojava.products (id, reference, code, name, category, taxcat) VALUES (%s, %s, %s, %s, %s, %s)"
IndentationError: unexpected indent
>>> import mysql.connector
>>> import pandas as pd
>>> mydb = mysql.connector.connect(
...   host="localhost",
...     user="root",
...       password="nam123456",
...         database="demojava"
...          )
>>>
>>> mycursor = mydb.cursor()
>>> df = pd.read_csv("ChromisPOS2.csv")
>>> count_row_from_csv = len(df)
>>> #code = df.at[2,"code"]
>>>
>>> print(count_row_from_csv)
3
>>> #print(code)
>>>
>>> for x in range(1,count_row_from_csv):
>>> import mysql.connector
>>> import pandas as pd
>>> mydb = mysql.connector.connect(
...   host="localhost",
...     user="root",
...       password="nam123456",
...         database="demojava"
...         )
>>>
>>> mycursor = mydb.cursor()
>>> df = pd.read_csv("ChromisPOS2.csv")
>>> count_row_from_csv = len(df)
>>> #code = df.at[2,"code"]
>>>
>>> print(count_row_from_csv)
3
>>> #print(code)
>>>
>>> for x in range(1,count_row_from_csv):
...       name = df.at[x, "id"]
...           sql = "INSERT INTO demojava.products (id, reference, code, name, category, taxcat) VALUES (%s, %s, %s, %s, %s, %s)"
...               val = (name, name,x,name,"ad74edb0-9abf-4c50-aac4-31d670273b11","14c574f9-148f-49c0-911e-4d7a56760cfe")
...                   mycursor.execute(sql, val)
...                       mydb.commit()
...
File "", line 3
sql = "INSERT INTO demojava.products (id, reference, code, name, category, taxcat) VALUES (%s, %s, %s, %s, %s, %s)"
IndentationError: unexpected indent
>>>

Вот ошибка, ребята


Подробнее здесь: https://stackoverflow.com/questions/794 ... ted-indent