SQL
阳光柠檬_
...
展开
-
编译在arm板上使用的sqlite3的静动态库
采用的是sqlite-autoconf-3080002.tar.gz 解压 tar xvf sqlite-autoconf-3080002.tar.gz进入 cd sqlite-autoconf-3080002/采用的是 arm-none-linux-gnueabi-gcc(g++)编译。 ./configure --host=arm-none-linux-原创 2013-11-18 16:39:14 · 3756 阅读 · 1 评论 -
sqlite3的事务功能实例
代码功能:从sql.txt中读出SQL语句,并一一执行,若有一条执行失败,则所有执行全部不生效。回滚到执行前的状态。#include #include #define SQL_FILE "./sql.txt"int commitSQL(sqlite3 *db){ int ret=0; FILE *fp; char buf[100原创 2013-12-09 10:13:38 · 4623 阅读 · 0 评论 -
sql中 vacuum命令:回收空白空间,减少数据库大小
The VACUUM command rebuilds the entire database. There are several reasons an application might do this:1. Unless SQLite is running in “auto_vacuum=FULL” mode, when a large amount of data is deleted翻译 2014-04-11 09:32:19 · 9772 阅读 · 0 评论 -
QSqlDatabase操作数据库sqlite3
基本打开数据库,执行SQL语句: static const char* DBName = "./test.db"; QFileInfo file(DBName); if(file.exists() == false) { QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");原创 2014-04-01 15:39:55 · 6280 阅读 · 1 评论 -
svn执行update,却被告知database is locked
svn执行update,却被告知database is locked!执行 svn update,却抛出个错误警报:svn: E200033: database is locked, executing statement 'RELEASE s0' 之后无论是cleanup,还是release locker都没反应! 别急,试试以下方案:$ cd /your pro转载 2014-09-18 11:29:43 · 30860 阅读 · 3 评论 -
linux下启动mysql以及设置远程访问
启动mysql服务:/usr/sbin/mysqld 进入本地mysql查看:mysql –u root –p passwordmysql> show databasesmysql> use `testTable`mysql> show tables设置远程能访问mysql> GRANT ALL PRIVILEGES ON *.* T原创 2015-09-16 09:49:57 · 640 阅读 · 0 评论