SpirirHost Support Centre: MySQL Reference Manual p.379

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 6: MySQL Language Reference 379 NULL may be represented by \N when using the text le import or export formats (LOAD DATA INFILE, SELECT ... INTO OUTFILE). See Section 6.4.9 [LOAD DATA], page 461. 6.1.2 Database, Table, Index, Column, and Alias Names Database, table, index, column, and alias names all follow the same rules in MySQL. Note that the rules changed starting with MySQL Version 3.23.6 when we introduced quot- ing of identiers (database, table, and column names) with ``'. `"' will also work to quote identiers if you run in ANSI mode. See Section 1.7.2 [ANSI mode], page 31. Identier Max length Allowed characters Database 64 Any character that is allowed in a directory name except `/', `\' or `.'. Table 64 Any character that is allowed in a le name, except `/' or `.'. Column 64 All characters. Alias 255 All characters. Note that in addition to the above, you can't have ASCII(0) or ASCII(255) or the quoting character in an identier. Note that if the identier is a restricted word or contains special characters you must always quote it with ` when you use it: mysql> SELECT * FROM `select` WHERE `select`.id > 100; See Section 6.1.7 [Reserved words], page 385. In MySQL versions prior to 3.23.6, the name rules are as follows: A name may consist of alphanumeric characters from the current character set and also `_' and `$'. The default character set is ISO-8859-1 Latin1; this may be changed with the --default-character-set option to mysqld. See Section 4.6.1 [Character sets], page 267. A name may start with any character that is legal in a name. In particular, a name may start with a digit (this diers from many other database systems!). However, a name cannot consist only of digits. You cannot use the `.' character in names because it is used to extend the format by which you can refer to columns (see immediately below). It is recommended that you do not use names like 1e, because an expression like 1e+1 is ambiguous. It may be interpreted as the expression 1e + 1 or as the number 1e+1. In MySQL you can refer to a column using any of the following forms: Column reference Meaning col_name Column col_name from whichever table used in the query contains a column of that name. tbl_name.col_name Column col_name from table tbl_name of the current database. db_name.tbl_name.col_ name Column col_name from table tbl_name of the database db_ name. This form is available in MySQL Version 3.22 or later.

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide