Found 4219 Articles for MySQLi

Let us understand how to verify the package integrity of MySQL −Once the MySQl package that suits the user’s requirements has been downloaded, it has to be installed. Before installation, it is to be ensured that the package is intact and hasn’t been tampered with.Check Integrity of packageThere are three ways in which the integrity of the package can be checked. They have been listed below.MD5 checksumsCryptographic signatures with the help of GnuPG, which is the GNU Privacy GuardFor RPM packages, the built-in PRM integrity verification mechanismLet us understand the MD5 checksum method of checking the integrity of the package.MD5 ... Read More

Let us understand how to check the version of MySQL that the user is currently running −Before entering queries on the console, it is important to ensure that the user is connected to the server.Check MySQL VersionThe below query would give the version number of the server being used, and the current date.mysql> SELECT VERSION(), CURRENT_DATE;Note: The function ‘VERSION()’ and ‘CURRENT_DATE’ are case −insensitive. This means ‘version()’, ‘Version()’, ‘vERsion()’, all mean the same. Same goes with ‘CURRENT_DATE’QueriesLearn about MySQL QueriesAn SQL query is followed by a semi−colon.When a query is issued to mysql, it sends the query to the server ... Read More

Let us see the different platforms that MySQL supports. MySQL can be deployed in virtual environments.It supports the below mentioned operating systems −Oracle Linux/ Red Hat/ CentOSOracle Linux 8 / Red Hat Enterprise Linux 8 / CentOS 8 whose architecture can be x86_64, ARM 64Oracle Linux 7 / Red Hat Enterprise Linux 7 / CentOS 7 whose architecture can be ARM 64Oracle Linux 7 / Red Hat Enterprise Linux 7 / CentOS 7 whose architecture can be x86_64Oracle Linux 6 / Red Hat Enterprise Linux 6 / CentOS 6 whose architecture can be x86_32, x86_64Oracle SolarisSolaris 11 (Update 4+) whose ... Read More

The article lists some of the tools that have been used to create MySQL. This is an important list which has helped mould what MySQl is today.Free Software FoundationThey helped provide an excellent compiler (gcc), an excellent debugger (gdb) and the libc library (from which strto.c has been borrowed to get some code working in Linux).Free Software Foundation & The XEmacs development teamThey have helped provide a really great editor/environment.Julian SewardThey are the author of valgrind, an excellent memory checker tool that helps find a lot of otherwise hard to find bugs in MySQL.Dorothea Lütkehaus and Andreas ZellerThey have helped ... Read More

Let us see the major packages that support MySQL −This article lists the creators and maintainers of some of the most important API/packages/applications that is used by a lot of people along with the usage of MySQL. The major packages that support MySQL by lending their support, along with their contributions have been listed below −Tim Bunce, Alligator Descartes: They helped with the DBD (Perl) interface.Andreas Koenig: They helped with the Perl interface for MySQL Server.Jochen Wiedmann: They helped in maintaining the Perl DBD::mysql module.Eugene Chan: They helped in porting PHP for MySQL Server.Georg Richter: They helped in the testing ... Read More

Let us see who the major contributors to MySQL are −Although Oracle Corporation and/or its affiliates own all copyrights in the MySQL server and the MySQL manual, we wish to recognize those who have made contributions of one kind or another to the MySQL distribution. Contributors are listed here, in somewhat random order −Gianmassimo Vigazzola − They helped with the initial port to Win32/NT.Per Eric Olsson − They provided for constructive criticism and real testing of the dynamic record format.Irena Pancirov − Helped with the Win32 port with Borland compiler. They also helped with the mysqlshutdown.exe and mysqlwatch.exe.David J. Hughes ... Read More

Let us see who the documenters and translators of MySQL are −Many people have contributed in the MySQL documentation, translation of the documentation and error messages in MySQL. There are many people, organizations, students, and others who have helped in the development, maintenance, and improvement of MySQL.But the major people who have supported in the documentation and translation of certain parts of MySQL by lending their never-ending support, along with their contributions have been listed below −Kim Aldale − They have helped rewrite Monty's and David's early attempts at English into English.Michael J. Miller Jr − They have helped in ... Read More

Let us see who the major supports of MySQL are −Oracle Corporation and/or its affiliates own all copyrights of the MySQL server and the MySQL manual. There are many people, organizations, students, and others who have helped in the development, maintenance, and improvement of MySQL. Many companies have helped in the development of the MySQL server. This includes paying for developing a new feature or providing hardware for development of the MySQL server. They have been listed below −VA Linux / Andover.netThey helped with the funding of the replicationNuSphereThey helped with the editing of the MySQL manual.Stork Design studioIt was ... Read More

Let us understand how MySQL deals with constraints −MySQL helps us work with transactional tables (which permit rollback) and with non-transactional tables (which don’t permit rollback). This is the reason why handling constraints is different in MySQL in comparison to other DBMS. In non-transactional database, if an error occurs while inserting or updating many rows, it can’t be rolled back. This case has to be handled in the right manner.MySQL Server produces an error for queries which it detects to be errors, when parsing a statement that needs to be executed. Once the error has been detected, it tries to ... Read More

Let us understand the differences between MySQL and Standard SQL. MySQL performs many operations differently in certain cases −PrivilegesThere are many differences between MySQL and standard SQL with respect to privileges given to the user. In MySQL, privileges for a table are automatically not revoked when a table is deleted. A REVOKE statement needs to be explicitly issued to revoke privileges for a table.Foreign Key ConstraintsThe MySQL implementation of foreign key constraints is different from the SQL standard. If there are many rows in the parent table with the same referenced key value, InnoDB engine does a foreign key check ... Read More