HTTP/2 302 server: nginx date: Fri, 18 Jul 2025 01:47:36 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20090226052033 location: https://web.archive.org/web/20090226052033/https://www.techotopia.com/index.php/MySQL_Essentials server-timing: captures_list;dur=0.649291, exclusion.robots;dur=0.035408, exclusion.robots.policy;dur=0.008424, esindex;dur=0.009837, cdx.remote;dur=8.843928, LoadShardBlock;dur=197.472872, PetaboxLoader3.datanode;dur=60.924939, PetaboxLoader3.resolve;dur=42.141729 x-app-server: wwwb-app239 x-ts: 302 x-tr: 253 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1 set-cookie: SERVER=wwwb-app239; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Fri, 18 Jul 2025 01:47:38 GMT content-type: text/html; charset=UTF-8 x-archive-orig-date: Thu, 26 Feb 2009 05:20:32 GMT x-archive-orig-server: Apache/2.2.3 (CentOS) x-archive-orig-x-powered-by: PHP/5.1.6 x-archive-orig-content-language: en x-archive-orig-vary: Accept-Encoding,Cookie x-archive-orig-expires: Thu, 01 Jan 1970 00:00:00 GMT x-archive-orig-cache-control: private, must-revalidate, max-age=0 x-archive-orig-last-modified: Mon, 06 Oct 2008 19:05:14 GMT x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Thu, 26 Feb 2009 05:20:33 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Tue, 30 Oct 2007 21:14:42 GMT", ; rel="prev memento"; datetime="Thu, 22 Jan 2009 02:14:11 GMT", ; rel="memento"; datetime="Thu, 26 Feb 2009 05:20:33 GMT", ; rel="next memento"; datetime="Fri, 27 Feb 2009 06:32:12 GMT", ; rel="last memento"; datetime="Sun, 25 May 2025 01:58:29 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 51_8_20090226004233_crawl100-c/51_8_20090226052019_crawl101.arc.gz server-timing: captures_list;dur=0.620606, exclusion.robots;dur=0.019913, exclusion.robots.policy;dur=0.006994, esindex;dur=0.010500, cdx.remote;dur=261.100316, LoadShardBlock;dur=1090.055019, PetaboxLoader3.datanode;dur=537.497705, PetaboxLoader3.resolve;dur=992.907328, load_resource;dur=455.813627 x-app-server: wwwb-app239 x-ts: 200 x-tr: 2032 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip

MySQL Essentials

From Techotopia

Jump to: navigation, search

MySQL Essentials is an online book designed to provide everything a user needs to know to install, build, maintain and secure MySQL based databases.

	Table of Contents	Next
		About MySQL Essentials

---

About MySQL Essentials Database Basics What is a Database? Understanding Database Tables Introducing Database Schema Columns and Datatypes Database Rows Introducing Primary Keys What is SQL? MySQL Database Architecture The mysql Command-Line Tool The mysql Command-line Utility mysql Command-Line Arguments mysql Commands The MySQL Administrator Tool Getting and Installing MySQL Administrator Connecting to the Database Server Using the MySQL Administator The MySQL Query Browser Getting and Installing MySQL Query Browser Connecting the MySQL Query Browser to a Database Server A Tour of MySQL Browser Executing SQL Statements Creating New Databases and Tables with MySQL Administrator Creating a New Database Creating New Tables Creating Databases and Tables Using SQL Commands Creating a New MySQL Database Creating Tables with SQL Understanding NULL and NOT NULL Values Primary Keys AUTO_INCREMENT Defining Default Values During Table Creation MySQL Database Engine Types Updating and Deleting MySQL Tables Altering a MySQL Table Adding and Deleting Table Columns Renaming Tables and Columns Changing The Data Type of a Column Deleting a Database Table Inserting Data into a MySQL Database The Basics of Data Insertion Inserting a Complete Row Adding Multiple Rows to a Table Inserting Results from a SELECT Statement Reducing the INSERT Performance Load Reducing the INSERT Performance Load Updating and Deleting MySQL Data Updating Database Data Ignoring Update Errors Deleting Database Data Retrieving Data From a MySQL Database Retrieving a Single Column Using SELECT to Retrieve Mutiple Columns Restricting Number of Results Eliminating Duplicate Values from Results Sorting Data Retrieved from a MySQL Database Sorting Data from a SELECT Statement Sorting on Multiple Columns Sorting Data in Descending Order Using WHERE to Filter MySQL Data The Basics of the WHERE Clause Comparison Operators Checking for NULL Values Searching within Range Values Advanced MySQL Data Filtering - AND, OR, NOT and IN Filtering Data Using the OR Operator Filtering Data Using the AND Operator Combining AND and OR Operators Understanding Operator Precedence Specifying a Range of Conditions using the IN Clause Using the NOT Operator MySQL Wildcard Filtering using LIKE What are Wildcards? Single Character Wildcards Multiple Character Wildcards MySQL Regular Expression Searches What are Regular Expressions? Regular Expression Character Matching Matching from a Group of Characters Matching from a Range of Characters Handling Special Characters Regular Expressions and Whitespace Characters Matching by Character Type Regular Expression Repetition Metacharacters Matching by Text Position Joining Tables in MySQL How Does a Join Work? Performing a Cross-Join Equi-Join (aka the Inner Join) Performing a Left Join or a Right Join Creating Joins with WHERE and USING An Introduction to MySQL Views Creating a Basic View Joins and Views Getting Information About a View Deleting a View Replacing a View MySQL Calculations and Concatenations Performing Calculations on Retrieved Data Concatenating Data Fields Trimming Trailing Whitespace from Text Trimming Leading Whitespace from Text Manipulating Text in MySQL MySQL String Manipulation Functions MySQL Mathematical Functions MySQL Arithmetic Functions Working with Dates and Times in MySQL Date and Time Formats Creating Date and Time Fields Date and Time Formats Date and Time Functions Inserting Date and Time Values into Table Columns Retrieving Data Based on Date and Time Criteria MySQL Data Aggregation Functions The MySQL Aggregate Functions Using the Aggregate Functions Using the MySQL AVG() Function Using the MySQL COUNT() Function Using the MySQL MAX() Function Using the MySQL MIN() Function Using the SUM() Function Using Multiple Aggregate Functions MySQL Users and Security MySQL Security Getting Information About Users Creating a New MySQL User Deleting a MySQL User Renaming a MySQL User Changing the Password for a MySQL User User Privileges

---

	Table of Contents	Next
		About MySQL Essentials

Retrieved from "https://www.techotopia.com/index.php/MySQL_Essentials"

Views

Personal tools

Navigation

• Home
• PowerShell
• Hyper-V
• VMware Server
• Xen Virtualization
• Windows Server 2008
• Security+
• Ubuntu Linux
• Ubuntu Desktop
• Fedora Linux
• Fedora Desktop
• OpenSUSE Desktop
• C#
• Visual Basic
• MySQL
• PHP
• JavaScript
• Ruby
• Windows
• Networking
• Web Development
• Feedback
• Web Store

Search

• This page was last modified 19:05, 6 October 2008.
• This page has been accessed 31,849 times.
• Copyright 2009 Techotopia.com. All Rights Reserved.
• Privacy policy