MYSQL And other? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

MYSQL And other?

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 !!

19th Jun 2018, 2:55 AM
Hemath Kumar
Hemath Kumar - avatar
5 Answers
+ 7
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
19th Jun 2018, 7:19 AM
+ 1
It will be, more or less, this same with other SQL databases.
19th Jun 2018, 3:08 AM
+ 1
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)
19th Jun 2018, 4:32 AM
Дмитро Іванов
Дмитро Іванов - avatar
use pdo
20th Jun 2018, 11:09 PM
Yadira - avatar
pdo means?
21st Jun 2018, 3:07 AM
Hemath Kumar
Hemath Kumar - avatar