SpirirHost Support Centre: MySQL Reference Manual p.33

<< 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 1: General Information 33 LIKE is allowed on numeric columns. Use of INTO OUTFILE and STRAIGHT_JOIN in a SELECT statement. See Section 6.4.1 [SELECT], page 447. The SQL_SMALL_RESULT option in a SELECT statement. EXPLAIN SELECT to get a description on how tables are joined. Use of index names, indexes on a prex of a eld, and use of INDEX or KEY in a CREATE TABLE statement. See Section 6.5.3 [CREATE TABLE], page 469. Use of TEMPORARY or IF NOT EXISTS with CREATE TABLE. Use of COUNT(DISTINCT list) where list is more than one element. Use of CHANGE col_name, DROP col_name, or DROP INDEX, IGNORE or RENAME in an ALTER TABLE statement. See Section 6.5.4 [ALTER TABLE], page 476. Use of RENAME TABLE. See Section 6.5.5 [RENAME TABLE], page 480. Use of multiple ADD, ALTER, DROP, or CHANGE clauses in an ALTER TABLE statement. Use of DROP TABLE with the keywords IF EXISTS. You can drop multiple tables with a single DROP TABLE statement. The LIMIT clause of the DELETE statement. The DELAYED clause of the INSERT and REPLACE statements. The LOW_PRIORITY clause of the INSERT, REPLACE, DELETE, and UPDATE statements. Use of LOAD DATA INFILE. In many cases, this syntax is compatible with Oracle's LOAD DATA INFILE. See Section 6.4.9 [LOAD DATA], page 461. The ANALYZE TABLE, CHECK TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements. The SHOW statement. See Section 4.5.6 [SHOW], page 251. Strings may be enclosed by either `"' or `'', not just by `''. Use of the escape `\' character. The SET statement. See Section 5.5.6 [SET], page 369. You don't need to name all selected columns in the GROUP BY part. This gives better performance for some very specic, but quite normal queries. See Section 6.3.7 [Group by functions], page 445. One can specify ASC and DESC with GROUP BY. To make it easier for users who come from other SQL environments, MySQL Server supports aliases for many functions. For example, all string functions support both ANSI SQL syntax and ODBC syntax. MySQL Server understands the || and && operators to mean logical OR and AND, as in the C programming language. In MySQL Server, || and OR are synonyms, as are && and AND. Because of this nice syntax, MySQL Server doesn't support the ANSI SQL || operator for string concatenation; use CONCAT() instead. Because CONCAT() takes any number of arguments, it's easy to convert use of the || operator to MySQL Server. CREATE DATABASE or DROP DATABASE. See Section 6.5.1 [CREATE DATABASE], page 468. The % operator is a synonym for MOD(). That is, N % M is equivalent to MOD(N,M). % is supported for C programmers and for compatibility with PostgreSQL. The =, <>, <= ,<, >=,>, <<, >>, <=>, AND, OR, or LIKE operators may be used in column comparisons to the left of the FROM in SELECT statements. For example:

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