MySql Features

MySQL Features

• Relational Database Management System (RDBMS): MySQL is a relational database management system.
• Easy to use: MySQL is easy to use. You have to get only the basic knowledge of SQL. You can build and interact with MySQL with only a few simple SQL statements.
• It is secure: MySQL consist of a solid data security layer that protects sensitive data from intruders. Passwords are encrypted in MySQL.
• Client/ Server Architecture: MySQL follows a client /server architecture. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, they query data, save changes, etc.
• Free to download: MySQL is free to use and you can download it from MySQL official website.
• It is scalable: MySQL can handle almost any amount of data, up to as much as 50 million rows or more. The default file size limit is about 4 GB. However, you can increase this number to a theoretical limit of 8 TB of data.
• Compatibale on many operating systems: MySQL is compatible to run on many operating systems, like Novell NetWare, Windows* Linux*, many varieties of UNIX* (such as Sun* Solaris*, AIX, and DEC* UNIX), OS/2, FreeBSD*, and others. MySQL also provides a facility that the clients can run on the same computer as the server or on another computer (communication via a local network or the Internet).
• Allows roll-back: MySQL allows transactions to be rolled back, commit and crash recovery.
• High Performance: MySQL is faster, more reliable and cheaper because of its unique storage engine architecture.
• High Flexibility: MySQL supports a large number of embedded applications which makes MySQL very flexible.
• High Productivity: MySQL uses Triggers, Stored procedures and views which allows the developer to give a higher productivity.

Disadvantages / Drawback of MySQL:

• MySQL version less than 5.0 doesn't support ROLE, COMMIT and stored procedure.
• MySQL does not support a very large database size as efficiently.
• MySQL doesn't handle transactions very efficiently and it is prone to data corruption.
• MySQL is accused that it doesn't have a good developing and debugging tool compared to paid databases.
• MySQL doesn't support SQL check constraints.

Hope you guys like it. Please comment for any doubts.

Happy Learning !!!

Read More»

What is MySql

What is MySQL

• MySQL is a fast, easy to use relational database. It is currently the most popular open-source database. It is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.
• MySQL is used for many small and big businesses. It is developed, marketed and supported by MySQL AB, a Swedish company. It is written in C and C++.

Reasons of popularity

• MySQL is an open-source database so you don't have to pay a single penny to use it.
• MySQL is a very powerful program so it can handle a large set of functionality of the most expensive and powerful database packages.
• MySQL is customizable because it is an open source database and the open-source GPL license facilitates programmers to modify the SQL software according to their own specific environment.
• MySQL is quicker than other databases so it can work well even with the large data set.
• MySQL supports many operating systems with many languages like PHP, PERL, C, C++, JAVA, etc.
• MySQL uses a standard form of the well-known SQL data language.
• MySQL is very friendly with PHP, the most popular language for web development.
• MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).
• MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.

Hope you guys like it. Stay tune for more on MySql. Please comment for any doubts.

Happy Learning !!!

Read More»

MySql Tutorial

MySQL tutorial

• MySQL tutorial provides basic and advanced concepts of MySQL.
• MySQL is a relational database management system. It is open-source and free.
• MySQL tutorial includes all topics of MySQL database including CRUD(Create, Read, Update, Delete) operations. We have also introduce an interview section for MySql.

Prerequisite

We assume that you have basic understaning about Computer Fundamentals and RDMS

Audience

Our MySQL tutorial is designed for both beginners and professionals.

Read More»

How to connect MS Access data base using JDBC in JSP

In this post we are going to discuss about , how to connect MS Access using JDBC in JSP.

SOURCE : msaccessconnection.jsp

Hi, I have written and developed this post so that most of people will be benefited. I'm committed to provide easy and in-depth tutorials on various technologies.I hope it will help you a lot. - Manigandan K
Follow Me @Google+

Read More»