DEV Community

Salma
Salma

Posted on

2

What's SQL, MySQL, MySQLi, PDO?

SQL

Structured Query Lanaguage

MYSQL

Database System sama as [MSSQL,Oracle]
it is poplaur database connecting with PHP .

(DEPRECATED) The mysql functions are procedural and use manual escaping.
Mysql has extension to connect to db.

MySQLi

is a replacement for the mysql functions, with object-oriented and procedural versions. It has support for prepared statements.

PDO (PHP Data Objects)

is a general database abstraction layer with support for MySQL among many other databases. It provides prepared statements, and significant flexibility in how data is returned.

RBDMS

Relation Database Managment System

Top comments (0)

Billboard image

Create up to 10 Postgres Databases on Neon's free plan.

If you're starting a new project, Neon has got your databases covered. No credit cards. No trials. No getting in your way.

Try Neon for Free →

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay