![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQLite
jjhua
good good study for family
展开
-
SQLite 外键 级联更新 删除
自身关联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)原创 2012-06-28 19:47:46 · 11582 阅读 · 0 评论 -
SQLite下Update无法Join解决办法
SQLite下执行update语句无法像SQL Server下实现join,例如:update Product set Product.StockNumber =Product.StockNumber-BuyNumber from Product join OrderListDetail on (Product.ID =OrderListDetail.ProductID) joi原创 2013-08-01 14:56:36 · 4573 阅读 · 0 评论 -
Nhibernate下操作SQLite报错
"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原创 2013-07-27 19:50:11 · 2031 阅读 · 0 评论 -
两个SQLite数据库间导入数据的SQL语句
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原创 2015-03-14 17:30:44 · 4383 阅读 · 1 评论 -
SQLite 获取数据库中信息
查询表结构select * from sqlite_masterselect * from sqlite_temp_master查询单表列信息PRAGMA table_info(表名);原创 2013-10-23 21:51:17 · 1247 阅读 · 0 评论