SQL stands for Structured Query Language and is used in manipulating data stored in a Relational Database Management System (RDBMS). SQL provides commands in which data can be extracted, sorted, updated, deleted and inserted. SQL can be used with many different RDBMS’s including MySQL, PostgressSQL, Oracle, Microsoft SQL Server, Access, etc.
MySQL
Officialy known as My-S-Q-L but is also referred to as My Sequel is the world’s most widely used open source RDBMS and runs as a server providing multi-user access to a number of databases. MySQL is a popular choice of database for use in web applications and is used in some of the most popular websites on the internet including
Flickr, Youtube, Google, Twitter and Facebook!
MySQL is primarily an RDBMS and ships without a GUI interface. There are thus many different ways of interacting with the data in the MySQL database management system. At the most basic level you could use command line queries to query the database and then there are other GUI’s including web applications like PHPmyadmin and MySQL’s official stand-alone application MySQL Workbench.
In this tutorial we will be using the MySQL Workbench application to interact with our database.
Downloading and Installing MySQL and MySQL Workbench
No comments:
Post a Comment
Please feel free to comment. No backlinks will be displayed.