This shows you the differences between two versions of the page.
|
c:mysql:mysql.h:mysql_get_server_version [2013/02/03 20:19] 127.0.0.1 external edit |
c:mysql:mysql.h:mysql_get_server_version [2024/02/16 01:12] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== mysql_get_server_version ====== | ====== mysql_get_server_version ====== | ||
| <code c> | <code c> | ||
| + | unsigned long mysql_get_server_version(MYSQL *mysql) | ||
| </code> | </code> | ||
| ==== description of mysql_get_server_version ==== | ==== description of mysql_get_server_version ==== | ||
| - | mysql_get_server_version is in work by code-reference.com \\ | + | mysql_get_server_version() returns the current version of your mysql client usualy returns the number in the following format XXYYZZ |
| - | if you are faster... don't hasitate and add it | + | XX mainversion\\ |
| + | YY release level\\ | ||
| + | ZZ current version number\\ | ||
| + | compile with gcc mysql_get_server_version.c -o mysql_get_server_version `mysql_config –cflags –libs` -Wall | ||
| <code c> | <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,"user"); | ||
| + | sprintf(pass,"pass"); | ||
| + | |||
| + | 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"); | ||
| + | } | ||
| + | |||
| + | |||
| + | printf("Server information: %li\n", mysql_get_server_version(my)); | ||
| + | |||
| + | mysql_close(my); | ||
| + | return 0; | ||
| + | } | ||
| </code> | </code> | ||
| + | |||
| + | |||
| ===== output of mysql_get_server_version c example ===== | ===== output of mysql_get_server_version c example ===== | ||
| - | no example at the moment | + | Login correct |
| + | Server Version: 50520 | ||