Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to Change the datatype of columns in MYSQL table. That video is uploaded by Learn SQL at 2022-12-18T10:31:05-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [Q8x--bZn0_o]
| Name | How to Change the datatype of columns in MYSQL table |
| Video Uploader | Video From Learn SQL |
| Upload Date | This Video Uploaded At 18-12-2022 18:31:05 |
| Video Discription | SQL Query Alter Table [tablename] Modify column [columnName] [datatype]; ALTER TABLE [tablename] CHANGE [columnName] [columnName] [datatype]; ALTER TABLE sqlvspython.amazingmart CHANGE column `Order ID` ORDER_ID varchar(25); ALTER TABLE sqlvspython.amazingmart CHANGE column lon longitude TEXT; ALTER TABLE sqlvspython.amazingmart CHANGE column lat latitude TEXT; ALTER TABLE sqlvspython.amazingmart Modify column `order date` Date; -- Error Code: 1292. Incorrect date value: '01/01/2011' for column 'order date' at row 1' -- Replace "-" with "/" select cast(replace(`order date`,'-','/') as date) from amazingmart; -- str_to_date , date_format update amazingmart set `order date` = replace(`order date`,'-','/') ; ALTER TABLE amazingmart CHANGE column `order date` `Order_Date` varchar(20); update amazingmart set order_date = date_format(str_to_date(order_date,'%d/%m/%Y'),'%Y-%m-%d'); select cast(Order_Date as date) from amazingmart; ALTER TABLE amazingmart Modify column `Order_Date` date; Q8x--bZn0_o |
| Category | People & Blogs |
| Tags | People & Blogs Download MP4 | People & Blogs Download MP3 | People & Blogs Download MP4 360p | People & Blogs Download MP4 480p | People & Blogs Download MP4 720p | People & Blogs Download MP4 1080p |
