Dyntex.net Support Centre: MySQL Reference Manual p.32

<< 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

32 MySQL Technical Reference for Version 4.0.3 REAL will be a synonym for FLOAT instead of a synonym for DOUBLE. The default transaction isolation level is SERIALIZABLE. See Section 6.7.3 [SET TRANSACTION], page 485. This is the same as using --sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES, IGNORE_SPACE,SERIALIZE,ONLY_FULL_GROUP_BY. 1.7.3 MySQL Extensions to ANSI SQL92 MySQL Server includes some extensions that you probably will not nd in other SQL databases. Be warned that if you use them, your code will not be portable to other SQL servers. In some cases, you can write code that includes MySQL extensions, but is still portable, by using comments of the form /*! ... */. In this case, MySQL Server will parse and execute the code within the comment as it would any other MySQL statement, but other SQL servers will ignore the extensions. For example: SELECT /*! STRAIGHT_JOIN */ col_name FROM table1,table2 WHERE ... If you add a version number after the '!', the syntax will be executed only if the MySQL version is equal to or newer than the used version number: CREATE /*!32302 TEMPORARY */ TABLE (a int); This means that if you have Version 3.23.02 or newer, MySQL Server will use the TEMPORARY keyword. The following is a list of MySQL extensions: The eld types MEDIUMINT, SET, ENUM, and the dierent BLOB and TEXT types. The eld attributes AUTO_INCREMENT, BINARY, NULL, UNSIGNED, and ZEROFILL. All string comparisons are case-insensitive by default, with sort ordering determined by the current character set (ISO-8859-1 Latin1 by default). If you don't like this, you should declare your columns with the BINARY attribute or use the BINARY cast, which causes comparisons to be done according to the ASCII order used on the MySQL server host. MySQL Server maps each database to a directory under the MySQL data directory, and tables within a database to lenames in the database directory. This has a few implications: Database names and table names are case-sensitive in MySQL Server on oper- ating systems that have case-sensitive lenames (like most Unix systems). See Section 6.1.3 [Name case sensitivity], page 380. Database, table, index, column, or alias names may begin with a digit (but may not consist solely of digits). You can use standard system commands to back up, rename, move, delete, and copy tables. For example, to rename a table, rename the `.MYD', `.MYI', and `.frm' les to which the table corresponds. In SQL statements, you can access tables from dierent databases with the db_ name.tbl_name syntax. Some SQL servers provide the same functionality but call this User space. MySQL Server doesn't support tablespaces as in: create table ralph.my_table...IN my_tablespace.

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

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