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.4k Jun 23, 2022
VSQLite++ - A welldesigned and portable SQLite3 Wrapper for C++ (C)

VSQLite++ - A welldesigned and portable SQLite3 Wrapper for C++ (C)

Vinzenz 'evilissimo' Feenstra 27 Dec 29, 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
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 120 Jun 18, 2022
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 123 Jun 30, 2022
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 105 Jun 7, 2022
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.4k Jun 23, 2022
VSQLite++ - A welldesigned and portable SQLite3 Wrapper for C++ (C)

VSQLite++ - A welldesigned and portable SQLite3 Wrapper for C++ (C)

Vinzenz 'evilissimo' Feenstra 27 Dec 29, 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
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 82 Mar 4, 2022
2D mesh deformation interactive demo

2D mesh deformation interactive demo

Dmitry V. Sokolov 17 Apr 4, 2022
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 59 Jun 9, 2022
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 56 Jun 14, 2022
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 97 Jun 20, 2022
[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 66 Jun 14, 2022
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 17 May 27, 2022
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 61 May 17, 2022
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 May 23, 2022
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 14 Feb 6, 2022
Tengine 管子是用来快速生产 demo 的辅助工具

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

null 13 Dec 9, 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 141 Jun 22, 2022
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 96 Jun 19, 2022
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 23 May 30, 2022
ebpf syscall recording demo project

ebpf syscall recording demo project

Sascha Grunert 9 Jun 7, 2022
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) 10 Apr 30, 2022