Global Information Lookup Global Information

MySQL information


Original author(s)MySQL AB
Developer(s)Oracle Corporation
Initial release23 May 1995; 28 years ago (1995-05-23)
Stable release
8.3.0[1] Edit this on Wikidata / 16 January 2024; 2 months ago (16 January 2024)
Repository
  • github.com/mysql/mysql-server Edit this at Wikidata
Written inC, C++[2]
Operating systemLinux, Solaris, macOS, Windows, FreeBSD[3]
Available inEnglish
TypeRDBMS
LicenseGPLv2 or proprietary[4]
Websitewww.mysql.com Edit this on Wikidata

MySQL (/ˌmˌɛsˌkjuːˈɛl/)[5] is an open-source relational database management system (RDBMS).[5][6] Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My,[7] and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation).[8] In 2010, when Oracle acquired Sun, Widenius forked the open-source MySQL project to create MariaDB.[9]

MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress.[10] MySQL is also used by many popular websites, including Facebook,[11][12] Flickr,[13] MediaWiki,[14] Twitter,[15] and YouTube.[16]

  1. ^ "Changes in MySQL 8.3.0 (2024-01-16, Innovation Release)". 16 January 2024. Retrieved 16 January 2024.
  2. ^ "MySQL: Project Summary". Ohloh. Black Duck Software. Retrieved 17 September 2012.
  3. ^ "Supported Platforms: MySQL Database". Oracle. Retrieved 24 March 2014.
  4. ^ "Downloads". MySQL. Retrieved 3 August 2014.
  5. ^ a b "What is MySQL?". MySQL 8.0 Reference Manual. Oracle Corporation. Retrieved 3 April 2020. The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my sequel"), but we do not mind if you pronounce it as "my sequel" or in some other localized way.
  6. ^ "DB-Engines Ranking of Relational DBMS". DB-Engines. solidIT consulting & software development GmbH. Retrieved 3 April 2020.
  7. ^ "History of MySQL". MySQL 8.0 Reference Manual. Oracle Corporation. Retrieved 3 April 2020. MySQL is named after co-founder Monty Widenius's daughter, My.
  8. ^ "Sun Microsystems Announces Completion of MySQL Acquisition; Paves Way for Secure, Open Source Platform to Power the Network Economy" (Press release). Sun Microsystems. 26 February 2008. Archived from the original on 28 February 2008. Retrieved 17 September 2012.
  9. ^ Pearce, Rohan (28 March 2013). "Dead database walking: MySQL's creator on why the future belongs to MariaDB". Computerworld. Archived from the original on 3 July 2020. Retrieved 3 April 2020. The day the Sun purchase was announced, Widenius responded […] — he forked MySQL, launching MariaDB […]
  10. ^ Jackson, Joab (8 March 2010). "WordPress Guns for Web Content Management Duties". The New York Times. Retrieved 24 August 2023. WordPress, created in 2003, uses a variety of open-source programs and open standards, such as PHP, MySQL, JavaScript, HTML and CSS.
  11. ^ Sobel, Jason (21 December 2007). "Keeping Up". The Facebook Blog. Facebook. Archived from the original on 18 June 2009. Retrieved 18 June 2009. […] Facebook's data is stored in MySQL database servers […]
  12. ^ Matsunobu, Yoshinori (31 August 2016). "MyRocks: A space- and write-optimized MySQL database". Facebook Engineering. Archived from the original on 7 March 2020. Retrieved 7 March 2020. At Facebook we use MySQL to manage many petabytes of data, along with the InnoDB storage engine […]
  13. ^ Elliott-McCrea, Kellan (8 February 2010). "Using, Abusing and Scaling MySQL at Flickr". code.flickr.com. Retrieved 3 April 2020. […] at Flickr, MySQL is our hammer, and we use it for nearly everything. It's our federated data store, our key-value store, and our document store.
  14. ^ "Manual:MySQL". www.mediawiki.org. MediaWiki, The Free Wiki Engine. Retrieved 3 April 2020. The MySQL and MariaDB database engines are the most commonly-used database backends for MediaWiki.
  15. ^ Hashemi, Mazdak (19 January 2017). "The Infrastructure Behind Twitter: Scale". blog.twitter.com. Retrieved 3 April 2020. SQL: This includes MySQL, PostgreSQL and Vertica. MySQL/PosgreSQL are used where we need strong consistency […]
  16. ^ Mehta, Chintan; K Bhavsar, Ankit; Oza, Hetal; Shah, Subhash (15 February 2018). MySQL 8 Administrator's Guide: Effective Guide to Administering High-performance MySQL 8 Solutions. Packt Publishing. p. 32. ISBN 9781788393843.

