Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

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...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: