<< < 1 2 3 4 5 6 7 8 > >>   Sort: Date

Show All Indexes of a given Table in MySQL
How To Get a List of Indexes of a Given Table in MySQL? If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutorial script below shows you a nice example: mysql&gt; SHOW ...
2018-02-14, 687👍, 0💬

Installing MySQL Server in MySQL
How To Install MySQL Server in MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer very easily. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql/5.0.html.Select th...
2018-06-12, 686👍, 0💬

Tables Using MyISAM Storage Engine in MySQL
How To Create a New Table Using MyISAM Storage Engine in MySQL? MyISAM storage engine is based on the ISAM (Indexed Sequential Access Method) concept, which was first developed at IBM to store and retrieve data on secondary storage systems like tapes. MyISAM storage engine offers fast data storage a...
2017-09-12, 683👍, 0💬

Build WHERE Criteria with Web Form Data in MySQL
How To Build WHERE Criteria with Web Form Search Fields in MySQL? If your PHP script is linked to a Web form which takes search key words for multiple data fields. For example, your Web form asks your visitor to search for Website links with a URL search field, a Website title search field, a descri...
2017-06-23, 683👍, 0💬

Dump a Table to a File with "mysqldump" Command in MySQL
How To Dump a Table to a File with "mysqldump" in MySQL? If you want to dump all rows in a table from the server to a file, you can use "mysqldump" with the "-f fileName" option as show in the following tutorial exercise: &gt;cd \mysql\bin &gt;mysqldump -u root -r \temp\links.txt test links ...
2018-05-19, 682👍, 0💬

Verify the Version of MySQL Server in MySQL
How Do You Know the Version of Your MySQL Server in MySQL? If you want to know the version number of your MySQL server, you can use the "mysqladmin" program in a command window as shown in the following tutorial: &gt;cd \mysql\bin &gt;mysqladmin -u root version mysqladmin Ver 8.41 Distrib 5....
2018-06-06, 680👍, 0💬

Tables Using InnoDB Storage Engine in MySQL
How To Create a New Table Using the InnoDB Storage Engine in MySQL? InnoDB storage engine was developed by Innobase Oy, which is an Oracle company now. InnoDB is transaction safe, and has been used by a number of large Websites, like Slashdot.org. InnoDB is not the default storage engine. You need t...
2017-09-01, 680👍, 0💬

Omitting Columns in INSERT Statements in MySQL
How To Omit Columns with Default Values in INSERT Statement in MySQL? If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a column...
2018-01-16, 679👍, 0💬

Read Consistency Support in MySQL in MySQL
How Does MySQL Handle Read Consistency in MySQL? Read consistency is a concept that describes how consistent the output will be on two subsequent read operations. A read operation is usually a stand alone SELECT statement or a SELECT subquery in a parent statement. A database server can support up t...
2017-08-03, 679👍, 0💬

What Is Row in MySQL
What Is Row in MySQL? A row is a unit of data with related data items stored as one item in one column in a table.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-15, 677👍, 0💬

Show Server Status with "mysqladmin" in MySQL
How To Check Server Status with "mysqladmin" in MySQL? If you want to check the server status by with "mysqladmin", you can following this tutorial example: &gt;cd \mysql\bin &gt;mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl...
2018-06-01, 676👍, 0💬

What Is a Subquery in MySQL
What Is a Subquery in MySQL? A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The output of the subquery will be used in the final evalu...
2017-09-17, 676👍, 0💬

Shutdown the Server with "mysqladmin" Command in MySQL
How To Shut Down the Server with "mysqladmin" in MySQL? If you want to shut down the server with "mysqladmin", you can use the command "mysqladmin shutdown" as shown in the following tutorial example: &gt;cd \mysql\bin &gt;mysqladmin -u root shutdown If this command returns no messages, your...
2018-06-01, 674👍, 0💬

Character String Data Types in MySQL
What Are Character String Data Types in MySQL? MySQL supports the following string data types: CHAR(n) same as CHARACTER(n) - Fixed width and " " padded characters strings. Default character set is ASCII. NCHAR(n) same as NATIONAL CHARACTER(n) - Fixed width and " " padded character strings with UTF8...
2018-04-12, 674👍, 0💬

What Is View in MySQL
What Is View in MySQL? A view is a logical table defined by a query statement.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-07, 673👍, 0💬

Non-Standard SQL Commands in MySQL
What Are the Non-Standard SQL Commands Supported by "mysql" in MySQL? There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands: "SHOW infoName" - Shows basic information of based on the specified information name. "SHOW infoName" - Sho...
2018-02-08, 672👍, 0💬

Backup Tables by Copying MyISAM Files in MySQL
How To Backup Tables by Copying MyISAM Table Files in MySQL? To easiest way to backup MyISAM tables is to copy the data files to a backup directory. But this is not the recommended way to do backups. Read the backup FAQ collections for more details. The following tutorial exercise shows you how to a...
2017-09-01, 672👍, 0💬

Query Multiple Tables Jointly in MySQL
How To Query Multiple Tables Jointly in MySQL? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, and ...
2017-06-23, 672👍, 0💬

Transaction Roll Back when Session Killed in MySQL
What Happens to the Current Transaction If the Session Is Killed in MySQL? If a session is killed by the DBA, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be removed. This is called an implicit rollback when sess...
2017-08-03, 671👍, 0💬

What Is MySQL
What Is MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-21, 671👍, 0💬

Looping through Query Output Rows in MySQL
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and loop through the returning rows is to run the SELECT statement with the mysql_query() function, catch the returning object as a result set, and loop through the result with the mysql_fetch_assoc() func...
2017-06-28, 671👍, 0💬

What Is "mysql" Command in MySQL
What Is "mysql" in MySQL? "mysql" is a command-line interface for end users to manage user data objects. You can use "mysql" to run any standard SQL statements against the server. For example, you use the following SQL statements to manage tables and table rows: "CREATE TABLE links (name VARCHAR(80)...
2018-05-19, 669👍, 0💬

SELECT Query Statements with GROUP BY in MySQL
Where to find answers to frequently asked questions on SELECT Query Statements with GROUP BY in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team SELECT Query Statements with GROUP BY in MySQL. Clear answers are provided with tutorial exercises ...
2017-11-05, 669👍, 0💬

Giving User Read-only Access in MySQL
How To Give a User Read-Only Access to a Database in MySQL? If you want give a user read-only access to a database, you can grant to him/her only the "SELECT" privilege, so that he/she can not run any DDL statements, and any INSERT, UPDATE, or DELETE statements. The tutorial exercise gives you a goo...
2017-08-21, 669👍, 0💬

<< < 1 2 3 4 5 6 7 8 > >>   Sort: Date