Menu
Possible Duplicate:
mysql vs mysqli in php
What is the difference between mysql_* functions and mysqli_* functions? Is there any technical reasons behind we shouldn't use mysql_* functions?
861
SQL is a query programming language that manages RDBMS. MySQL is a relational database management system that uses SQL. SQL is primarily used to query and operate database systems. MySQL allows you to handle, store, modify and delete data and store data in an organized way.
MySQL Data Types (Version 8.0) In MySQL there are three main data types: string, numeric, and date and time.
MYSQL Server, or mysqld is the database server program.It manages access to the actual databases on disk or in the memory. MYSQL Client are programs for communicating with the server to manipulate the information in the databases that the server manages.
No, MySQL is not the same as SQL server. Both of these are relational database management systems offered by different vendors. They differ in terms of use cases, licensing, pricing, features, pros, cons, etc. MySQL is offered through Oracle and SQL Server is offered through Microsoft corporation.
The "i" stands for "improved". The list of improvements can be found in here.
MySQLi is the OOP version of MySQL extension. In the end, MySQLi and MySQL accomplish the same thing: they are extension for interacting with MySQL from PHP. A lot of people still use the original MySQL extension instead of the new MySQLi extension because MySQLi requires MySQL 4.1.13+ and PHP 5.0.7+ .
MySQLi supports some things that the old MySQL extension doesn't. Things like prepared statements, multiple statements, and transactions on top of my head.
58
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
