MySQL Introduction : Java Techies

Java Techies- Solution for All Java Techies- Solution for All

MySQL Database

1.1 Understanding on General Database concepts

A database is an application that organized a collection of data to store in particular way.
Learn More...

1.2 Feature of MySQL Database

MySQL is a free, open-source database engine available for different platforms. MySQL represents an introduction to modern database technology for high-volume application.
Learn More...

1.3 Install the MySQL Server on windows

To install MySQL database, follow the given below options and setup MYSQL -
Learn More...

1.4 Starting MySQL Database

Before start the MySQL Server, you should set the path for MySQL Server. To set the path of MySQL Server, you need to follow some steps given below -
Learn More...

1.5 Retrieving Information from a Table

This content provides introduction of various queries to retrieving Information from table by using where and like clause .
Learn More...

1.6 Retrieving Information from two or more Table by using MySQL Join

Normally we are retrieve information from one table ay a time. This is correct for simple application, but in real time application MySQL uses queries to get data from multiple tables in a single query.
Learn More...

1.7 MySQL Functions and Grouping query data with aggregate functions

In MySQL you can create own function to return specific data. Function are normally used for computation.
The retutn clause is mandatory for a function. It indicates the return type of the function, and the function body must contain a RETURN value statement.
Learn More...

1.8 MySQL Stored Procedure

A stored procedure is a procedure that is used to store data into database and retrieve data from multiple tables.
Stored procedure has a name, a parameter list, and an SQL statement, which can contain many more SQL statements.
Learn More...

1.9 Import/Export mysql Data

To import and export data from table to text file using command line you can use some queries which will further given ahead -
Learn More...

1.10 MySQL Storage Engines

A storage engine is a software system that stores, handles, and retrieves information from a table. MySQL supports several storage engines that act as handlers for different table types.
Learn More...

1.11 MySQL Queries

Your privacy is very important to us. Accordingly, we have developed this Policy in order for you to understand how we collect, use, communicate and disclose and make use of personal information. The following outlines our privacy policy.

Before or at the time of collecting personal information, we will identify the purposes for which information is being collected.
We will collect and use of personal information solely with the objective of fulfilling those purposes specified by us and for other compatible purposes, unless we obtain the consent of the individual concerned or as required by law.
We will only retain personal information as long as necessary for the fulfillment of those purposes.
We will collect personal information by lawful and fair means and, where appropriate, with the knowledge or consent of the individual concerned.
Personal data should be relevant to the purposes for which it is to be used, and, to the extent necessary for those purposes, should be accurate, complete, and up-to-date.
We will protect personal information by reasonable security safeguards against loss or theft, as well as unauthorized access, disclosure, copying, use or modification.
We will make readily available to customers information about our policies and practices relating to the management of personal information.

We are committed to conducting our business in accordance with these principles in order to ensure that the confidentiality of personal information is protected and maintained.

COOKIE POLICY
To enhance your experience on our sites, many of our web pages use “cookies”. Cookies are small text files that we place in your computer’s browser to store your preferences. Cookies, by themselves, do not tell us your email address or other personal information unless you choose to provide this information to us by, for example, registering at one of our sites. Once you choose to provide a web page with personal information, this information may be linked to the data stored in the cookie. A cookie is like an identification card. It is unique to your computer and can only be read by the server that gave it to you.

We use cookies to understand site usage and to improve the content and offerings on our sites. For example, we may use cookies to personalise your experience on our web pages (e.g. to recognise you by name when you return to our site). We also may use cookies to offer you products and services.

Cookies save you time as they help us to remember who you are. Cookies help us to be more efficient. We can learn about what content is important to you and what is not. We can revise or remove web pages that are not of interest and focus our energies on content you want.

If you want to control which cookies you accept. You can configure your browser to accept all cookies or to alert you every time a cookie is offered by a website’s server. Most browsers automatically accept cookies. You can set your browser option so that you will not receive cookies and you can also delete existing cookies from your browser. You may find that some parts of the site will not function properly if you have refused cookies.

Please be aware that if you do not configure your browser you will accept cookies provided by this website.

How to see cookies that you have accepted. You can configure your browser to accept all cookies or to alert you every time a cookie is offered by a website’s server.