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