jjhua的专栏

自身关联CREATE TABLE Business (ID varchar(50) NOT NULL PRIMARY KEY,Name varchar(200) NOT NULL,"Parent_ID" varchar(50),ConfigurationPage boolean NOT NULL,FOREIGN KEY(Parent_ID) REFERENCES Business(ID)

SQLite下执行update语句无法像SQL Server下实现join，例如：update Product set Product.StockNumber =Product.StockNumber-BuyNumber from Product join OrderListDetail on (Product.ID =OrderListDetail.ProductID) joi

"Error creating context 'spring.root': Error thrown by a dependency of object 'SQLite-1.0.47' defined in 'assembly [Spring.Data, Version=2.0.0.40000, Culture=neutral, PublicKeyToken=null], resource [S

attach DataBase 'F:\Sqlitedatabase.db' as db2;delete from Test where Test.ID in (select ID from db2.Test);insert into Test select A.* from db2.Test as A ;select * from db2.Test;detach database

查询表结构select * from sqlite_masterselect * from sqlite_temp_master查询单表列信息PRAGMA table_info(表名);