1 2 3 4 5 6 > >>   ∑:316  Sort:Date

MySQL Database Tutorials
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for MySQL DBA and MySQL database application developers. Clear explanations and sample scripts provided can be used as learning tutorials or interview preparation guides. It doesn't matter whether you are...
2016-10-16, 17348🔥, 0💬

Breaking Query Output into Pages in MySQL
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, and you don't want to present all of them to your users on a single page. You can break output into multiple pages, and only present 10 rows per page like what Google Website is doing. To do this, you n...
2022-10-01, 14925🔥, 1💬

💬 2022-10-01 David: MySQL is the best!

Changing Your Own Password in MySQL
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of your own user account, you should use your user account connect to the server "mysql" first. You should then use the "SET PASSWORD ..." command to change the password of the current user account. The...
2021-02-10, 7374🔥, 1💬

Error: Subquery Returns More than 1 Row in MySQL
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, MySQL server will give you an error message. To test this out, ...
2018-01-08, 7054🔥, 0💬

Starting MySQL Server in MySQL
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" program in a command window as shown in the following tutorial: >cd \mysql\bin >mysqld "mysqld" will run quietly without printing any message in you command window. So you will see nothi...
2018-06-12, 6722🔥, 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, 6715🔥, 0💬

Error: Deadlock Found When Trying to Get Lock in MySQL
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives the "Deadlock found when trying to get lock" - ERROR 1213, MySQL server automatically terminates your transaction and rolls back your data changes of the entire transaction. This is why the error messag...
2017-07-21, 5427🔥, 0💬

Installing PHP on Windows in MySQL
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems is to: Go to http://www.php.net, which is the official Web site for PHP. Download PHP binary version for Windows in ZIP format. Unzip the downloaded file into a directory. You are done. No need to run...
2017-07-30, 5008🔥, 0💬

Fixing INSERT Command Denied Error in MySQL
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT command denied" error is that your user account does not have the INSERT privilege on the table or database. To resolve this error, you need to ask your MySQL DBA to grant you the right privilege. Your DBA ...
2017-10-08, 4651🔥, 0💬

Verifying PHP Installation in MySQL
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\php\php -v" command to check the Command ...
2017-07-30, 4506🔥, 0💬

Error: Lock Wait Timeout Exceeded in MySQL
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives the "Lock wait timeout exceeded" - ERROR 1205, MySQL server automatically terminates your transaction and rolls back your data changes of the entire transaction. This is why the error messages tells you...
2017-04-28, 3926🔥, 0💬

Transaction Management: Commit or Rollback in MySQL
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Transaction Management: Commit or Rollback in MySQL. Clear answers are provided with tutori...
2017-08-08, 3769🔥, 0💬

PHP Connections and Query Execution for MySQL
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on PHP Connections and Query Execution in MySQL. Clear explanations and tutorial exercises are provi...
2017-11-25, 3488🔥, 0💬

INSERT, UPDATE and DELETE Statements in MySQL
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on INSERT, UPDATE and DELETE Statements in MySQL. Clear answers are provided with tutorial exercises...
2018-01-24, 3417🔥, 0💬

Date and Time Functions in MySQL
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time values: ADDDATE(date, INTERVAL expr unit) - Adding days to a date. Same as DATE_ADD(). ADDTIME(time1, time2) - Adding two time values together. CURDATE() - Returning the current date. Same as CURRENT_DATE...
2018-03-13, 3368🔥, 0💬

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, 3118🔥, 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, 3103🔥, 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, 3058🔥, 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, 3050🔥, 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, 3030🔥, 0💬

Converting Numeric Values to Character Strings in MySQL
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to character strings by using the CAST(value AS CHAR) function as shown in the following examples: SELECT CAST(4123.45700 AS CHAR) FROM DUAL; 4123.45700 -- How to get rid of the last 2 '0's? SELECT CAST(4.123...
2018-03-28, 3019🔥, 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, 2827🔥, 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, 2799🔥, 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> SELECT CURRENT_TIMESTAMP() FROM DUAL; 2006-07-01 10:04:03 SELE...
2018-03-13, 2770🔥, 0💬

1 2 3 4 5 6 > >>   ∑:316  Sort:Date