SalientAnimal Posted September 6, 2012 Share Posted September 6, 2012 Hi All, My quest is pretty simple, but I haven't been able to find a solution. I'm trying to extract a BIGINT value of 13 characters with my query. Everytime this number is exported to Excel in CSV from MySQL Workbench the number is not displayde correctly in the cells and you first need to format the cell. Is there a way to run the query so that the conversion happens before exporting to Excel CSV? Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted September 6, 2012 Share Posted September 6, 2012 So what conversion happens first? Quote Link to comment Share on other sites More sharing options...
Jessica Posted September 6, 2012 Share Posted September 6, 2012 This is a problem with Excel, you're talking about the number being shown in scientific notation, right? The only trick I've found is to make sure it's a string, by putting quotes around it. Quotes in the output. Quote Link to comment Share on other sites More sharing options...
SalientAnimal Posted September 7, 2012 Author Share Posted September 7, 2012 Thanks guys, I managed to solve this by using a CONCAT(FIELD,"\t"). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.