Tài liệu, ebook Kỹ Thuật Lập Trình

A 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: 2299 | Lượt tải: 1

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

In 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

Java is one of the simplest languages in which you can write MySQL applications. Its database access API JDBC (Java DataBase Connectivity) is one of the more mature database-independent database access APIs in common use. Most of what we cover in this chapter can be applied to Oracle, Sybase, MS SQL Server, mSQL, and any other database engine as we...

22 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2946 | Lượt tải: 1

In this book,, we examine several different programming languages, Python, Java, Perl, PHP and C. Of these languages. C/C++ is by far the most challenging. With the other languages, your primary concern is the formulation of SQL, the passing of that SQL to a function call, and the manipulation of the resulting data. C adds the very complex issue of...

12 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2439 | Lượt tải: 0

If you are not familiar with Python and you do a lot of Perl programming, you definitely want to take a look at it. Python is an object-oriented scripting language that combines the strengths of languages like Perl and Tcl with a clear syntax that lends itself to applications that are easy to maintain and extend. The O’Reilly & Associates, Inc. boo...

12 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2580 | Lượt tải: 0

The Perl programming language has gone from a tool primary used by Unix systems administrators to the most widely used development platform for the World Wide Web. Perl was not designed for the web, but its ease of use and powerful text handling abilities have made it a natural for Web application development. Similarly MySQL, with its small footpr...

27 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2437 | Lượt tải: 0

We have spent the entire book so far discussing the database as if it exists in some sort of vacuum. It serves its purpose only when being used by other applications. We should therefore take a look at how the database relates to the other elements of a database application before exploring the details of database application development in various...

10 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2309 | Lượt tải: 0

Once you install your DBMS software on your computer, it can be very tempting to just jump right into creating a database without much thought or planning. As with any software development, this kind of ad hoc approach works with only the simplest of problems. If you expect your database to support any kind of complexity, some planning and design w...

16 trang | Chia sẻ: tlsuongmuoi | Ngày: 08/01/2013 | Lượt xem: 2482 | Lượt tải: 0