動画検索
関連広告
検索結果
SQL - what it is, sample of what it does
Sample Database using SELECT
Sample DB using SELECT * WHERE
adding sorting with: ORDER BY
adding records: INSERT INTO
SQLite
Files you need to download from SQLite
Adding sqlite dll files to Unity project
Find & Add Mono.Data.Sqlite.dll to project (note that since this was recorded the unityjit folder is now called unityjit-win32 for example for windows)
Going over the script in Unity/Visual Studio
CreateDB() method (Creates the table)
AddWeapon() method (adds records to the table)
DisplayWeapons() method (reads db, displays records to the console in Unity)
Deleting the DB file if you want to start over
How do we add SQLite to a Flutter app?
Creating a table
Create a query to create a table
How to identify an item
How to fetch all items of a table in a particular order?
How to close the bottom sheet?
Displaying data using FutureBuilder
Displaying data in a list view
How to edit and delete individual items
Conclusion
Introduction
Contents Page
What is a Database?
Database Software
Description of the software we will use (SQLite Browser)
Crash Course on Database structure and contents
Program and Database Overview
SELECT Statements
Using WHERE with SELECT
Sorting results using ORDER BY with SELECT
Using functions to further process results of SELECT
INSERT Statement
UPDATE Statement
CREATE TABLE Statement
Intermediate SQL
SELECT from multiple tables
Filtering the result to get only relevant rows
Aliasing tables
Filtering columns
Performing math in a SELECT statement
Aliasing columns
Grouping similar rows
Using functions alongside grouping
Applying the same to a larger table
Outtro