diff options
| author | antony@ltantony.rdg.cyberkinetica.homeunix.net <> | 2003-12-10 04:31:42 +0000 |
|---|---|---|
| committer | antony@ltantony.rdg.cyberkinetica.homeunix.net <> | 2003-12-10 04:31:42 +0000 |
| commit | fcf96dbb181a2afbab42ddd1e4a1f0fb2dd2061c (patch) | |
| tree | 786b29c1b82119fc7dc8cadff03c8bd8607d3deb /mysql-test/r/update.result | |
| parent | 28113396ecc3a4594a6f0075e403407d0e1eb6e7 (diff) | |
| download | mariadb-git-fcf96dbb181a2afbab42ddd1e4a1f0fb2dd2061c.tar.gz | |
WorkLog#1323
Deprecate the use of TYPE=... Preferred syntax is ENGINE=
Diffstat (limited to 'mysql-test/r/update.result')
| -rw-r--r-- | mysql-test/r/update.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index a0370272396..6a5546200ce 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -94,7 +94,7 @@ KEY k2 (type), KEY k3 (parent), KEY k4 (assignment), KEY ticket (ticket) -) TYPE=MyISAM; +) ENGINE=MyISAM; INSERT INTO t1 VALUES (773,773,'','','',980257344,20010318180652,0,'Open',10,0,0,0,1,'','','','',''); alter table t1 change lfdnr lfdnr int(10) unsigned not null auto_increment; update t1 set status=1 where type='Open'; @@ -146,7 +146,7 @@ CREATE TABLE t1 ( `nom_option` char(40) NOT NULL default '', `valid` tinyint(1) NOT NULL default '0', KEY `id_param` (`id_param`,`nom_option`) -) TYPE=MyISAM; +) ENGINE=MyISAM; INSERT INTO t1 (id_param,nom_option,valid) VALUES (185,'600x1200',1); UPDATE t1 SET nom_option='test' WHERE id_param=185 AND nom_option='600x1200' AND valid=1 LIMIT 1; select * from t1; |