How to access sqlite database
来源:互联网 发布:linux 串口波特率设置 编辑:程序博客网 时间:2024/05/18 02:33
不知道会有多少人遇到同样的问题,ROR装好之后,怎样访问sqlite数据库?
命令:rails db 或 rails dbconsole
或者 sqlite3 db/development.sqlite3
D:\Ruby\projects\blog>rails dbSQLite version 3.7.15.2 2013-01-09 11:53:05Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite> select * from posts;1|Hello World.|15mins build a blog with ROR.PTIAN|2013-04-06 03:39:30.770540|2013-04-06 03:39:30.7705402|||2013-04-06 03:58:18.954069|2013-04-06 03:58:18.9540693|2nd post|write something....|2013-04-06 03:58:58.049305|2013-04-06 03:58:58.049305sqlite>
D:\Ruby\projects\blog>sqlite3 db/development.sqlite3SQLite version 3.7.15.2 2013-01-09 11:53:05Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite>
如果想通过GUI连数据库的话,推荐SQLite Manager,这是一个Firefox的插件
连接数据库时,需要选择sqlite数据库文件,这个文件的位置在rails_project\db\development.sqlite3
- How to access sqlite database
- How Do I Enable Remote Access To MySQL Database Server?
- QT14 how to save data in sqlite database with pushbutton
- QT18 how to link QListView with sqlite Database values
- QT19 How to link QComboBox with sqlite Database values
- Connect to Access database
- SQLite Tutorial 5 : How to Import CSV or Excel file into SQLite database
- UWP(2) How to access the Sqlite db(如何访问Sqlite数据库文件)
- How to use sqlite?
- How to access database using C++ & ADO - 如何用C++和ADO访问数据库
- How to access database using ADO in VB6 - 在 VB6 中用ADO对象如何访问数据库
- How to Quiesce a Database
- How to monitor database change
- mysql how to migration database
- How to Setup A Database
- How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000
- How to grant access to SQL logins on a standby database when the guest user is disabled in SQL Serve
- HOW TO:Access的身份验证
- hadoop-1.0.4集群部署
- 【JAVA基础】0006--------JAVA生成XML的简单方法
- mvn assembly 插件打包失败的问题解决
- CSS初探
- 看到某tool,使用方法是./geniatagger -nt < IN file > OUT file, 需要注意
- How to access sqlite database
- 如何建立eCos嵌入式系统
- 深入理解计算机系统第七章-----链接
- 系统安装:双系统启动菜单
- Using Touch Gestures 》Managing Touch Events in a ViewGroup
- SElinux初探
- 猴子吃桃问题
- LinearLayout 垂直滚动条
- debug中遇到error: cannot open 某个file,需要注意的是