How to search for a database by keyword?

[xaa256]

你好，請原諒我的英文能力不好，我使用Google翻譯來進行發表。
Hello, please forgive me for my poor English ability. I use Google Translate to publish.


目前我照著文檔，可以進行創建、修改、刪除我的資料表以及資料表內容。
At present, I can create, modify, delete my data table and data tables contents according to the document.

目前我想要使用 UGUI 中的 Dropdown 來列出所有的資料表名稱，並可以依照指定的名稱進行編輯和刪除。
Currently I want to use Dropdown in UGUI to list all the table names and edit and delete them according to the specified name.

不過我依照其他網站的 SQL 的教學，我也沒能實現這個功能。
However, according to the teaching of SQL on other websites, I have not been able to implement this function.

請問 SimpleSQL 可以做到嗎?
Can SimpleSQL do it?

這個問題已經被解答，只更改標題不再繼續發文章發問。
This question has been answered, only change the title and no longer continue to send articles to ask questions.

[echo17]

Please see this FAQ: link

[xaa256]

這個問題已經被解答，只更改標題不再繼續發文章發問。
This question has been answered, only change the title and no longer continue to send articles to ask questions.

SimpleSQL 可以做到在所有的資料庫中以關鍵字來找尋特定內容嗎?
Can SimpleSQL search for specific content by keyword in all databases?

例如我有三個客戶名單( data table )，而我想要以關鍵字的方式來搜尋特定的客戶名稱。
For example, I have three data tables, and I want to search for specific customer names by keyword.

當我輸入其中一個客戶的名稱，將會從所有的客戶名單(data table)中來搜尋，而不需要再指定客戶名單(data table)。
When I enter the name of one of the customers, it will search from all the data tables without having to specify a data table.

[echo17]

No, but that is not a limitation of SimpleSQL. I do not know of a sql language that would support that. Queries are always done by table (or joins of tables), which is logical since every table structure could be potentially different.

You could loop through your tables and perform the queries on them one at a time. I am not sure why you have the customers in multiple tables, however. You may just need to restructure your data to fit a more relational style, keeping the customers in one table and then referencing them by a unique key field in other tables. Something like:

CustomerTable
---------------
CustomerID int
CustomerName text

ItemPurchasedTable
---------------------
ItemPurchasedID int
CustomerID int
ItemID int
DatePurchased text

ContactTable
-------------
ContactID int
CustomerID int
ContactName text
ContactPhoneNumber text

You can see in the above example that the ItemPurchasedTable and the ContactTable both have customer ids that link back to the CustomerTable. So if you wanted to search by customer name for items purchased, you could do a join like:

SELECT * FROM ItemPurchasedTable ip JOIN CustomerTable c ON ip.CustomerID = c.CustomerID WHERE c.CustomerName = 'SomeCustomer'

Check out the demos included with SimpleSQL for more join examples.

I would highly recommend going through some sql (and perhaps specifically sqlite) tutorials to get a better understanding of a relational database. Here is a good starting place:

SQLite Tutorials
Relational Database Tutorials