← 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: 2010-12-26 03:00:37 UTC
  • mto: This revision was merged to the branch mainline in revision 2038.
  • Revision ID: mordred@inaugust.com-20101226030037-2qcfxg5ryamekd56
Cleaned through ha0ha.

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: &&, >>, <<, ~, ^, |, &
199
184
 
200
185
Removed functions
201
186
-----------------
206
191
 
207
192
Keywords removed
208
193
----------------
209
 
 
210
194
 * BIT_AND
211
195
 * BIT_OR
212
196
 * BIT_XOR