MySQL(maria DB) Trouble Shorting





  •  
  • sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column ' * ' in 'field list'")
    • Unknow column in field list ERROR
    • Case 1 (์ด์œ 1) :  If the table does not exist in column (column์— ํ…Œ์ด๋ธ”์ด ์กด์žฌํ•˜์ง€ ์•Š๋Š” ๊ฒฝ์šฐ)
    • Case 2 (์ด์œ 2) :  When the data given by the user as a string is not surrounded by " or ' (quotation) (์‚ฌ์šฉ์ž๊ฐ€ ๋ฌธ์ž์—ด๋กœ ์ค€ ๋ฐ์ดํ„ฐ๊ฐ€ " or ' (quotation)์œผ๋กœ ๋‘˜๋Ÿฌ์‹ธ์—ฌ ์žˆ์ง€ ์•Š์€ ๊ฒฝ์šฐ)
  • sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1292, "Incorrect date value: '' for column
    • mysql์˜ 'date' type์€ ''(๋น„์–ด์žˆ๋Š” val์„ ๊ฐ–์ง€ ๋ชปํ•œ๋‹ค.)

0 ๋Œ“๊ธ€