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, 1408🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...