What is mysql_info() function in PHP?
How does mysql_info() works?
Statement: INSERT [INTO] (tablename) [(fieldnames)] VALUES (values) Returned String: Records: x Duplicates: y Warnings: z Statement: INSERT INTO (tablename) [(fieldnames)] SELECT (statement) Returned String: Records: x Duplicates: y Warnings: z Statement: LOAD DATA INFILE (filename) INTO TABLE (tablename) Returned String: Records: w Deleted: x Skipped: y Warnings: z Statement: ALTER TABLE Returned String: Records: 60 Duplicates: 0 Warnings: 0 Statement: UPDATE (condition) (new value) Returned String: Rows matched: x Changed: y Warnings: z |
<?php //Attempt to connect to the default database server $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")or die ("Could not connect"); //select database mysql_select_db('database');$query = "UPDATE People SET Title = 'Mr' WHERE FirstName='Bill'"; //execute query $result = mysql_query($query);//print mysql_info function result printf("Query Information: %sn", mysql_info()");?> |