MySQL Quick Guide

Project Specifications for MySQL Quick Guide Looking for someone to produce a "quick guide" for MySQL version 5.5. I estimate that this work will require a minimum of 15 hours to complete. * Each page of the guide must be written and formatted in HTML. I will provide example pages of existing guides along with the style sheets. Look at the included screenshots for more information. * Content must not be copied directly from the internet or other copyrighted sources (can be re-worded) * Must be proficient in US English language and experienced at writing technical guides. * At a minimum, the quick guide must contain the following chapters and topics: 1. Introduction (1 html file containing these headings / sections) a. Description of MySQL b. Supported Operating Systems c. Minimum requirements d. Current stable version 2. Installation (1 html file containing these headings / sections) a. How to obtain the installation package b. Pre-install tasks (if any) c. Installation guide (include minimum of Windows and Mac installations) d. Post-install tasks (if any) e. Verification of install 3. Language Syntax (1 html file containing these headings / sections) b. Comments 4. Operators (1 html file containing these headings / sections) a. Rules of Precedence b. Arithmetic Operators c. Comparison Operators d. Logical Operators 5. MySQL Programs a. MySQL Programs (provide list of most important MySQL programs and a short description of each in a separate HTML file) 6. Data Types (Numerics) 0. Overview (1 HTML file that contains a table listing each datatype and a short description) a. BIGINT b. BIT . . (includle all numeric datatypes and a description of each in separate HTML file) . z. TINYINT 7. Data Types (Strings) 0. Overview (1 HTML file that contains a table listing each datatype and a short description) . (includle all string datatypes and a description of each in separate HTML file) 8. Data Types (Dates) 0. Overview (1 HTML file that contains a table listing each datatype and a short description) . (includle all date datatypes and a description of each in separate HTML file) 9. Data Types (Binary) 0. Overview (1 HTML file that contains a table listing each datatype and a short description) . (includle all binary datatypes and a description of each in separate HTML file) 10. Data Types (Complex) 0. Overview (1 HTML file that contains a table listing each datatype and a short description) . (includle all complex datatypes and a description of each in separate HTML file) 11. Literals a. String b. Bit c. Boolean d. Decimal e. Hexadecimal f. Null . (includle all literals and a description of each in separate HTML file) 12. Functions a. Overview (1 HTML file that contains a table listing each function and a short description) b. ABS() c. ACOS() . . . ?. YEARWEEK() . (includle all functions and a description of each in separate HTML file) (Note: there are at least 200 functions to list in this section, each in a separate HTML file) 13. Common Commands (the following list is the minimum commands to be listed, each in a separate HTML file - HTML file should contain a description and example of the command) Starting MySQL Create a database List all databases Switch to a database Delete a database Delete a table List all tables Show database's field formats Show all data in a table Show rows with the value "whatever". Show all records containing the name "Bob" AND the phone number '3444444'. Show selected records sorted in an ascending (asc) or descending (desc). Return number of rows. Update info already in a table Delete a row(s) from a table. Update database permissions/privilages. Delete a column. Add a new column to db. Change column name. Populate from .sql file Populate from .csv file Dump one database to .sql file Dump all databases to .sql file Dump table use Database Restore database (or database table) from backup