Shane's planet

Data too long for column 1

MYSQL)Data too long for column 에러 해결

Intro [http-nio-80-exec-6] ERROR j.sqlonly - 1. PreparedStatement.execute() UPDATE LIC_ALBA SET LIC_IMG = '' WHERE AL_ID = 'A0000016' AND LIC_CODE = 'L006' com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'lic_img' at row 1 MYSQL에서 데이터를 넣으려 할때 위의 에러가 뜬다면 해당 컬럼에 들어갈 수 있는 최대 값보다 넣으려고 하는 데이터가 더 큰 상황입니다. 숫자나 CHAR, VARCHAR2 등을..

Data/MYSQL ⁄ MariaDB 2021.04.22
<
1
>
더보기
  • ALL (518)
    • Programming (159)
      • Java (48)
      • javascrlpt (20)
      • JPA ⁄ Spring (67)
      • Kotlin (11)
      • Python (13)
    • Data (44)
      • LLM (3)
      • MongoDB (3)
      • MYSQL ⁄ MariaDB (9)
      • Oracle (6)
      • PostgreSQL (8)
      • Search Engine (13)
    • Development (193)
      • Cloud (8)
      • Daily Error (49)
      • Develop Tools (36)
      • DevLife (15)
      • DevOps (33)
      • Fundamentals (5)
      • Git (16)
      • HTML ⁄ CSS (9)
      • Problem Solving (8)
      • Projects-DDIT (14)
    • IT ⁄ Computer (122)
      • Linux (56)
      • Mac (49)
      • News (6)
      • Review (2)
      • Windows (9)

Visitors

Total

Yesterday

Today

반응형

티스토리툴바