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

CREATE, ALTER and DROP Statements in MySQL
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on CREATE, ALTER and DROP Statements in MySQL. Clear answers are provided with tutorial exercises on cr...
2018-03-13, 4798🔥, 0💬

What Is "mysqld" Command in MySQL
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is a tutorial example of invoking "mysqld" with the "--...
2018-06-01, 4766🔥, 0💬

Transaction Committed when START TRANSACTION Executed in MySQL
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a middle of a current transaction, and a START TRANSACTION command is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become...
2016-10-17, 4742🔥, 0💬

Storage Engines: MyISAM, InnoDB and BDB in MySQL
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Storage Engines: MyISAM, InnoDB and BDB in MySQL. Clear explanations and tutorial exercises ar...
2017-09-12, 4683🔥, 0💬

Presenting a Past Time in Hours, Minutes and Seconds in MySQL
How To Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was posted "n hours n minutes and n seconds ago", you can use the TIMEDIFF(NOW(), pastTime) function as shown in the following tutorial exercise: SELECT TIMEDIFF(NOW(), '2006-07-01 04:09:49') FROM DUAL; 06...
2017-12-26, 4591🔥, 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, 4558🔥, 0💬

Getting Help Information from the Server in MySQL
How To Get Help Information from the Server in MySQL? While you are at the "mysql&gt;" prompt, you can get help information from the server by using the "HELP" command. The tutorial exercise below shows sevearal examples: &gt;cd \mysql\bin &gt;mysql -u root mysql&gt; HELP; ... List o...
2018-02-08, 4554🔥, 0💬

COERCIBILITY() - Character Collation Coercibility
How to detect the collation coercibility associated to a given character string using the COERCIBILITY() function? COERCIBILITY(str) is a MySQL built-in function that returns the collation coercibility associated to a given character string. A collation coercibility refers to the coercibility index,...
2025-10-14, 4552🔥, 0💬

ICU_VERSION() - ICU (International Components for Unicode) Version
How to obtain the version number of the ICU (International Components for Unicode) library using the ICU_VERSION() function? ICU_VERSION() is a MySQL built-in function that returns the version number of the ICU (International Components for Unicode) library. For example: SELECT ICU_VERSION(); -- +--...
2025-04-11, 4329🔥, 0💬

What Is ISAM in MySQL
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.   ⇒ What Is MyISAM in MySQL ⇐ What Is Union in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials
2017-07-03, 4282🔥, 0💬

What Is BDB in MySQL
What Is BDB (BerkeleyDB) in MySQL? BDB (BerkeleyDB) is transaction safe storage engine originally developed at U.C. Berkeley. It is now developed by Sleepycat Software, Inc. (an Oracle company now).   ⇒ What Is CSV in MySQL ⇐ What Is InnoDB in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ ...
2017-07-03, 4275🔥, 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, 4271🔥, 0💬

Scope Levels of User Privileges in MySQL
How Many Scope Levels Can User Privileges Apply in MySQL? MySQL supports 5 scope levels a user privilege can be granted: Global Level - A privilege granted at this level applies to all databases on the server. Privileges granted at the global level stored in "mysql.user" table. Database Level - A pr...
2017-12-09, 4267🔥, 0💬

Turning on mysql Extension on the PHP Engine in MySQL
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as "php_mysql.dll" for Windows system. Your PHP binary download package should have "php_mysql.dll" included. No need for another download. But you need to check the PHP configuration file, \php\php.ini,...
2017-07-30, 4249🔥, 0💬

Ways to Get the Current Time in MySQL
How Many Ways to Get the Current Time in MySQL? There are 8 ways to get the current time: SELECT NOW() FROM DUAL; 2006-07-01 10:02:41 SELECT CURRENT_TIME() FROM DUAL; 10:02:58 SELECT SYSDATE() FROM DUAL; 2006-07-01 10:03:21 mysql&gt; SELECT CURRENT_TIMESTAMP() FROM DUAL; 2006-07-01 10:04:03 SELE...
2018-03-13, 4121🔥, 0💬

Locks, Timeouts, and Deadlocks in MySQL
What Are Impacts on Applications from Locks, Timeouts, and DeadLocks in MySQL? If you are using transactions with REPEATABLE READ isolation level and transaction safe storage engines in your applications, data locks, lock timeouts, and dead lock detections will impact your application in a concurren...
2017-07-21, 3997🔥, 0💬

Dispaly Part Time in Days, Hours and Minutes in MySQL
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the TIMEDIFF() SQL function. Note that the TIMEDIFF() function can only handle time range within 839 hou...
2017-06-23, 3980🔥, 0💬

JSON_SET() - Inserting/updating JSON Child Members
How to insert or update child members of a JSON (JavaScript Object Notation) value using the JSON_SET() function? JSON_SET(json, path1, val1, path2, val2, ...) is a MySQL built-in function that inserts child members of a JSON value at given new locations, and replaces child numbers at given existing...
2025-03-12, 3919🔥, 0💬

Change Transaction Isolation Level in MySQL
How To View and Change the Current Transaction Isolation Level in MySQL? If you want to view or change the current transaction isolation level, you can use the following commands: SELECT @@TX_ISOLATION FROM DUAL; -- Viewing the current transaction isolation level. SET TRANSACTION ISOLATION LEVEL lev...
2017-08-08, 3888🔥, 0💬

Introduction to Date and Time Handling in MySQL
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Introduction to Date and Time Handling in MySQL. Clear answers are provided with tutorial exerc...
2021-08-04, 3856🔥, 2💬

💬 2021-03-13 Strain John: Hey, u gave us good information. It is easy to understand for everyone and also having good content. I appreciated your afforts ...

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, 3848🔥, 0💬

Calculating the Difference between Two Time Values in MySQL
How To Calculate the Difference between Two Time Values in MySQL? If you have two time values, and you want to know the time difference between them, you can use the TIMEDIFF(time1, time2) function as shown below: SELECT TIMEDIFF(TIME('19:26:50'), TIME('09:26:50')) FROM DUAL; 10:00:00 SELECT TIMEDIF...
2017-12-26, 3813🔥, 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, 3807🔥, 0💬

UPDATE with Subquery Returning No Rows in MySQL
What Happens If the UPDATE Subquery Returns No Rows in MySQL? If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, MySQL will provide a NULL value to the SET clause. The tutorial exercise below shows you a good exampl...
2018-01-08, 3777🔥, 0💬

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