Perl ReferenceInstallation To use the interfaces to DataBase Interface/DataBase Driver (DBI/DBD) you must have the following: Perl 5 You must have a working copy of Perl 5 on your system. At the time of this writing, the newest release of Perl was 5.6.1. You should have at least Perl 5.004 since earlier versions of Perl contained security related bugs. For more ...
38 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2225 | Lượt tải: 0
The Python DB-APIDB-API is a single API for supporting database-independent database access. The MySQL implementation of this API, MySQLdb, can be downloaded from http:// dustman.net/andy/python/MySQLdb. It comes with a Redhat RPM Linux installer, a Win32 installer, and a Python script for other platforms. For the "other platforms": 1. Uncompress the .tar...
9 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 3444 | Lượt tải: 0
C ReferenceMySQL C API The MySQL C API uses several defined datatypes beyond the standard C types. These types are defined in the ‘mysql.h’ header file that must be included when compiling any program that uses the MySQL library. Datatypes MYSQL A structure representing a connection to the database server. The elements of the structure contain the name of the...
28 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2321 | Lượt tải: 0
PHP ReferencePHP provides a wide range of functions that are useful when creating database-driven applications. So many, in fact, that it would be unwieldy to list all of them in a book about MySQL. Therefore this reference chapter concentrates on the functions that PHP provides to interface directly with MySQL. This includes the new PHP database abstraction la...
26 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2368 | Lượt tải: 0
MySQL System TablesIn Chapter XXX: Security we saw how MySQL used its own internal tables to store the access information used to perform authentication. There are actually several internal tables that are created as part of every MySQL server installation. MySQL uses these tables for a variety of purposes. Columns_Priv +-------------+--------------------------------...
7 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2340 | Lượt tải: 0
MySQL and Programs and UtilitiesMySQL comes with a wealth of programs and utilities to make interacting with the database server easier. Some of these programs are used by the end user to read and write from the database, while others are meant for the database administrator to maintain and repair the database as a whole. In this chapter, we’ll provide detailed documentation for ...
30 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2033 | Lượt tải: 0
MySQL System VariablesA variety of settings can be used to customize the operation of MySQL. Settings fall into two main categories: ã Operating System Environment variables ã MySQL variables, which can be set via the command line or in a configuration file. Variables defined in multiple places follow obey the following order of precedence: 1. Items defined on the comma...
10 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2297 | Lượt tải: 1
Operators and FunctionsLike any other programming language, SQL carries among its core elements operators and named procedures. This reference lists all of those operators and functions and explains how they evaluate into useful expressions. Operators MySQL operators may be divided into three kinds of operators: arithmetic, comparison, and logical. Rules of Precedence Wh...
16 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2289 | Lượt tải: 0
MySQL Data TypesMySQL supports a wide variety of data types to support the storage of different kinds of data. This chapter lists the full range of these data types as well as a description of their functionality, syntax, and data storage requirements. For each data type, the syntax shown uses square brackets ([]) to indicate optional parts of the syntax. The foll...
15 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2393 | Lượt tải: 0
SQL Syntax for MySQLIn this chapter, we cover the full range of SQL supported by MySQL. If you are interested in compatibility with other SQL databases, MySQL supports the ANSI SQL2 standard. In that case, you should avoid using any proprietary MySQL extensions to the SQL standard. Basic Syntax SQL is a kind of controlled English language consisting of verb phrases. T...
32 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 3651 | Lượt tải: 0
