SpirirHost Support Centre: MySQL Reference Manual p.47

<< 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 47 For tables with primary keys that are missing some part of the key in the incoming data stream, or that have no primary key, the feed is treated as a LOAD DATA INFILE ... REPLACE INTO now. Make LOAD DATA INFILE understand syntax like: LOAD DATA INFILE 'file_name.txt' INTO TABLE tbl_name TEXT_FIELDS (text_field1, text_field2, text_field3) SET table_field1=CONCAT(text_field1, text_field2), table_field3=23 IGNORE text_field3 This can be used to skip over extra columns in the text le, or update columns based on expressions of the read data. LOAD DATA INFILE 'file_name' INTO TABLE 'table_name' ERRORS TO err_table_ name. This would cause any errors and warnings to be logged into the err_table_name table. That table would have a structure like: line_number - line number in datafile error_message - the error/warning message and maybe data_line - the line from the datafile Automatic output from mysql to Netscape. LOCK DATABASES (with various options.) Functions: ADD TO SET(value,set) and REMOVE FROM SET(value,set). Add use of t1 JOIN t2 ON ... and t1 JOIN t2 USING ... Currently, you can only use this syntax with LEFT JOIN. Many more variables for show status. Records reads and updates. Selects on 1 table and selects with joins. Mean number of tables in select. Number of ORDER BY and GROUP BY queries. If you abort mysql in the middle of a query, you should open another connection and kill the old running query. Alternatively, an attempt should be made to detect this in the server. Add a handler interface for table information so that you can use it as a system table. This would be a bit slow if you requested information about all tables, but very exible. SHOW INFO FROM tbl_name for basic table information should be implemented. NATURAL JOIN. Allow SELECT a FROM crash_me LEFT JOIN crash_me2 USING (a); in this case a is as- sumed to come from the crash_me table. Fix so that ON and USING works with the JOIN join type. Oracle-like CONNECT BY PRIOR ... to search hierarchy structures. mysqladmin copy database new-database; requires COPY command to be added to mysqld. Processlist should show number of queries/threads. SHOW HOSTS for printing information about the hostname cache. DELETE and REPLACE options to the UPDATE statement (this will delete rows when one gets a duplicate key error while updating).

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