Thư viện tài liệu, ebook tổng hợp lớn nhất Việt Nam

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: 3649 | 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: 2945 | 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: 2577 | 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: 2308 | 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: 2480 | Lượt tải: 0

One of the most important aspects of both database administration and application design is also one of the most overlooked: security. While there are dozens of definitions of security that can apply to computer software, we can sum up our needs simply. Security is the ability to allow authorized users to access data while preventing access from un...

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

Large corporate computing shops have been using complex and expensive database products for years. These full-featured, heavily optimized software systems are the only way for a big organization to manage its volumes of corporate information. Home computer users haven’t traditionally needed database products at all. They house their data—addresses,...

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