Timeline for Insert Into MySQL over linked server when a medium text is the last column breaks Int fields
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 29, 2017 at 20:31 | vote | accept | AndyD273 | ||
| Jun 21, 2012 at 22:14 | answer | added | swasheck | timeline score: 2 | |
| Jun 20, 2012 at 23:12 | answer | added | Rick James | timeline score: 0 | |
| Jan 3, 2012 at 21:38 | comment | added | AndyD273 | If I changed the insert statement to have the text column not be last then it worked. It's just a weird bug in the mysql db connect stuff. I don't know about InnoDB. We switched to a completely different solution (using MSSql instead of MySQL). | |
| Dec 27, 2011 at 12:53 | comment | added | gbn | What if you just change column order in the INSERT for each table? And using InnoDB? | |
| Sep 6, 2011 at 13:20 | history | edited | AndyD273 | CC BY-SA 3.0 |
Added an example
|
| Sep 3, 2011 at 18:41 | history | tweeted | twitter.com/#!/StackDBAs/status/110059764536455169 | ||
| Sep 2, 2011 at 19:57 | comment | added | Mark D | Have you tried using back ticks instead of single quotes? Also what version of mysql are you using? | |
| Sep 2, 2011 at 19:36 | history | edited | AndyD273 | CC BY-SA 3.0 |
added 7 characters in body
|
| Sep 2, 2011 at 19:33 | history | migrated | from serverfault.com (revisions) | ||
| Sep 2, 2011 at 19:18 | history | asked | AndyD273 | CC BY-SA 3.0 |