# tx510_sqlite3_demo

**Repository Path**: yocop/tx510_sqlite3_demo

## Basic Information

- **Project Name**: tx510_sqlite3_demo
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-08-16
- **Last Updated**: 2024-07-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 概述

`sqlite3 demo ` 是一个简单的sqilte3使用demo
# 编译

```bash
make clean; make
```

# 启动

## 使用gdb load功能调试

### 初始化ddr

```bash
csky-abiv2-elf-gdb TX216_EVB_Bootldr_QSPI_cpu400_aie360_ddr800.elf -x ck804_ddr_init.gdbinit
```
### 启动程序
```bash
csky-abiv2-elf-gdb yoc.elf 
```

## 使用烧写固件方法调试

### 烧写

```
make flash // 烧写prim分区
make flashall //烧写所有分区
```

烧写成功后重新上电即可，上电后出现打印 “sqlite test ok”表示sqlite已正在运行



```
[   0.091]<I>INIT Build:Aug  6 2021,16:00:08
[   0.094]<D>app 
[   0.096]<I>app ======sqlite demo start======
[   0.106]<I>app 65, rc = 1, table may be exist already.
values[0] = data_19:51:15
[   0.534]<I>app sqlite test ok
```

# 使用示例

使用cli 命令调试sqlite，命令格式为sql+“标准sql语法”

- create表单

```
sql "create table test(ID INTEDER, name TEXT, age INTEDER)"
```

- insert数据

```
sql "insert into test(age) values(34)"
```

- 查询数据

```
sql "select * from test"
```

- 删除数据

```
sql "delete from test"
```