MySQL的/ SQLite的区别的/ etc数据库？ [英] Difference between MySQL/SQLite/etc databases?
问题描述
这是我第一次尝试与数据库工作，所以多多包涵。
This is my first time trying to work with a database, so bear with me.
我需要写会用，我没有访问还没有数据库的计划。我知道有MySQL和SQLite和一堆其他的SQL的东西，但我不知道它们之间的区别是什么。我需要知道它是什么样的数据库之前，我可以用它（即是一个MySQL .db文件从一个SQLite不同.db文件？），或者是文件本身将是相同的，所不同的是怎么样被访问？
I need to write a program that will use a database that I do not have access to yet. I know there is MySQL, SQLite, and a bunch of other SQL things, but I'm not sure what the difference between them is. Do I need to know what kind of database it is before I can use it (i.e., is a MySQL .db file different from a SQLite .db file?), or is the file itself going to be the same and the difference is how it is accessed?
编辑：我对编程的Android平板电脑，这可能是重要的。但我不会创建数据库，这将给予我和我有它的工作。
I am programming for an Android tablet, that probably matters. But I will not be creating the database, it will be given to me and I have to work with it.
推荐答案
您可能希望通过视图教程创建MySQL数据库，和SQLite的实例来运行，看看他们是如何工作的，以及如何可以轻松地与他们进行互动。
You might want to run through a view tutorials creating a MySQL database, and a SQLite instance to see how they work and how you can easily interact with them.
到每个访问包括适配器，尽管创造你需要的表，用户访问（用户名/密码/角色访问表）。
The access to each involves adapters, notwithstanding creating the tables you'll need, the user access (username / password / role to access the table).
下面是一个直接的sqlite的教程： HTTP：//zet$c$c.com/db/sqlite/
Here's a straight-forward sqlite tutorial: http://zetcode.com/db/sqlite/
下面是一个staight进SQL教程： HTTP：//zet$c$c.com/databases/mysqlphptutorial/
Here's a staight-forward sql tutorial: http://zetcode.com/databases/mysqlphptutorial/
我还记得我第一次被淹没的数据库。我的建议是开始与一些很好的支持，用一个漂亮的社区，和搜索结果，大量的教程，在这里你可以掌握的基础知识。
I remember being overwhelmed with databases my first time. My advice is to start with something well-supported, with a nice community, and search results a-plenty of tutorials, where you can grasp the fundamentals.
然后，根据您的应用需求和平台的限制，你能确定转动。但回顾数据库之间的差异，而无需实际与他们的工作就像是试图寿司片而没有吃鱼。
Then, based on your application requirements, and platform constraints, you can determine where to pivot. But reviewing the differences between databases without actually having worked with them is like trying pieces of sushi without ever eating fish.
编辑：
如果你正在建立在Android上，是的，学习的SQLite。
If you're building on Android, yep, learn SQLite.
我强烈推荐这个教程，以帮助您看到一个Android项目中使用的SQLite： http://developer.android.com/resources/tutorials/notepad/index.html
I highly recommend this tutorial to help you see SQLite used in an Android project: http://developer.android.com/resources/tutorials/notepad/index.html
有关数据抽象/ ORM，你应该熟悉与内容提供商和光标（的 http://developer.android.com/guide/topics/providers/content-providers.html ）
For data abstraction / ORM, you should familiarize yourself with Content Providers and Cursors (http://developer.android.com/guide/topics/providers/content-providers.html)
好查询！
这篇关于MySQL的/ SQLite的区别的/ etc数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
