Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <stdio.h>
- #include <stdlib.h>
- #include </usr/include/mysql/mysql.h>
- int main(void) {
- MYSQL *conn;
- MYSQL_RES *res;
- MYSQL_ROW row;
- unsigned long *lengths;
- /* Change me */
- char *server = "localhost";
- char *user = "perdition";
- char *password = "123456";
- char *database = "perdition";
- conn = mysql_init(NULL);
- /* Connect to database */
- if (!mysql_real_connect(conn, server,
- user, password, database, 0, NULL, 0)) {
- fprintf(stderr, "%s\n", mysql_error(conn));
- exit(1);
- }
- /* send SQL query */
- if (mysql_query(conn, "select keyword from replace_keyword")) {
- fprintf(stderr, "%s\n", mysql_error(conn));
- exit(1);
- }
- res = mysql_use_result(conn);
- //Get length result
- lengths = mysql_fetch_lengths(conn);
- printf ("%s \n", lengths);
- char** arrayString;
- arrayString = (char**)malloc(lengths * sizeof(char*));
- for (int i = 0; i < lengths; i++) {
- arrayString[i] = (char**)malloc(lengths * sizeof(char*));
- }
- /* output table name */
- printf("MySQL Tables in mysql database:\n");
- while ((row = mysql_fetch_row(res)) != NULL)
- printf("%s \n", row[0]);
- /* close connection */
- mysql_free_result(res);
- mysql_close(conn);
- return 0;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement