Convert full columns from VARCHAR to number ? MYSQL

Hi! I have a column with some empty rows and then some sales, so i had to import it as VARCHAR so the importwizard wouldnt remove those rows. But now i want to use the sales numbers to make calculations so i need them as numbers. Any way to convert the full column since i dont know wich specific number im gonna use ?

submitted by /u/Alicialves
[link] [comments]


Go to Source of this post
Author Of this post: /u/Alicialves
Title Of post: Convert full columns from VARCHAR to number ? MYSQL
Author Link: {authorlink}