SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. This app will give you a quick start with SQLite and make you comfortable with SQLite programming.
Features:
- Overview
- Installation
- Commands
- Syntax
- Data Type
- CREATE Database
- ATTACH Database
- DETACH Database
- CREATE Table
- DROP Table
- INSERT Query
- SELECT Query
- Operators
- Expressions
- WHERE Clause
- AND & OR Clauses
- UPDATE Query
- DELETE Query
- LIKE Clause
- GLOB Clause
- LIMIT Clause
- ORDER By Clause
- GROUP By Clause
- HAVING Clause
- DISTINCT Keyword
- PRAGMA
- Constraints
- JOINS
- UNIONS Clause
- NULL Values
- ALIAS Syntax
- Triggers
- Indexes
- INDEXED By Clause
- ALTER Command
- TRUNCATE Command
- Views
- Transactions
- Subqueries
- AUTOINCREMENT
- Injection
- EXPLAIN
- VACUUM
- Date & Time
- Useful Functions
- SQLite - C/C++
- SQLite - Java
- SQLite - PHP
- SQLite - Perl
- SQLite – Python
- Includes video tutorials
- Ability to learn on your own time from anywhere when you can’t access the internet.
- Optimized for most Android supported devices with enhanced graphics and design
Last updated on Oct 1, 2018
Minor bug fixes and improvements. Install or update to the newest version to check it out!
APKPure - 안드로이드를 중심으로 한 멀티플랫폼 앱스토어로, 다양한 앱 관련 콘텐츠를 제공합니다. 더 쉽고, 빠르고, 안전하게 원하는 앱을 찾아보세요. 빠르고 효율적인 다운로드와 설치가 가능합니다.
