• MySQL Data TypesMySQL Data Types

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

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

  • SQL Syntax for MySQLSQL Syntax for MySQL

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

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

  • Giáo trình JavaGiáo trình Java

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

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

  • C apiC api

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

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

  • Python MySQLPython MySQL

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

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

  • Perl MysqlPerl Mysql

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

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

  • Database ApplicationsDatabase Applications

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

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

  • Database DesignDatabase Design

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

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

  • Security MySQLSecurity MySQL

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

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

  • Introduction to Relational DatabasesIntroduction to Relational Databases

    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,...

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