Differences

This shows you the differences between two versions of the page.

--- c:mysql:mysql.h:mysql_errno [2013/02/03 20:19]
127.0.0.1 external edit
+++ c:mysql:mysql.h:mysql_errno [2024/02/16 01:12] (current)
@@ Line 1: / Line 1: @@
 ====== mysql_errno ======
 <code c>
+unsigned int mysql_errno(MYSQL *mysql)
 </code>
 ==== description of mysql_errno ====
-mysql_errno is in work by code-reference.com \\
+returns the error number for the last unsuccessful running function. if the function is successful, it returns 0.
-if you are faster... don't hasitate and add it
+in case of an error the error number and the type of error appears
 <code c>
-no example at the moment
+#include <stdio.h> /* including standard library */
+#include <mysql/mysql.h>
+MYSQL *my;
+int main( void ){
+char host[20];
+char user[20];
+char pass[20];
+my = mysql_init(NULL);
+sprintf(host,"localhost");
+sprintf(user,"username");
+sprintf(pass,"password");
+if (my == NULL ) {
+printf("Cant initalisize MySQL\n");
+return 1;
+}
+if( mysql_real_connect (my,host,user,pass,NULL,0,NULL,0)  == NULL) {
+  printf("Error cant login\n");
+  } else {
+  printf("Login correct\n");
+  }
+mysql_select_db(my, "test");
+mysql_query(my, "SELECT * FROM wrongdb WHERE 1;");
+printf("mysql_errno is %u\n", mysql_errno(my) );
+mysql_close(my);
+return 0;
+}
 </code>
 ===== output of mysql_errno c example =====
-    no example at the moment
+    Login correct
+    mysql_errno is 1146

on the occasion of the current invasion of Russia in Ukraine