Simple MySQL database access using C language

Simple MySQL database access using C language

Unlike Oracle, MYSQL databases do not support embedded SQL languages.

However, it provides powerful C and C ++ support APIs. The C language API is in part 1 of the Reference Manual, and is independent of other parts except the reference manual of more than 25th pages.

MySQL ++ is a MySQL API for C ++. Warren Young is responsible for the project. For more information, visit http://www.mysql.com/products/mysql /.

Of course, mysql seems to be the most widely used php scripting language, apache, used together as the website's back-end database service program, this has done a lot.

At the same time, I am a C programmer. I always want to try something with c. I have been busy preparing for the military transfer exam these days,

Just a little spare time. By the way, I will review the access to the c and mysql databases.

The runtime environment is SunOS x4100 5.10 Generic_118855-33 i86pc i386 i86pc; the compiler is gcc, plus Llibmysqlclient library.

1. # Include<Stdio. h>
2. # Include<String. h>
3. # Include<Mysql. h>
4. # Include<Stdlib. h>
5. Main ()
6. {
7. MYSQL * conn;
8. MYSQL_RES * res;
9. MYSQL_ROW row;
10. Char *Server="Mysql";
11. Char *User="Huzia";
12. Char *Password="CjrIwo";/**/
13. Char *Database="Huzia";
14. Conn=Mysql_init(NULL );
16. /* Connect to database */
17. If (! Mysql_real_connect (conn, server,
18. User, password, database, 0, NULL, 0 )){
19. Fprintf (stderr, "% s \ n", mysql_error (conn ));
20. Exit (1 );
21. }
23. /* Send SQL query */
24. If (mysql_query (conn, "show tables ")){
25. Fprintf (stderr, "% s \ n", mysql_error (conn ));
26. Exit (1 );
27. }
29. Res=Mysql_use_result(Conn );
30. /* Output table name */
31. Printf ("MySQL Tables in mysql database: \ n ");
32. While ((Row=Mysql_fetch_row(Res ))! = NULL)
33. Printf ("% s \ n", row [0]);
35. /* Close connection */
36. Mysql_free_result (res );
37. Mysql_close (conn );
38. }

Run successfully.