Mysql change field length?

Question

MySQL

how to change field length?

CREATE TABLE IF NOT EXISTS my_table (
              id int(11) unsigned NOT NULL AUTO_INCREMENT,
              timestamp int(22) NOT NULL,
              ip varchar(40) NOT NULL
              PRIMARY KEY (id)
            )

need

CREATE TABLE IF NOT EXISTS my_table (
              id int(22) unsigned NOT NULL AUTO_INCREMENT,
              timestamp int(40) NOT NULL,
              ip varchar(80) NOT NULL
              PRIMARY KEY (id)
            )

Answer 1

ALTER TABLE

Answer 2

I will give a simple advice on how to properly build such DDL data. Go to phpmyadmin, through the GUI change what you need in the table, and copy the query.