MYSQL And other?

Question

Are MYSQL and other Dbs are the same?

Can I access them Using the same SQL?

For eg:- I'm connecting Db with PHP's "mysqli_connect()" method....

is it is same for all the DBs.

And my second Question:

MYSQL can be used for Official Use? Is it is only for study purpose?

Thanks in Advance !!

Answer 1

MySQL and other DBMS are similar in functionality as they all are softwares designed to manage databases.

If you mean SQL as the language, basic commands like SELECT, INSERT, UPDATE, DELETE are supported equally in all DBMS, however, each DBMS has their own proprietary syntax and features, this means, there are different ways to accomplish a task in different DBMS, some features also depends on DBMS version.

The mysqli library is designed for MySQL only, to use other DBMS in PHP you can opt to use PDO (PHP Data Objects)

MySQL is a lot more than "can be used" or "for study purposes", it is widely used for database management online or offline (local network).

Hth, cmiiw

Answer 2

It will be, more or less, this same with other SQL databases.

Answer 3

mysql is totally free, you can use it for whatever you want.

but you need a special library for each sql engine: mysql, mssql, oracle etc. PHP methods can look much the same (though they can slightly differ)

Answer 4

use pdo

Answer 5

pdo means?