Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Verifying MySQL Package Integrity
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 MoreTools that were used to create MySQL
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 MoreWhat are the MySQL Supported Platforms?
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 MoreMajor Packages that support MySQL
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 MoreDocumenters and translators of MySQL
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 MoreMajor Supporters of MySQL
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 MoreMySQL Differences from Standard SQL
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 MoreMySQL Extensions to Standard SQL
MySQL server supports extensions which may not be found in other SQL databases. This means, if these extensions of MySQL are used, the code can’t be ported to other SQL servers. But sometimes, it can be ported.Let us understand the MySQL extensions to standard SQL −Enclosing StringsThe strings can be enclosed in “ (double quotes) or ‘ (single quote) by default. If the ‘ANSI_QUOTES’ SQL mode is on, the strings have to be enclosed using ‘, and if “ (double quotes) is used, the server interprets this as identifiers.Escape Character\ is the escape character for strings.Accessing TableMySQL doesn’t support tablespaces, ...
Read MoreMySQL Standards Compliance
The standards compliance tells how MySQL is related to the ANSI/ISO SQL standards. There are many versions of the SQL standard, and the phrase ‘SQL standard’ is used to refer to the current version of SQL standard at any point in time.Following are the MySQL Standards Compliance −MySQL server was originally designed to work with medium-sized databases (10 to 100 million rows or 100 MB per table) on small systems. But currently, it has been upgraded to work with terabyte-sized databases.MySQL supports ODBC levels ranging from 0 to 3.5.1.MySQL also supports high-availability database clustering, which can be achieved with the ...
Read MoreHow to multiply large numbers with all digits in the output in R?
To multiply large numbers with all digits in the output, we can use mul.bigz function of gmp package. For example, if we have two vectors say x and y each containing numbers of large size then the multiplication of these numbers that will return all the digits of the multiplication can be done by using the command mul.bigz(x,y).Example1Loading gmp package and multiplying vectors containing large number values −library(gmp) x1
Read More