and 23 Related for: MySQL information

Request time (Page generated in 0.6544 seconds.)

MySQL

Last Update:

"MySQL :: MySQL Products". "MySQL :: MySQL Community Edition". mysql — The MySQL Command-Line Tool, MySQL Reference Manual mysqladmin – the MySQL command-line...

Word Count : 6163

MySQL Workbench

Last Update:

MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single...

Word Count : 1789

SQL injection

Last Update:

multiple statements to be executed with one call in this way, some SQL APIs such as PHP's mysql_query() function do not allow this for security reasons. This...

Word Count : 4497

List of SQL reserved words

Last Update:

2023. "Reserved Words". Mimer SQL Manuals. Mimer AB. Retrieved 23 December 2020. "Keywords and Reserved Words". MySQL 8.0 Reference Manual. Oracle Corporation...

Word Count : 159

MySQL AB

Last Update:

Corporation in 2010. MySQL AB is the creator of MySQL, a relational database management system, as well as related products such as MySQL Cluster. The company...

Word Count : 703

MariaDB

Last Update:

numbers follow MySQL's numbering scheme up to version 5.5. Thus, MariaDB 5.5 offers all of the MySQL 5.5 features. There exists a gap in MySQL versions between...

Word Count : 3180

MySQL Cluster

Last Update:

library and MySQL supporting multi master. RonDB A fork of MySQL Cluster maintained by Hopsworks. "MySQL NDB Cluster 8.3 Release Notes". mysql.com. Cluster...

Word Count : 2330

PostgreSQL

Last Update:

PostgreSQL written in PHP and based on the popular phpMyAdmin interface originally written for MySQL administration. PostgreSQL Studio PostgreSQL Studio...

Word Count : 8582

PhpMyAdmin

Last Update:

phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become...

Word Count : 657

Percona Server for MySQL

Last Update:

Percona Server for MySQL is a distribution of the MySQL relational database management system created by Percona. It is similar to MySQL Enterprise from...

Word Count : 206

Comparison of relational database management systems

Last Update:

Microsoft "Feature request #16244: SQL-99 Derived table WITH clause (CTE)", Bugs, MySQL, Oracle Window Functions, mysql.com, retrieved 20 July 2021 Parallel...

Word Count : 3362

Amazon Aurora

Last Update:

compatible with MySQL, meaning that tools for querying or managing MySQL databases (such as the mysql command-line client and the MySQL Workbench graphical...

Word Count : 623

NoSQL

Last Update:

relational SQL and NoSQL systems including MySQL and MongoDB (2014). "Integration and virtualization of relational SQL and NoSQL systems including MySQL and...

Word Count : 2398

Michael Widenius

Last Update:

main author of the original version of the open source MySQL database, a founding member of the MySQL AB company and CTO of the MariaDB Corporation AB. Additionally...

Word Count : 771

MyBB

Last Update:

software developed by the MyBB Group. It is written in PHP, supports MySQL, PostgreSQL and SQLite as database systems and, in addition, has database failover...

Word Count : 4056

Oracle Corporation

Last Update:

management MySQL, a relational database management system licensed under the GNU General Public License, initially developed by MySQL AB Oracle NoSQL Database...

Word Count : 11399

Programming languages used in most popular websites

Last Update:

Bigtable". Archived from the original on 16 June 2006. "Google Waves Goodbye To MySQL In Favor Of MariaDB". readwrite.com. 14 September 2013. Retrieved 12 December...

Word Count : 560

List of wiki software

Last Update:

written in C#, uses the .NET framework, and stores data in files or Microsoft SQL Server. Development stopped in 2009. Swiki is written in Squeak. It runs...

Word Count : 1532

MySQLi

Last Update:

$result = mysql_query("SELECT * FROM myDatabase", $mysql); echo mysql_num_rows($result); ?> The MySQL server supports the use of different transport...

Word Count : 2214

Google App Engine

Last Update:

manipulating images; and caching. Google Cloud SQL can be used for App Engine applications requiring a relational MySQL compatible database backend. Per-day and...

Word Count : 2173

Sun Microsystems

Last Update:

another open database, PostgreSQL, was considered by many users of this type of software as a credible alternative to MySQL and could to some extent replace...

Word Count : 8513

Database trigger

Last Update:

- SQL Server". "PostgreSQL: Documentation: 9.0: CREATE TRIGGER". www.postgresql.org. 8 October 2015. MySQL 5.0 Reference Manual. "Triggers. MySQL 5.0...

Word Count : 2337

Prepared statement

Last Update:

JDBC: import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement;...

Word Count : 1672

PDF Search Engine © AllGlobal.net