update ip adress int unsigned


I have to update ip adresses from a csv file to a MySQL table which column type is int unsigned.
How can I convert int unsigned to signed?

Who is Participating?
ArgentiConnect With a Mentor Commented:
Open an SQL editor connected to your MySQL database and execute the following statement:

ALTER TABLE `my_database`.`my_table` 
CHANGE COLUMN `TheColumnName` `TheColumnName` INT(11) NOT NULL ;

Open in new window

This way it eliminates the UNSIGNED flag from your column definition.
You can specify another size for your INT, not necessarily 11.
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.