← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/mysql_differences.rst

  • Committer: Monty Taylor
  • Date: 2011-01-12 21:31:39 UTC
  • mto: (2081.1.1 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2082.
  • Revision ID: mordred@inaugust.com-20110112213139-65ivcqxyydejcvr3
Removed some redundant declarations.

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/mysql_differences.rst
112
112
 
113
113
INFORMATION_SCHEMA
114
114
------------------
115
 
 
116
115
The INFORMATION_SCHEMA provides access to database metadata.
117
116
 
118
117
The INFORMATION_SCHEMA in Drizzle is strictly ANSI compliant. If you write
167
166
queries. Our INFORMATION_SCHEMA implementation does not have the drawbacks
168
167
of the MySQL implementation.
169
168
 
170
 
Here are some specific SHOW differences:
171
 
 
172
169
 * 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
177
170
 
178
171
Removed commands
179
172
----------------
183
176
 * CREATE FUNCTION
184
177
 * CONVERT
185
178
 * SET NAMES
186
 
 * Multi-table delete and multi-table update code was removed and can be accomplished through subqueries. More detailed information can be found in the :doc:`dml` section.
187
179
 
188
180
Operators Removed
189
181
-----------------
190
182
 
191
 
Bit operators
192
 
 * &&
193
 
 * >>
194
 
 * <<
195
 
 * ~
196
 
 * ^
197
 
 * '|'
198
 
 * &
 
183
Bit operators: 
 
184
* &&
 
185
* >>
 
186
* <<
 
187
* ~
 
188
* ^
 
189
* |
 
190
* &
199
191
 
200
192
Removed functions
201
193
-----------------
206
198
 
207
199
Keywords removed
208
200
----------------
209
 
 
210
201
 * BIT_AND
211
202
 * BIT_OR
212
203
 * BIT_XOR