1.2.
3.
#include <stdio.h>
#include <sqlite3.h>
int main()
{
//1.打开数据库
sqlite3 *mydb = NULL;
sqlite3_open("./database.db",&mydb);
char **result;
char*buf=malloc(100);
fgets(buf,100,stdin);
char *sql = malloc(1024);
snprintf(sql,100,"create table %s;",buf);
int row,column;
sqlite3_get_table(mydb,"create table %s",&result, &row,&column,NULL);
for(int i = 0;i <(row+1)*column;i++)
{
printf("%-18s",result[i]);
if((i+1)%column == 0)
{
printf("\n");
}
}
}