This is a demo for sqlite3.

Related tags

Database Sqlite3Demo
Overview

说明

This is a demo for sqlite3.

sqlite3 基础知识

sqlite3 命令分两类

系统命令 以 . 开头的命令

.q 退出sqlite3命令模式

.open 创建一个数据库

.databases 列出数据库

.schema 列出表结构

.tables 列出数据库中的表

.help帮助命令

sql命令 以 分号 ; 结尾的命令

增删改查请参考代码

使用方式

sudo apt install libsqlite3-dev

sudo apt install sqlite3

创建数据库

sqlite3

.open userinfo.db

[email protected]:/media/uthuqinghong/EEECE1A7ECE169F3/13.sqlite/src$ sqlite3

SQLite version 3.27.2 2019-02-25 16:06:06

Enter ".help" for usage hints.

Connected to a transient in-memory database.

Use ".open FILENAME" to reopen on a persistent database.

sqlite> .open userinfo.db

sqlite> .tables

student

sqlite> .databases

main: /media/uthuqinghong/EEECE1A7ECE169F3/13.sqlite/src/userinfo.db

sqlite> .schema

CREATE TABLE student( ID INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(32) NOT NULL, sex CHAR(10), score INTEGER );

CREATE TABLE sqlite_sequence(name,seq);

sqlite> select * from student

...> ;

1|zhangsan|男|78

2|lili|女|80

3|wangwu|女|81

g++ main.cpp -g -I/usr/include -lsqlite3 -o main

运行

./main

参考文档

https://www.runoob.com/sqlite/sqlite-autoincrement.html

Owner
流浪小兵
流浪小兵
SQLiteC++ (SQLiteCpp) is a smart and easy to use C++ SQLite3 wrapper.

SQLiteC++ SQLiteC++ (SQLiteCpp) is a smart and easy to use C++ SQLite3 wrapper. About SQLiteC++: SQLiteC++ offers an encapsulation around the native C

Sébastien Rombauts 1.3k Dec 2, 2021
This is a demo for sqlite3.

说明 This is a demo for sqlite3. sqlite3 基础知识 sqlite3 命令分两类 系统命令 以 . 开头的命令 .q 退出sqlite3命令模式 .open 创建一个数据库 .databases 列出数据库 .schema 列出表结构 .tables 列出数据库中的

流浪小兵 1 Nov 24, 2021
This is a openGL cube demo program. It was made as a tech demo using PVR_PSP2 Driver layer GPU libraries.

OpenGL Cube Demo using PVR_PSP2 Driver layer GPU libraries This is a openGL cube demo program. It was made as a tech demo using PVR_PSP2 Driver layer

David Cantu 5 Oct 31, 2021
An Sqlite3 Elixir library

Exqlite An SQLite3 library with an Ecto adapter implementation. Caveats When using the Ecto adapter, all prepared statements are cached using an LRU c

Matthew Johnston 84 Dec 6, 2021
An SQLite3 driver for Elixir

Exqlite An Elixir SQLite3 library. If you are looking for the Ecto adapater, take a look at the Ecto SQLite3 library. Documentation: https://hexdocs.p

elixir-sqlite 83 Dec 4, 2021
DOS CMD line build of a current SQLite3

DOSQLite This is a DOS/32 build of the command line tool for SQLite 3 based on sqlite-amalgamation-3340100. It was built using DJGPP like my other pro

null 7 Sep 26, 2021
An extra-lightweight Ruby gem for working with SQLite3 databases

Extralite Extralite is an extra-lightweight SQLite3 wrapper for Ruby. It provides a single class with a minimal set of methods to interact with an SQL

Digital Fabric 33 Oct 31, 2021
SQLiteC++ (SQLiteCpp) is a smart and easy to use C++ SQLite3 wrapper.

SQLiteC++ SQLiteC++ (SQLiteCpp) is a smart and easy to use C++ SQLite3 wrapper. About SQLiteC++: SQLiteC++ offers an encapsulation around the native C

Sébastien Rombauts 1.3k Dec 2, 2021
A collecton of generic reference counted data structures, tools to create compatible C style classes, and demo applications

The Offbrand library is a collection of reference counted generic data structures written in C for C. The library includes bash scripts to assist in t

Tyler Heck 81 Jul 22, 2021
2D mesh deformation interactive demo

2D mesh deformation interactive demo

Dmitry V. Sokolov 16 Nov 14, 2021
OpenGL Demo: Simulating Ocean Waves with FFT

OceanFFT Realistic ocean wave simulation, primarily based on J. Tessendorf's paper, using OpenGL compute shaders. Checkout the demo video here. In the

