<< < 4 5 6 7 8 9 10 11 12 13 14 > >>   ∑:380  Sort:Date

Using Subqueries with the IN Operator in MySQL
How To Use Subqueries with the IN Operator in MySQL? A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you how to u...
2017-09-17, 2552🔥, 0💬

Show the Current Transaction Mode in MySQL
How To Find Out the Current Transaction Mode in MySQL? If you are not sure about your current transaction mode, you can use the "SELECT @@AUTOCOMMIT FROM DUAL" statement to find out as shown in the following tutorial exercise: &gt;\mysql\bin\mysql -u dev -piyf fyi mysql&gt; SELECT @@AUTOCOMM...
2016-10-17, 2552🔥, 0💬

Transaction Roll Back when Session Ended in MySQL
What Happens to the Current Transaction If the Session Is Ended in MySQL? If a session is ended, 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 session is ended....
2017-08-03, 2551🔥, 0💬

What Is Primary key in MySQL
What Is Primary Key in MySQL? A primary key is a single column or multiple columns defined to have unique values that can be used as row identifications.   ⇒ What Is Foreign Key in MySQL ⇐ What Is Row in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials
2017-07-07, 2551🔥, 0💬

What Are DDL Statements in MySQL
What Are DDL Statements in MySQL? DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the definition of an existing data object. DROP - Dropping an exis...
2018-03-10, 2548🔥, 0💬

What Are User Privileges in MySQL
What Are User Privileges in MySQL? MySQL offers many user privileges to control user accesses to different functions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands. ALTER - Allows the user to use ALTER TABLE comma...
2017-12-09, 2545🔥, 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, 2545🔥, 0💬

Memory Usage of the MySQL Server in MySQL
How Much Memory Does the Server Take in MySQL? If you are interested to know how much memory your MySQL server is taking, you can use Windows Task Manager to find out. Try to following this tutorial exercise: Start your MySQL server. Press Ctrl-Alt-Del and click Task Manager. The Task Manager window...
2017-12-04, 2543🔥, 0💬

Rollback the Current Transaction in MySQL
How To Rollback the Current Transaction in MySQL? If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROLLBACK command. It will remove all the database chan...
2016-10-17, 2539🔥, 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, 2538🔥, 0💬

SELECT Statements with JOIN and Subqueries in MySQL
Where to find answers to frequently asked questions on SELECT Statements with JOIN and Subqueries in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SELECT Statements with JOIN and Subqueries in MySQL. Clear answers are provided with tutori...
2017-12-31, 2535🔥, 0💬

What Is InnoDB in MySQL
What Is InnoDB in MySQL? InnoDB is a transaction safe storage engine developed by Innobase Oy (an Oracle company now).   ⇒ What Is BDB in MySQL ⇐ What Is MyISAM in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials
2017-07-03, 2531🔥, 0💬

Viewing User Privileges in MySQL
How To View User Privileges in MySQL? If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userName" command. The following tutorial exercise shows...
2017-08-21, 2530🔥, 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, 2528🔥, 0💬

Create an Index for a Given Table in MySQL
How To Create an Index for a Given Table in MySQL? If you have a table with a lots of rows, and you know that one of the columns will be used often as a search criteria, you can add an index for that column to improve the search performance. To add an index, you can use the "CREATE INDEX" statement ...
2018-02-14, 2527🔥, 0💬

Creating a Test Table in MySQL
How To Create a Testing Table in MySQL? If you want to practice DML statements, like INSERT, UPDATE and DELETE, you should create a testing table. The tutorial exercise shows you a good example: mysql&gt; CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url VARCHAR(80) NOT NULL, notes VARCHAR(102...
2018-01-24, 2527🔥, 0💬

DATABASE() - Name of Current Database
How to obtain the name of the current database using the DATABASE() function? DATABASE() is a MySQL built-in function that returns the name of the current database. For example: USE mysql; Database changed SELECT DATABASE(); -- +------------+ -- | DATABASE() | -- +------------+ -- | mysql | -- +----...
2025-06-18, 2526🔥, 0💬

JSON_TYPE() - Detecting Type of JSON Value
How to detect the type of a JSON (JavaScript Object Notation) value using the JSON_TYPE() function? JSON_TYPE(json) is a MySQL built-in function that returns the data type of a JSON (JavaScript Object Notation) value. For example: SELECT JSON_TYPE('[]'), JSON_TYPE('{}'); -- +-----------------+------...
2025-03-12, 2522🔥, 0💬

What Are DML Statements in MySQL
What Are DML Statements in MySQL? DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. UPDATE - Updating existing rows in database tables . DELETE - Deleting existing r...
2018-01-24, 2522🔥, 0💬

Major Storage Engines Supported in MySQL in MySQL
What Are Storage Engines in MySQL? Storage engines are programs that are integrated into MySQL database management system to manage data tables. MySQL 5.0 supports the following major storage engines: MyISAM Storage Engine - MySQL default storage engine. Based on ISAM database concept. MyISAM is not...
2017-09-12, 2522🔥, 0💬

DML Commands Supported in MySQL
How Many SQL DML Commands Are Supported by "mysql" in MySQL? There are 4 SQL Data Manipulation Language (DML) commands that are supported by "mysql". They are listed below with short descriptions: "INSERT INTO tableName ..." - Inserts new data rows into the specified table. "DELETE FROM tableName .....
2018-02-08, 2521🔥, 0💬

What Is Index in MySQL
What Is Index in MySQL? An index is a single column or multiple columns defined to have values pre-sorted to speed up data retrieval speed.   ⇒ What Is View in MySQL ⇐ What Is Foreign Key in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials
2017-07-07, 2521🔥, 0💬

FORMAT_BYTES() - Formatting Bytes in Readable Units
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function? FORMAT_BYTES(con) is a MySQL built-in function that converts a number of bytes in a human-readable unit of KiB, MiG, GiB, TiB, PiB or EiB. For example: SELECT FORMAT_BYTES(9), FORMAT_BYTES(9*1024), FORMAT_BYT...
2025-09-24, 2519🔥, 0💬

Creating a New Table in MySQL
How To Create a New Table in MySQL? If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR...
2017-10-08, 2518🔥, 0💬

<< < 4 5 6 7 8 9 10 11 12 13 14 > >>   ∑:380  Sort:Date