What is mySQL and how would one use it?

Question

What is mySQL and how would one use it?

Answer 1

MySQL is the most popular open source database server.



MySQL is a database. A database defines a structure for storing information.



In a database, there are tables. Just like HTML tables, database tables contain rows, columns, and cells.



Databases are useful when storing information categorically. A company may have a database with the following tables: "Employees", "Products", "Customers" and "Orders".

Answer 2

MySQL works great with PHP, a server side language usually used to extract and display the data from a MySQL database. The website below offers a great example (with a DEMO) of how PHP works with the MYSQL database.



Good Luck

Answer 3

Its a database engine.

Get it from here and install

http://dev.mysql.com/downloads/mysql/5.0.html#downloads



HeidiSQL is a free GUI tool for mySQL. Get CocoaSQL or yoursql for Mac.

http://www.heidisql.com/

http://yoursql.ludit.it/



PostgreSQL has more feature and is also free (but less popular). SQLite is portable and my favorite. All are free and cross platform.

Answer 4

It's a database. One of its main uses is for websites - it stores the page content which is served up by dynamic systems like PHP or Django.

Answer 5

MYSQL is database. it is opensource. it RDMS like oracle database.

you can down from www.mysql.org. it is free database.

it is backend, it can connect to java,j2ee through connectorJ driver. and dotnet also connect with this



MYsql can be used for application programming (standalone or networking application like vb.net, java Swing etc.) and also using in j2ee, struts or asp.net web technologies./

it is mainly use store the data permantly in harddisk.