You lost your leading zeros of your varchars importing/exporting your data. You have this example data in your table storagebins: area = L, row = 1, rack = 2, shelf = 3 and it is supposed to look like this area = L, row = 001, rack = 02, shelf = 03 Use this SQL [...]
Archive for November, 2011
November 7, 2011 by marco · Leave a Comment
Filed under: Snippets, mySQL
Social Tagging: mySQL • script
Filed under: Snippets, mySQL
Social Tagging: mySQL • script
November 1, 2011 by marco · Leave a Comment
Filed under: Snippets, VBA, mySQL
Social Tagging: development • mySQL • script
Filed under: Snippets, VBA, mySQL
Social Tagging: development • mySQL • script
I used this hacked Excel-Macro to convert all dates in a selected range from a manual data import using Excel to generate all required INSERTs for our MySql database from 03.08.2011 16:51:01 to 2011-08-03 16:51:01 In case you wonder, where you can find your Visual-Basic editor and execute your VBA-code… follow these instructions. Here is [...]
RSS