sqlite触发器一例

int column_names_printed = 0;
void print_row(int n_values, char** values)
{
    int i;
    for (i = 0; i < n_values; ++i) {
        printf("%10s", values[i]);
    }
    printf("\n");
}
int print_result(void* data, int n_columns, char** column_values, char** column_names)
{
    if (!column_names_printed) {
        print_row(n_columns, column_names);
        column_names_printed = 1;
    }
  
    print_row(n_columns, column_values);
 
   return 0;
}
int sqlite()
{
    sqlite3 *db=NULL;
    char *errMsg = NULL;
    int rc;
  
    rc = sqlite3_open("test.db", &db);
    if( rc ){
        fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
        sqlite3_close(db);
        exit(1);
    }
    else printf("open test.db successfully!\n");
  
    rc = sqlite3_exec(db, "BEGIN TRANSACTION;", NULL, NULL, NULL);
    rc = sqlite3_exec(db, "CREATE TABLE students(number varchar(10), name varchar(10), \
                           sex varchar(6), age varchar(2));", NULL, NULL, NULL);
    rc = sqlite3_exec(db, "INSERT INTO students VALUES('00001', 'Mary', 'female', '15');\
                         &