Timeline for How do I correct this value too long for type character varying(5)?
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 29, 2016 at 3:25 | comment | added | mustaccio |
What @TypoCubeᵀᴹ said. You might want to make a habit of explicitly listing target columns in the insert statements: INSERT INTO table1 (column1,..) VALUES (...).
|
|
| Dec 29, 2016 at 3:20 | history | edited | Michael Green | CC BY-SA 3.0 |
deleted 4 characters in body
|
| Dec 29, 2016 at 2:05 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
tag, clarify, format
|
| Dec 29, 2016 at 2:03 | answer | added | Erwin Brandstetter | timeline score: 3 | |
| Dec 28, 2016 at 23:37 | history | edited | Evan Carroll |
edited tags
|
|
| Dec 28, 2016 at 22:46 | vote | accept | Daniel | ||
| Dec 28, 2016 at 22:38 | answer | added | Evan Carroll | timeline score: 3 | |
| Dec 28, 2016 at 22:33 | comment | added | Evan Carroll | I agree with TypoCube. That's all it can be. | |
| Dec 28, 2016 at 22:32 | comment | added | ypercubeᵀᴹ |
Show us the output of SHOW CREATE TABLE cities ;. I would bet that the cityid is varchar(5).
|
|
| Dec 28, 2016 at 22:07 | review | First posts | |||
| Dec 29, 2016 at 3:25 | |||||
| Dec 28, 2016 at 22:05 | history | asked | Daniel | CC BY-SA 3.0 |