MySQL Syntax for SQLite Syntax

Question

I've started using SQLite for my Android applications. What I would like to know is where I can find a list of queries to use, are they the same for MySQL, and would I be able to use similar queries from MySQL?

Most queries will be similar, but no one can give you a complete tutorial inside a single answer. Start translating, and if you get stuck on translating a concrete one, that is a better time to ask here. — Joachim Isaksson
– Joachim Isaksson, Commented Mar 1, 2012 at 19:52
CONCAT* functions do not work in SQlit, they should be replaced with ||. Pipes must be enabled in Mysql using PIPES_AS_CONCAT flag — ymakux
– ymakux, Commented Nov 8, 2017 at 1:22

QED · Accepted Answer · 2012-03-01 19:53:58Z

4

SQLite provides a pretty good implementation of the SQL standard. Check out the syntax here. There is a prominent link in the first paragraph that describes omissions.

EDIT: No stored procedures or functions. You can mimic these in your code at runtime, however, using prepared statements

answered Mar 1, 2012 at 19:53

QED

9,9537 gold badges53 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Brandon Wilson Over a year ago

Do you know if you an create functions like MySQL?

alwayslearning · Accepted Answer · 2012-03-01 19:56:49Z

1

List of queries? You would need to use 'SQLiteDatabase.query' set of methods to query your SQLite database in your Android app. There would be SQLite specific SQL that you would need to consider while migrating your MySQL queries.

answered Mar 1, 2012 at 19:56

alwayslearning

4,6936 gold badges37 silver badges49 bronze badges

Collectives™ on Stack Overflow

MySQL Syntax for SQLite Syntax

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related