[permalink] [id link]
MySQL ( " My S-Q-L ", officially, but also called " My Sequel ") is the world's most used open source relational database management system ( RDBMS ) as of 2008 that runs as a server providing multi-user access to a number of databases.
from
Wikipedia
Some Related Sentences
MySQL and My
He lives in Helsinki with his second wife Anna and daughter Maria, and has a daughter My ( after whom MySQL is named, according to " History of MySQL ") and a son Max ( giving the name for MaxDB ) from his first marriage.
According to the MySQL documentation's history, it is unclear and a mystery for David Axmark where the " My " prefix originated.
MySQL and ",
Users may use the included command line tools, or use MySQL " front-ends ", desktop software and web applications that create and manage MySQL databases, build database structures, back up data, inspect status, and work with data records ..
: The developer of the Federated Storage Engine states that " The Federated Storage Engine is a proof-of-concept storage engine ", but the main distributions of MySQL version 5. 0 included it and turned it on by default.
* AMP ( solution stack ) or " Apache, MySQL and PHP ", software products commonly used together
A surrogate key is frequently a sequential number ( e. g. a Sybase or SQL Server " identity column ", a PostgreSQL or Informix, an Oracle or a column defined with in MySQL ) but doesn't have to be.
In addition to these magazines, he has also written a number of books, including " The Art of Community ", " Linux Desktop Hacks ", " PHP and MySQL Web Applications: Building Eight Dynamic Web Sites " and he also co-wrote " The Official Ubuntu Book " ( ISBN 0-13-243594-2 ) with Benjamin Mako Hill, Corey Burger, and Jonathan Jesse.
FileMaker uses the term " Find ", while MySQL uses the term " Query "; but the concept is the same.
FileMaker " files ", in version 7 and above, are equivalent to MySQL " databases ", and so forth.
*" Sql Commands ", MySQL.
( This is in contrast to what is usually referred to as " MySQL Replication ", which is asynchronous.
MySQL and also
MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google ( though not for searches ), Facebook, Twitter, Flickr, Nokia. com, and YouTube.
Third-parties have also developed tools to manage a MySQL server, some listed below.
A port of MySQL to OpenVMS also exists.
The HTSQL-URL-based query method also ships with a MySQL adapter, allowing direct interaction between a MySQL database and any web client via structured URLs.
MySQL can also be run on cloud computing platforms such as Amazon EC2.
The intent also being to maintain high fidelity with MySQL, ensuring a " drop-in " replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.
MySQL v4. 0. 16 and PHP v4. 3. 7 are also included.
MySQL v4. 0. 16 and PHP v4. 3. 7 are also included.
Berry was inspired to start the project while working for a small ISP while also still in high school, learning PHP and MySQL.
With Gambas, developers can also use databases such as MySQL or PostgreSQL, build KDE ( Qt ) and GNOME GTK + applications with DCOP, translate Visual Basic programs to Gambas and run them under Linux, build network solutions, and create CGI web applications.
This new software was also written in PHP with a MySQL backend, and kept the basic interface of the phase II software, but was meant to be more scalable.
Together with some additional services, MySQL also provide this as a subscription-based product called MySQL Enterprise, which is also resold by other companies such as Dell, HP, and Novell.
Other programs may also be included in a package, such as phpMyAdmin which provides a graphical user interface for the MySQL database manager, or the alternative scripting languages Python or Perl.
There also exists several third party plug-ins to authenticate against LDAP or SQL databases such as SQLite and MySQL.
MaxDB is an ANSI SQL-92 ( entry level ) compliant relational database management system ( RDBMS ) from SAP AG, which was delivered also by MySQL AB from 2003 to 2007.
Starting with MySQL 5. 1, it is also possible to replicate asynchronously between clusters ; this is sometimes referred to as " MySQL Cluster Replication " or " geographical replication ".
MySQL and called
In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion.
This allows users on the System i platform to natively access the DB2 under the IBM i operating system ( formerly called OS / 400 ), and for users on other platforms to access these files through the MySQL interface.
The no-charge version of DB2 is called DB2 Express-C. DB2 Express-C is in some ways similar to the open source databases such as MySQL and PostgreSQL as it is offered unsupported, free of charge for unrestricted use including use in production environments.
MySQL Cluster is implemented through an additional storage engine available within MySQL called NDB or NDBCLUSTER (" NDB " stands for Network Database ).
Ulf Michael Widenius ( often called Monty ), born 3 March 1962, in Helsinki, Finland, is the main author of the original version of the open-source MySQL database and a founding member of the MySQL AB company.
On 12 December 2009, Monty asked MySQL customers to lobby the EC with regards to the Oracle acquisition of Sun, citing concerns about potential Oracle control of MySQL, this resulted in an online petition campaign called " Help MySQL ".
A version where MySQL has been replaced by PostgresSQL is called LAPP.
MySQL and ")
Third-party proprietary and free graphical administration applications ( or " front ends ") are available that integrate with MySQL and enable users to work with database structure and data visually.
On 15 June 2001, NuSphere sued MySQL AB, TcX DataKonsult AB and its original authors Michael (" Monty ") Widenius and David Axmark in U. S District Court in Boston.
MySQL and is
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack — LAMP is an acronym for " Linux, Apache, MySQL, Perl / PHP / Python.
MySQL is primarily an RDBMS and ships with no GUI tools to administer MySQL databases or manage data contained within the databases.
The official set of MySQL front-end tools, MySQL Workbench is actively developed by Oracle, and is freely available for use.
The official MySQL Workbench is a free integrated environment developed by MySQL AB, that enables users to graphically administer MySQL databases and visually design database structures.
MySQL Workbench is available in two editions, the regular free and open source Community Edition which may be downloaded from the MySQL website, and the proprietary Standard Edition which extends and improves the feature set of the Community Edition.
* OpenOffice. org – OpenOffice. org Base can manage MySQL databases if the entire suite is installed.
MySQL is written in C and C ++.
MySQL 5. 5 is offered under the same licences.
* Strict mode ( ensures MySQL does not truncate or otherwise modify data to conform to an underlying data type, when an incompatible value is inserted into that type )
* Multiple storage engines, allowing one to choose the one that is most effective for each table in the application ( in MySQL 5. 0, storage engines must be compiled in ; in MySQL 5. 1, storage engines can be dynamically loaded at run time ):
0.338 seconds.