๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

๊ฐ•ํ™”๋„๋ผ์ดํ”„/๋ธ”๋กœ๊ทธ & ์›น ์‚ฌ์ดํŠธ

[Python Error ์ •๋ฆฌ] pymysql.err.DataError: (1366, "Incorrect integer value: 'id' for column 'id' at row 1")

ํŒŒ์ด์ฌ ๋…ํ•™ ์ถ”์ฒœ ๋„์„œ

ํ˜ผ์ž ๊ณต๋ถ€ํ•˜๋Š” ํŒŒ์ด์ฌ:1:1 ๊ณผ์™ธํ•˜๋“ฏ ๋ฐฐ์šฐ๋Š” ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์ž์Šต์„œ, ํ•œ๋น›๋ฏธ๋””์–ด Do it! ์ ํ”„ ํˆฌ ํŒŒ์ด์ฌ:์ด๋ฏธ 200๋งŒ๋ช…์ด ์ด ์ฑ…์œผ๋กœ ํ”„๋กœ๊ทธ๋ž˜๋ฐ์„ ์‹œ์ž‘ํ–ˆ๋‹ค!, ์ด์ง€์Šคํผ๋ธ”๋ฆฌ์‹ฑ ๋งŒ๋“ค๋ฉด์„œ ๋ฐฐ์šฐ๋Š” ํŒŒ์ด์ฌ๊ณผ 40๊ฐœ์˜ ์ž‘ํ’ˆ๋“ค:์ž๋™ํ™” ํฌ๋กค๋ง ์ด๋ฏธ์ง€์ฒ˜๋ฆฌ ๋ฐ์ดํ„ฐ๋ถ„์„ ์›นํŽ˜์ด์ง€ GUI ํ”„๋กœ๊ทธ๋žจ ๊ฒŒ์ž„, ์•ค์จ๋ถ

 

Python Error ์ •๋ฆฌ

 

pymysql.err.DataError: (1366, "Incorrect integer value: 'id' for column 'id' at row 1")

 

id ์ž๋ฆฌ๊ฐ€ ์ž˜๋ชป๋œ ์ •์ˆ˜ ๊ฐ’์ด๋ž˜ "id" -> 1๋กœ ๋ฐ”๊ฟ”์คŒ

๋ฐ˜์‘ํ˜•