|
Free ebooks
 Free database ebooks SQL MySQL Pocket Reference Secnd Edition
|
 MySQL 5 - If you have been using MySQL for a while, you really don’t need to learn a thing about MySQL 5 to keep going. Everything you are used to using still works just as it always has. For the most part, MySQL 5 is about adding enterprise database features seen in other database engines without burdening MySQL with concepts that make it harder to learn and use.Setup - You can install MySQL by compiling the source code with the options that best suit your needs, or by downloading and installing a prebuilt binary. In general, you’ll want to use the package management system appropriate to your operating system. You can also find both binary and source code at the MySQL web site, http://www.mysql.com. Before installing using either approach, you need to prepare your operating system for MySQL. Specifically, you should create a mysql user and group under which MySQL will run. Data Types - For each data type, the syntax shown uses square brackets ([]) to indicate optional parts of the syntax. SQL - MySQL fully supports ANSI SQL 92, entry level. A SQL reference for MySQL is thus largely a general SQL reference. Nevertheless, MySQL contains some proprietary enhancements that can help you at the mysql command line. This section thus provides a reference for the SQL query language as it is supported in MySQL. Operators - MySQL offers three kinds of operators: arithmetic, comparison, and logical. Functions - MySQL provides built-in functions that perform special operations. Stored Procedures and Functions - Stored routines are encapsulated SQL components that are stored in the database for reuse in your database applications. MySQL supports two kinds of stored routines: procedures and functions. Download free ebooks for SQL:MySQL Pocket Reference Secnd Edition
|
