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

์นดํ…Œ๊ณ ๋ฆฌ ์—†์Œ

[Python Error ์ •๋ฆฌ] pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index, info) VALUES ('class', '๋กœ๋˜ ๊ธฐ์‚ฌ ๋‚ด์šฉ')' at ..

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

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

[Python Error ์ •๋ฆฌ]

 

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index, info) VALUES ('class', '๋กœ๋˜ ๊ธฐ์‚ฌ ๋‚ด์šฉ')' at line 1")

 

์ด๊ฑด ๋ญ๊ฐ€ ๋ฌธ์  ์ง€ ๋ชจ๋ฅด๊ฒ ๋„ค..

 

์•„...

1

index๋ฅผ id๋กœ ๋ฐ”๊พธ๋‹ˆ๊นŒ 1064 ์ด๋ฒคํŠธ๋Š” ์‚ฌ๋ผ์กŒ๋‹ค.

 

๊ทผ๋ฐ

2

์ƒˆ๋กœ์šด ์ด๋ฒคํŠธ๊ฐ€...

์œผ์•„..

ํ”ผ๊ณคํ•˜๋‹ˆ ๋‡Œ๊ฐ€ ์•ˆ์›€์ง์˜€๋‚˜..

createํ–ˆ์„๋•Œ์˜ ํ‚ค ๊ฐ’์— ๋งž์ถฐ์„œ insert๋ฅผ ํ•ด์ค˜์•ผ์ง€ ๋ฐ”๋ณด์•ผ ์œผ์•„

๋˜ฅ๋ฉ์ฒญ์ด๋„ค

์ด๋ก ์„ ์—ฌ๋Ÿฌ๋ฒˆ ๋“ฃ๊ณ  ์‹ค์Šต์„ ๊ฒ๋‚˜ ํ•ด์•ผ ๊ฒ ๋‹ค.

๋น„์ „๊ณต์ด๋ผ๋Š” ํ•‘๊ณ„๋Š” ๋‚ด๋‹ค๋ฒ„๋ฆฌ๊ณ  ๋ฉ์ฒญํ•จ์„ ๋ฐ˜์„ฑํ•˜์ž.

3
4
5

 

๋ฐ˜์‘ํ˜•

"์ด ํฌ์ŠคํŒ…์€ ์ฟ ํŒก ํŒŒํŠธ๋„ˆ์Šค ํ™œ๋™์˜ ์ผํ™˜์œผ๋กœ, ์ด์— ๋”ฐ๋ฅธ ์ผ์ •์•ก์˜ ์ˆ˜์ˆ˜๋ฃŒ๋ฅผ ์ œ๊ณต๋ฐ›์Šต๋‹ˆ๋‹ค."