· 7 years ago · Dec 06, 2018, 11:58 AM
1#include <stdio.h>
2#include <sqlite3.h>
3
4int main( void )
5{
6 sqlite3 *db;
7 char *query;
8 struct sqlite3_stmt *stmt;
9
10 sqlite3_open( "./boop.sq3", &db );
11 sqlite3_exec( db, "create table if not exists abc (num int)", NULL, NULL, NULL );
12
13 query = sqlite3_mprintf( "insert into abc values (%i)", 123 );
14 printf( "query: %s\n", query );
15 sqlite3_exec( db, query, NULL, NULL, NULL );
16 sqlite3_free( query );
17
18 sqlite3_close( db );
19
20 return 0;
21}