~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/mysql_differences.rst

  • Committer: Andrew Hutchings
  • Date: 2011-02-07 17:20:59 UTC
  • mfrom: (2148 staging)
  • mto: (2148.2.3 build)
  • mto: This revision was merged to the branch mainline in revision 2149.
  • Revision ID: andrew@linuxjedi.co.uk-20110207172059-dyeahrgzrlincoe3
Merge with trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
167
167
queries. Our INFORMATION_SCHEMA implementation does not have the drawbacks
168
168
of the MySQL implementation.
169
169
 
 
170
Here are some specific SHOW differences:
 
171
 
170
172
 * SHOW ENGINES: use DATA_DICTIONARY
 
173
 * SHOW CREATE TABLE: specifies the AUTO_INCREMENT at CREATE/ALTER TABLE time,
 
174
   not the current AUTO_INCREMENT
 
175
 * SHOW TABLE STATUS: only shows tables in the current table cache
 
176
 * SHOW [ENGINE] STATUS: use the DATA_DICTIONARY tables for that engine
171
177
 
172
178
Removed commands
173
179
----------------