RE: SHOW CREATE TABLE and auto_increment

[Stewart Smith]

On Fri, 2007-10-26 at 09:51 -0700, Rick James wrote:
> Why does it fail to spell out collation correctly?

What exactly is incorrect?

> > >> mysql> show create table pageview_data;
> > >> ...
> > >> | pageview_data | CREATE TABLE `pageview_data` (
> > >>   `query` varchar(150) character set latin1 NOT NULL default '',
> > >>   `pageviews` int(11) default NULL,
> > >>   `date` varchar(10) character set latin1 default NULL,
> > >>   PRIMARY KEY  (`query`)
> > >> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin |
> 
> mysql> SHOW FULL COLUMNS FROM pageview_data;
>  
> +-----------+--------------+-------------------+------+-----+---------+-
> ------+------------+---------+
> | Field     | Type         | Collation         | Null |  Key | Default |
> Extra | Privileges | Comment |
> +-----------+--------------+-------------------+------+-----+---------+-
> ------+------------+---------+
> | query     | varchar(150) | latin1_swedish_ci |      |  PRI |         |
> | select     |         | | pageviews | int(11)      | NULL
> | YES  |     | NULL    |
> | select     |         | | date      | varchar(10)  | latin1_swedish_ci
> | YES  |      | NULL    | | select     |         |
> +-----------+--------------+-------------------+------+-----+---------+-
> ------+------------+---------+ 

-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: [phone] Ext: 6616
VoIP: 6616@stripped
Mobile: [phone]

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc

Attachment: [application/pgp-signature]