No Featured Found!
How to change the datatype of a column in MySQL?
Sometimes we need to change the data type of a column in a table. We can do this by using Modify keyword with ALTER command. Syntax: To change the data type of a column in a table, use the following syntax: ALTER TABLE table_name MODIFY...
Change Column data-type from VARCHAR to DATE
Hello friends, I am here for share the solution of a MySQL problem. If you want to change the data type of a column from varchar or any other one to date, you should need to use following query- UPDATE `tbl` SET `date1` = STR_TO_DATE(`date...