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
Forgot Password?
                           OR                           
Create an account !!
                           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: