CODEWITHSUNDEEP
mysqlsqldatabasesqlite
ilmiont
ilmiont

Reputation: 2161

Can you use MySQL to connect to a standalone database e.g. "mydata.db"?

Pretty sure the answer is "no" but I have found no conclusive result...

Basically, can use MySQL to connect to a standalone database file and then use standard MySQL commands on it? Currently I use SQLite3 to do exactly this but I now like the usage of MySQL commands whilst retaining the single file devoid of a MySQL server. Is it possible?

Ilmiont

Upvotes: 1

Views: 834

Answers (1)

Christian Gollhardt
Christian Gollhardt

Reputation: 17024

Not possible with mysql function, but still possible with PDO. Most SQL Commands should work in any SQL Based RDBMS.

PDO is meant to have a generic interface, so even if you would have a MySQL Database, you should consider developing in PDO.

Here is a Example for SQLLite3:

http://www.if-not-true-then-false.com/2012/php-pdo-sqlite3-example/

If you want to get deeper into PDO, read this article:

http://code.tutsplus.com/tutorials/why-you-should-be-using-phps-pdo-for-database-access--net-12059

Upvotes: 1

Related Questions