軟體介紹
This is a editor of SQLite database and including SQLite tutorial.
This tutorial will teach you SQLite from basic to advanced.
Users can exercise in SQLite editor.
SQLite editor includes autocomplete keywords for writing easily.
Users can attach databases to existing database.
Tutorial List :
- About SQLite
- Attach Database
- Detach Database
- Data Types
- Create Table
- Drop Table
- Alter Table
- Constraint
- Autoincrement
- Indexes
- Insert Query
- Update Query
- Delete Query
- Select Query
- Operators
- Where Clause
- Limit Clause
- Order By
- Group By
- Having Clause
- Distinct Keyword
- Joins
- Views
- CASE expression
- Collating Sequences
- Triggers
- Subqueries
- Transactions
- Alias
- Union
- Sqlite_master
- Pragma
- Aggregate Functions
- Date and Time Functions
- Core Functions
NOTE:
For working properly autocomplete function turn off autocorrect/predictive text in your mobile device.
歷史版本
- 09/28/2022: SQLite Editor & Tutorial 1.6.0
- Report a new version
Free Download
二維碼下載
- 軟體名稱: SQLite Editor & Tutorial
- 軟體分類: 教育
- APK名稱: com.esye.app.sqlitetut
- 最新版本: 1.6.0
- 支持ROM: 4.0.3及更高版本
- 軟體大小 : 22.01 MB
- 更新日期: 2022-09-28