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

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

[Python Error ์ •๋ฆฌ] pymysql.err.ProgrammingError: (1146, "Table 'test.customers' doesn't exist")

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

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

Python Error ์ •๋ฆฌ

pymysql.err.ProgrammingError: (1146, "Table 'test.customers' doesn't exist")

 

ํ…Œ์ด๋ธ” ์ด๋ฆ„์ด ์•ˆ๋งž๋Œœ ( customers -> data(๋‚ด๊บผ) )

์˜ˆ์ œ ์ฝ”๋“œ ๊ฐ€๋”ฐ ์“ฐ๋ฉด ์ €๋Ÿฐ๊ฑฐ ์ž˜ ์ฑ™๊ฒจ ๋ณด๋„๋ก

๋ฐ˜์‘ํ˜•

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