Collections:
Execute SQL Statements in MySQL
How To Execute a SQL Statement in MySQL?
✍: FYIcenter.com
You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status:
Here is a good example of running a SQL statement with the mysql_query() function:
<?php include "mysql_connection.php"; $sql = 'SELECT SYSDATE() FROM DUAL'; $res = mysql_query($sql, $con); $row = mysql_fetch_array($res); print("Database current time: ". $row[0] ."\n"); mysql_close($con); ?>
If you run this script, you will get something like this:
Database current time: 2006-07-01 21:34:57
⇒ Managing Tables and Running Queries with PHP for MySQL
⇐ Selecting Other User's Database in MySQL
2017-10-23, 1493🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...