How to change the number of characters outputted in mySQL?
I have this mysql query. It generates a table with a 30 character long id. Im wondering wh开发者_StackOverflow社区at I can change to change the 30 character id to a 9 character one.
CREATE TABLE IF NOT EXISTS `links` (
`id` char(30) character set latin1 collate latin1_general_cs NOT NULL,
`ip` varchar(15) NOT NULL,
`hit` int(15) NOT NULL default '0',
`whohit` text,
`subscribe` tinyint(1) default '0',
PRIMARY KEY (`id`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
I guess you need ALTER TABLE command. Go to MySQL console and run this query:
ALTER TABLE links CHANGE `id` `id` char(9)
character set latin1 collate latin1_general_cs NOT NULL;
This command will change type of already created column.
I have this mysql query. It generates a table with a 30 character long id. Im wondering what I can change to change the 30 character id to a 9 character one.
Swap...
`id` char(30)
...with...
`id` char(9)
This will create the id
column to be be of char
type, 9 chars wide.
精彩评论