Been trying to import a file from excel to MySql but I keep running into an error about the date column. Some dates in the column are written; 4/12/2016 while others are written 04/13/2016. I have tried my best to format it but it’s not working maybe I am missing something I don’t know of.… Read More MySql and excel

I’m using MS SQL and creating a table. One of the columns should contain a string with 4 symbols: L001, L002 There cannot be less or more symbols, e.g. L01 and L0001 are errors. Which type of data I need to use? CHAR(4) and NCHAR(4) allow me to create L01 and it’s wrong in my… Read More MS SQL column with fixed number of symbols