diff options
Diffstat (limited to 'mysql-test/r/ansi.result')
-rw-r--r-- | mysql-test/r/ansi.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/ansi.result b/mysql-test/r/ansi.result index cc4b6b5fa65..527748e00d5 100644 --- a/mysql-test/r/ansi.result +++ b/mysql-test/r/ansi.result @@ -21,28 +21,28 @@ CREATE TABLE t1 (i int auto_increment NOT NULL, PRIMARY KEY (i)); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `i` int(11) NOT NULL auto_increment, - PRIMARY KEY (`i`) + `i` int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`i`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 SET @@SQL_MODE="MYSQL323"; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `i` int(11) NOT NULL auto_increment, - PRIMARY KEY (`i`) + `i` int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`i`) ) TYPE=MyISAM SET @@SQL_MODE="MYSQL40"; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `i` int(11) NOT NULL auto_increment, - PRIMARY KEY (`i`) + `i` int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`i`) ) TYPE=MyISAM SET @@SQL_MODE="NO_FIELD_OPTIONS"; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `i` int(11) NOT NULL, - PRIMARY KEY (`i`) + PRIMARY KEY (`i`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DROP TABLE t1; |