MySQL

From BC$ MobileTV Wiki
Jump to: navigation, search
MySQL Logo

MySQL is the world's leading open source Relational Database Management System (RDBMS). It has gained popularity among the open source developer world and business world alike, due to its openness, transparency, and the guaranteed availability of a free Developers' Version. It is also available as a low cost alternative for an Enterprise-level RDBMS.


As its name suggests, MySQL is powered primarily by queries written in the SQL language.


Syntax

INDEX


JOIN

LEFT/RIGHT JOIN

INTERSECT


SELF JOIN


ALTER

ALTER IGNORE TABLE cities ADD UNIQUE INDEX dupidx (cityName, countryID, regionID);
ALTER TABLE cities DROP INDEX dupidx

AUTO-NUM

Update the auto-increment number value to say what will be the next auto-increment (the DBMS should by default use the lowest value, greater than the "next auto-num", that is not yet taken):

ALTER TABLE [tablename] AUTO_INCREMENT = [number]

[1]


DELETE


TRIGGER


NORMALIZATION


Referential Integrity


With Programming Languages

MySQL: PHP


MySQL: Java


MariaDB

Shortly after Oracle acquired MySQL, some developer community members began parting ways with MySQL due to Oracle's clear ambitions to use MySQL's popularity in the open source community and widespread usage to upsell their flagship (and preiously competing for enterprise marketshare) RDBMS product, Oracle 11g/12i. In 2015, those upset with the direction MySQL was being taken, its lack of performance updates & new features compared to other RDBMS, etc; finally forked MariaDB as an OSS project that would maintain most of the MySQL updates but also move at a faster release pace and slightly different community contribution processes.

[3] [4] [5] [6]




Tools

[7]


Resources


Tutorials


External Links


References

  1. Can we Reset The Id Auto Increment?: http://www.trap17.com/forums/Reset-Id-Auto-Increment-t27162.html
  2. wikipedia: MariaDB
  3. MariaDB vs MySQL In 2019 - Compatibility, Performance, And Syntax: https://blog.panoply.io/a-comparative-vmariadb-vs-mysql
  4. MariaDB versus MySQL - Compatibility: https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/
  5. MariaDB vs MySQL in 2020 - Everything You Need to Know: https://hackr.io/blog/mariadb-vs-mysql
  6. MariaDB vs MySQL - Key Performance Differences : https://www.guru99.com/mariadb-vs-mysql.html
  7. Top 10 MySQL GUI Tools: http://www.databasejournal.com/features/mysql/article.php/3880961/Top-10-MySQL-GUI-Tools.htm
  8. MySQL reference - Chapter 7. Optimization: http://dev.mysql.com/doc/refman/5.0/en/optimization.html
  9. MariaDB - cannot set max_connections through my.cnf: https://stackoverflow.com/questions/37021326/mariadb-cannot-set-max-connections-through-my-cnf
  10. Change MAX Concurrent Connections in MySQL: https://community.apachefriends.org/f/viewtopic.php?p=161605
  11. Max number of connections in MySQL : https://www.webmasterworld.com/forum112/456.htm
  12. MySQL, PHP, Apache for Windows - 1. MySQL 5 - Basic information and installation: http://www.adminxp.com/programming/index.php?aid=204

See Also

SQL | NoSQL | Database | DBMS | PostgreSQL | JPA | PDO | OpenSource