Achal Pandey 53 Nov 18, 2021
A PlayStation® Portable™ demo

Suicide Barbie by The Black Lotus A PlayStation® Portable™ demo Release History Source code (MIT licensed) released December 31st, 2020. OE/M33 'slim'

null 42 Sep 28, 2021
This is a fork of prboom+ with extra tooling for demo recording and playback, with a focus on speedrunning.

dsda-doom v0.15.1 This is a fork of prboom+ with extra tooling for demo recording and playback, with a focus on speedrunning. Heretic Support (beta) D

Ryan Krafnick 54 Nov 27, 2021
[WIP] Demo of a minimal but functional Dawn-based WebGPU client and server

dawn client-server example The goal of this demo is to create a minimal but functional Dawn-based WebGPU client and server with the following traits:

Rasmus 15 Nov 20, 2021
Demo exploit code for CVE-2020-27904, a tfp0 bug.

xattr-oob-swap CVE-2020-27904: a tfp0 bug for macOS 10.15.x and below. Demo exploit code for my talk at BlackHat ASIA 2021. The vulnerability has been

null 64 Sep 16, 2021
The demo projects for Allwinner D1 SBC

D1 Demo The demo projects for Allwinner D1 SBC hello project show the basic native compiling on D1 SBC. vector example cross compiling RISC-V Vector c

RVBoards 13 Sep 28, 2021
GFX Demo for the ESP-IDF

Display Drivers and Demo for GFX This is a Demo of GFX With Several Display Drivers This is not GFX itself, but it includes it. GFX Documentation is b

honey the codewitch 42 Nov 30, 2021
Demo c++/blockchain tech

Blockchain This is a blockchain concept coded in c++. I used the POW or proof-of-work algorithm. Some of the detailed concepts of the real blockchain

Narek 8 Aug 23, 2021
Android hair/human segmentation demo by ncnn

ncnn_Android_human Android hair/human segmentation demo by ncnn PS:performance maybe poor.it's just a demo:) Reference: 1.https://github.com/Tencent/n

null 23 Nov 13, 2021
Simplified design of an analog keypad matrix interface and demo thereof

Analog Keypad Interface In pin-restricted microcontroller designs it is common to use analog pins and sets of resistors to encode button switch inputs

null 13 Nov 3, 2021
Tengine 管子是用来快速生产 demo 的辅助工具

tengine-pipe Tengine 管子是用来快速生产 demo 的辅助工具 how-to-build 编译 Tengine lib $ git clone https://github.com/OAID/Tengine $ mkdir build && cd build $ cmake ..

null 12 Sep 2, 2021
A demo of the relevant blog post: Hook Heaps and Live Free

LockdExeDemo A demo of the relevant blog post: Hook Heaps and Live Free DEMO Explanation There are 2 compile types. The first is an EXE. The EXE requi

null 110 Dec 1, 2021
webrtc c++ library for mediasoup with full sfu c++ demo

项目说明: 本项目是基于mediasoup v3 版本 webrtc m84版本 的sfu的js版本修改成的c++版本,支持和js版本一样的完整demo功能,但是本项目是直接把worker进程代码集成 到了demo可以直接代码级别的调用,支持VC2019,xcode,CLion的开发环境,可以直接断

null 23 Nov 30, 2021
Source code from 068A, our 64k demo presented at Syntax 2017

068A source code dump This is a dump of the source code for the engine, graphics tool and player for 068A, our 64k demo released at Syntax 2017. It's

Monad 18 Oct 18, 2021
ebpf syscall recording demo project

ebpf syscall recording demo project

Sascha Grunert 7 Oct 26, 2021
AWS FreeRTOS MQTT demo project running on the NXP i.MXRT1050-EVKB.

AWS MQTT demo example project Click to import in Keil Studio Cloud: Board: NXP IMXRT1050-EVKB The tables below list the device configuration for this

Arm - Keil tools 1 Oct 18, 2021
Demo Pull Request

Demo Pull Request Steps to setup this Repository Locally Fork this repository to your account. Go to Git Bash and Clone the forked repository using :

BlackTimber Labs (A SoftDodge Open Source Initiative) 11 Oct 31, 2021
Android demo of LightTrack infer by ncnn

ncnn_Android_LightTrack this project is a ncnn Android demo for LightTrack, it depends on ncnn library and opencv. https://github.com/Tencent/ncnn htt

FeiGeChuanShu 10 Nov 10, 2021
Android CrowdCounting demo infer by ncnn

ncnn_Android_CrowdCounting This is a sample CrowdCounting Android demo infer by ncnn, it depends on ncnn library and opencv https://github.com/Tencent

FeiGeChuanShu 7 Nov 1, 2021