~percona-toolkit-dev/percona-toolkit/release-2.2.2

« back to all changes in this revision

Viewing changes to t/lib/samples/TableParser-prefix_idx.sql

  • Committer: Daniel Nichter
  • Date: 2011-06-24 17:22:06 UTC
  • Revision ID: daniel@percona.com-20110624172206-c7q4s4ad6r260zz6
Add lib/, t/lib/, and sandbox/.  All modules are updated and passing on MySQL 5.1.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
CREATE TABLE `t1` (
 
2
  `a` varchar(64) default NULL,
 
3
  `b` varchar(64) default NULL,
 
4
  KEY `prefix_idx` (`a`(10),`b`(20)),
 
5
  KEY `mix_idx` (`a`,`b`(20))
 
6
) ENGINE=MyISAM DEFAULT CHARSET=latin1