title: How to change the number of characters outputted in mySQL?
body: <p>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.</p>
  
  <pre><code>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;
  </code></pre>