Databases - MySQL

Advanced data (1)

Advanced data filtering (1)

Advanced SQL (1)

Aggregate functions (4)

Aliases (2)

Alter Tables (1)

Alternative (1)

Analyze web usage (1)

ASP (2)

ASP.NET (1)

Assign Column Aliases (1)

Authentication (1)

Automating (1)

Average (1)

Backup (4)

Basics (2)

Bit.ly API (1)

Blogging (1)

Blogging System (1)

Calculate (1)

Calculated fields (1)

Calling (1)

CASE Expression (1)

Check (1)

Clause (4)

Clauses (2)

Cleaning (1)

Cleaning up User Data (1)

CMS (1)

Column (4)

Columns (3)

Combined WHERE clause (1)

Commit (1)

Common security breach (1)

Concatenate Non Numerical Columns (1)

Control Structures (1)

Converting (1)

Copy (1)

Covering (1)

Cursors (2)

Data (17)

Data filtering (4)

Data Types (2)

Database (19)

Database Backup (1)

Database Basics (1)

Database Operations (1)

Database structure (1)

Database Table (1)

Debugging (1)

Debugging PL SQL (1)

DELETE statements (1)

Deleting (1)

Deleting data (1)

Deletion (1)

Derived Table (1)

Designing (1)

Designing Relational (1)

Differences (1)

Different Approach (1)

DROP Statements (1)

Dump .sql File (1)

Efficient Web Applications (1)

Event-counters (1)

Examples (4)

Existing (2)

Existing Database Table (1)

Exploring (4)

Exploring Triggers (1)

FAQs (9)

Filtering (4)

Foreign key constraint issues (1)

Foreign key constraints (1)

Functions (14)

GROUP (2)

Guide (3)

Importance (1)

Important points pertaining (1)

Information (1)

Insert data (1)

Insert Multiple Values (1)

Insert Values (1)

Installing phpMyAdmin (1)

Introduction (4)

ISNULL Function (1)

JOIN Order (1)

Joins (3)

Languages (1)

List (1)

Load data (1)

Log Slow Queries (1)

Manage (1)

Managing (2)

Managing Tables (1)

Managing Views (1)

Manipulate (1)

Memory Footprint (1)

Migrating (1)

Modify Columns (1)

Most optimized types (1)

Mytop (1)

Non-ASCII Text (1)

One result set (1)

Open source version through Oracle SQL Dev (1)

Operator (2)

Operators (1)

Optimizing (3)

ORDER (3)

Ordering (1)

Perform sophisticated data (1)

Performance (2)

Pertaining (1)

PHP (3)

PhpMyAdmin (5)

PLSQL (5)

PLSQL Programs (4)

PLSQL Programs Exploring (4)

PLSQL Programs Exploring Control Structures (1)

PLSQL Programs Exploring Cursors (1)

PLSQL Programs Exploring Triggers (1)

Procedures (5)

Queries (3)

Query monitor (1)

Querying (3)

Querying Information (1)

RAND (1)

Refer (1)

Regular expressions (1)

Reports (1)

Restore (2)

Rollback (1)

Rows (1)

Running (1)

Running Queries (1)

Script (1)

Searching capabilities (1)

Security Issues (1)

SELECT (6)

SELECT queries (1)

SELECT statements (2)

Self-Contained Scalar Subquery (1)

Sending Non-ASCII Text (1)

Server Daemon mysqld Administration (1)

Set Theory (1)

Setting up Foreign Keys (1)

Simulating (1)

Simulating foreign key constraints (1)

Single Query (1)

SQL (48)

SQL Aggregate Functions (2)

SQL Date (2)

SQL Date Functions (1)

SQL Developer (4)

SQL Functions (2)

SQL Injection (2)

SQL SELECT Query Statements (1)

SQL Server (21)

SQL Server 2008 R2 (4)

Started (1)

Stored Procedures (3)

String Functions (1)

Subquery (3)

Summarize subsets (1)

Summarize table data (1)

System (2)

Table (14)

Table contents (1)

Table data (2)

Table Manipulation (1)

Tables (7)

Techniques (2)

Time (1)

Top (2)

TOP Option (1)

Topics (1)

Transaction Management (1)

Triggers (6)

Tuning (1)

Tuning Script (1)

Tutorials (1)

Understand SQL Joins (1)

Understanding (2)

UNION operator (1)

Up Foreign Keys (1)

Up User Data (1)

UPDATE (1)

URLs (1)

Usage (4)

Usage examples (1)

Used (5)

User-Driven (1)

User-Driven Querying (1)

VB.NET (2)

Views (3)

Websites (1)

WHERE clause (2)

Wild Cards (1)

Windows ISA logs (1)

Writing (1)

Writing SELECT queries (1)

Weekly Features

Site of the week: photoshopessentials.com

Learn how to do it!

Site of the week: csscreme.com

Learn how to do it!