Collections:
Retrieving Execution Error Message in MySQL
How To Get MySQL Statement Execution Errors in MySQL?
✍: FYIcenter.com
When you execute a MySQL statement with mysql_query(), and the statement failed, mysql_query() will return the Boolean value FALSE. This is good enough to tell that there is something wrong with that statement. But if you want to know more about the cause of the failure, you can use mysql_errno() and mysql_error() get the error number and error message. The tutorial exercise below shows you an improved version of the previous PHP script:
<?php $con = mysql_connect('localhost:8888', 'guest', 'pub'); $sql = 'CREATE DATABASE fyicenter'; if (mysql_query($sql, $con)) { print("Database fyicenter created.\n"); } else { print("Database creation failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
Database creation failed with error: 1044: Access denied for user 'guest'@'%' to database 'fyicenter'
⇒ Deleting an Existing Database in MySQL
⇐ Failed to Create a Database in MySQL
2017-10-23, 1487🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...