MySQL FAQs Site Map

Client Server Commands
What are MySQL client programs?
What are MySQL non-client utilities?
What is mysql client program and how to run it?
How to connect mysql client program with MySQL Server from the command line?
What is difference among mysqld, mysqladmin, mysqldump, mysqlimport and mysqlcheck?
How to check version of the running MySQL Server?
What is --compress or -C?
What is difference among --defaults-file, --defaults-extra-file and --no-defaults?
What is difference between \g and \G characters in mysql client program?
How to execute statement(s) directly from the command line?
How to cancel the statement in mysql client program?
What is difference between Interactive Mode and Batch Mode of mysql client?
How to run SQL script files in mysql client?
How to execute the entire script file regardless of errors occurrence?
What does STATUS command in mysql client?
How to know MySQL system variables?
What does MySQL use its port by default?
What does --safe-updates option in mysql?
What is sql mode in MySQL and how can we set it?
How to check the MySQL running mode?
Database Structure
How to create database?
How to alter or drop a database?
How to get database metadata in MySQL?
How to get all existing tables in the MySQL database?
How to rename existing database in MySQL?
What is limit on the maximum number of tables allowed in MySQL?
Tables
How to get table metadata?
How to specify multiple alterations for a table?
How to renaming a table in MySQL?
How to describe a table in MySQL?
How to create table in MySQL?
How to create table based on existing tables?
What is temporary table and how to create it in MySQL?
How to add new column into an existing table in MySQL?
How to drop a column from the existing table?
How to add a new AUTO_INCREMENT field to an existing table?
How to get columns of an existing table in MySQL?
How to drop all existing tables in one go?
How to change data type of an existing column?
How to delete table records?
How to set AUTO_INCREMENT value other than 1 in MySQL?
How to get copy of table structure in MySQL using query?
How to get constraints or keys of the existing table?
Data Types
What is BIT Data Type in MySQL?
What are DATE, TIME, DATETIME and YEAR Data Types in MySQL?
What are Temporal Data Types in MySQL?
How to reformat Time values in MySQL?
How to reformat date values in MySQL?
What are string data types in MySQL 5?
What is difference between CHAR AND VARCHAR data types?
What are ENUM and SET Data Types in MySQL?
What is difference between binary and non-binary string data types?
What is fixed point and decimal data type in MySQL?
What are float data types in MySQL?
What are integer data types in MySQL?
What is MySQL default character set?
What are numeric data types in MySQL?
What is TIMESTAMP Data Type in MySQL?
Table Types or Storage Engines
How to get storage engines available on MySQL server?
What is default table type of MySQL?
How to change the default storage engine of MySQL?
How to convert a table from one type to another in MySQL?
What is the fastest storage engine in MySQL?
What are transaction-safe tables and not transaction-safe tables in MySQL?
MyISAM Engine
What are MyISAM table characteristics?
What are MyISAM formats in MySQL?
How to create myisam table in MySQL?
How MySQL myisam table is stored on disk?
Merge Engine
When should we use merge engine?
InnoDB Engine
When should we use innodb engine?
How to create innodb table in MySQL?
How to install Innodb Engine?
How to uninstall Innodb Engine?
How to rename a database with full Innodb Tables?
How to take data back up for InnoDB tables like copy paste?
Memory Engine
When should we use memory engine?
How to create memory table with hashed index?
How to create memory table with btree index?
BDB Engine
Federated Engine
How to create federated table in MySQL?
Archive Engine
CSV Storage
Blackhole Engine
Example Engine
Indexes
How to get existing indexes of the table in MySQL?
What is index terminology or concept and how does index work in MySQL?
How many types of indexes or keys are in MySQL?
What is single column index or key in MySQL?
What is multi column index or key in MySQL?
What is partial-column and prefixed-column index or key in MySQL?
When does multi column index come into use in MySQL?
What are best practices to pick columns to index?
What are advantages and disadvantages of indexes in MySQL?
How to remove or drop indexes in MySQL?
Is it possible to apply more than one keys on a single column?
What is foreign key in MySQL?
Primary Key Indexes
How to create primary key index in MySQL?
How to create multi column primary key index in MySQL?
Unique Key or Index
How to create unique key or index in MySQL?
How to create multi column unique key or index in MySQL?
Normal Indexes or Keys
How to create normal index or key in MySQL?
How to create multi column normal index or key in MySQL?
Full Text Indexes
Main features and basic information about full-text search
What are full-text restrictions in MySQL?
On what data types fulltext index can be created?
How to create full-text index in MySQL?
How to create multi columns full-text index in MySQL?
What are natural language and boolean and query expansion full-text searches?
How to use boolean full-text search in MySQL?
How to use full-text searches with query expansion in MySQL?
How to use natural language full-text search in MySQL?
What are stopwords in MySQL?
SQL Statements
What does alias means in MySQL?
What does SQL Expressions mean in MySQL?
How to use numeric expressions in MySQL?
How to use string expressions in MySQL?
How to manage case sensitivity in string comparisons?
How to use LIKE pattern-matching operator?
How to use date or temporal expressions?
What does NULL value mean in MySQL?
How to use comments in SQL statements?
How to validate user login in case sensitive manner?
What is difference between delete and truncate statements of MySQL?
Select Statement
How to use SELECT statement to retrieve data?
How does DISTINCT work in MySQL?
How to use ORDER BY to sort query results?
How to use LIMIT clause in MySQL?
How to get aggregate results in MySQL?
How the select query is executed?
How can I limit the number of rows I want to fetch from my MySQL table?
Insert Statement
Update Statement
Replace Statement
Table Joins
What is difference between ON Clause and WHERE Clause?
How to delete or update records of multiple tables in one go?
How to get record from first table joining with second table without any active record between them?
Funtions and Operators
What is MySQL date format and its specifiers?
How to get comma separated all values in a single row against each ID?
How to concat values in MySQL?
How to convert time zone in MySQL?
What are comparison functions in MySQL
How to set conditions on query data with CASE construct?
How to set control conditions on query data with IF funtion?
What are mathematical functions in MySQL?
How are aggregate functions in MySQL?
What are string functions in MySQL?
What are temporal or date time functions in MySQL?
What are NULL value related functions in MySQL?
How does union work in MySQL?
Tricky Select Queries
How to do numeric sorting within a string field in MySQL?
How to find the books which have authors with more than one book in the table?
An important trick to speed up select query.
How to retrieve one child row against each parent id?
How to skip repeating values from the query results?
How to get parent table child table and grandchild table aggregates in MySQL?
How to move table from one to another MySQL database?
How to get last top records in asceding order?
How to find duplicate records from a table in MySQL?
How to take data back up of single table?
How to count the number of rows containing APOSTROPHE in MySQL?
How to compare data of two tables of two different databases in MySQL?
How to retreive multiple records without a reference table?
Speed Up Queries
What is better query to update a table?
How to get all dates between two dates?
How to speed up multi table based delete query?
Why my update query works slow in MySQL?
What is query cache in MySQL?
What is table cache in MySQL?
Data Back Up
How to create duplicate table in MySQL?
How can I restore MySQL database?
Import Data
How to use mysqlimport client?
How to use LOAD DATA INFILE statement?
How to import data from Microsoft Excel file into table with LOAD DATA INFILE statement?
How to import data from text file into table with LOAD DATA INFILE statement?
Export Data
How to use SELECT INTO OUTFILE statement to export data?
How to export table data to text file with SELECT INTO OUTFILE statement?
How to export table data to Microsoft Excel with SELECT INTO OUTFILE statement?
How to use mysqldump to export data?
How to take dump of database without its data?
How to take dump of the database?
General Questions
How can I detect that MySQL is already installed?
How does MySQL manage case sensitivity of identifiers?
Why values with spaces do not come into search result?
What is History of MySQL?
How to manage Time Zone in MySQL?
What are reserved words in MySQL?
Can I use FIELD CONSTRAINTS on MySQL?
Maximum number of columns in a table
What is prepared statement in MySQL?
What are MySQL connectors or client interfaces?
Errors
Why I see an error when I EXPLAIN for update query?
1264 Out of range value adjusted for column
ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet
ERROR 1064 (42000): You have an error in your SQL syntax
1093 You can not specify target table comments for update in FROM clause
1048 Column cannot be null
1191-Cant find FULLTEXT index matching the column list

Top of Page

About Site	About FAQs	Affiliates and Sponsors
- Site Map - Bookmark Us - Recommend this Site to Your Friend - Contact Us	- Recently Added FAQs	- Sulata iSoft - Limitless Solutions - careermidway.com - phpfaqs.net - Learn PHP through real FAQs
© 2007 - 2010 www.mysqlfaqs.net All rights reserved. The site is owned and operated by Mr. Javed Bhatti - Pakistan.