Code Factory for MySQL online Help

Return to chapter overview

MySQL identifiers

There are some restrictions on the characters that may appear in identifiers:

•	No identifier can contain ASCII 0 (0x00) or a byte with a value of 255.

•	The use of identifier quote characters in identifiers is permitted, although it is best to avoid doing so if possible.

•	Database, table, and column names should not end with space characters.

•	Before MySQL 5.1.6, database names cannot contain ‘/’, ‘\’, ‘.’, or characters that are not allowed in a directory name.

•	Before MySQL 5.1.6, table names cannot contain ‘/’, ‘\’, ‘.’, or characters that are not allowed in a filename.

Return to chapter overview

Company news

Apr 10, 2017

Code Factories advanced to version 17.4

New version features colored tabs, new encryption algorithms in data grids, enhanced data input forms, updated data export/import tools and a lot of other useful things.

Sep 20, 2013

Code Factories are updated to version 13.9

New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many other useful things.

Mar 5, 2012

Code Factories advanced to version 12.3

New version introduces Unicode support in editors, updated code folding appearance, viewing BLOB data as PDF, data import from ODBC data source, Spanish translation and a lot of other new features.

More news

Feature of the day

Diagram Viewer

MySQL Code Factory allows you to represent numeric data from a query result as a diagram with a possibility of customizing its appearance and export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more.

Data management

MySQL Code Factory provides you with all the features (such as viewing, editing, grouping, sorting and filtering) to analyze the data in the most convenient way.