MySql Tutorials

MySql Tutorials, sql commands explaination in details


How to export MySql data to excel using php
How to export MySql data to excel using php

Exporting data from a MySQL database to Excel is a common task for many users, and it can be easily accomplished using PHP. PHP is a popular scripting language that is often used for web development, and it has built-in support for working with MySQL databases.

How to check MySql version in Ubuntu
How to check MySql version in Ubuntu

Check MySql version in Ubuntu
To check the version of MySQL installed on an Ubuntu system, you can use the following command:
mysql -V
This command will display the version of the MySQL server that is currently installed on the system.

How to delete duplicate records in Sql
How to delete duplicate records in Sql

To delete duplicate records in SQL, you can use the following syntax:
DELETE FROM [table_name] WHERE [primary_key] IN (SELECT [primary_key] FROM [table_name] GROUP BY [primary_key] HAVING COUNT(*) > 1);

How To Install MySQL on Ubuntu
How To Install MySQL on Ubuntu

Installing MySQL on Ubuntu is a straightforward process that can be easily accomplished using the apt package manager. Ubuntu is a popular Linux operating system that is often used for web development, and it comes with a built-in package manager that makes it easy to install and manage software packages.

Export mysql database | Complete tutorial
Export mysql database | Complete tutorial

Exporting a MySQL database is a common task that is often performed for backup and migration purposes. MySQL provides a number of different tools and utilities that can be used to export a database, and the specific method you use will depend on your requirements and preferences.

Cross Join in Sql with examples
Cross Join in Sql with examples

Cross Join in Sql
In SQL, a CROSS JOIN is a type of join that returns all possible combinations of rows from the tables being joined. It is sometimes called a cartesian join because it produces a result set that is the cartesian product of the sets of rows from the joined tables.

How to create database in MySql ?
How to create database in MySql ?

To create a database in MySQL, you can use the following steps:
Open a MySQL command prompt. This can be done by logging in to your MySQL server and running the mysql command.
Use the CREATE DATABASE statement to create a new database.

What is Sql | Examples of common SQL queries
What is Sql | Examples of common SQL queries

SQL (Structured Query Language) is a programming language used for managing and accessing data stored in relational databases. It is a standard language for working with relational databases, and it is used by many popular database management systems, such as MySQL, Oracle, and Microsoft SQL Server.

Sql merge statement with example
Sql merge statement with example

SQL MERGE statement
In SQL, the MERGE statement is used to combine data from two or more tables into a single table. It allows you to update, insert, or delete data in a target table based on data from a source table.

Sql commands with example
Sql commands with example

SQL (Structured Query Language) is a programming language used for managing and accessing data stored in relational databases. SQL uses a set of commands, known as SQL queries, to interact with the database.

Update query in mysql php | Complete explaination of Sql Update query
Update query in mysql php | Complete explaination of Sql Update query

To update data in a MySQL database using PHP, you can use the following steps:
Connect to the MySQL database using the mysqli_connect() function, which takes the database server hostname, username, password, and database name as arguments.

MySql – how to connect to database
MySql – how to connect to database

How to connect to database in MySql
To connect to a MySQL database, you need to use a MySQL client. Here is an example of how to connect to a MySQL database using the mysql command-line client:

SQL joins
SQL joins

Types of SQL Joins
In SQL, a join is a way to combine data from multiple tables based on a common field between them. This allows you to retrieve data from multiple tables with a single query and organize it in a meaningful way.

Query optimization in Sql
Query optimization in Sql

Query optimization
Query optimization is the process of improving the performance of SQL queries. This is done by identifying and addressing any issues that might be slowing down the query, such as slow-running operations or inefficiencies in the query itself.

Uses of evaluation
Uses of evaluation

The various uses of evaluation
Parents come to know about the progress of their wards –
It is important for the parents to know about the talents as well as shortcomings of their children

Read full article
Types of feedback
Types of feedback

Oral feedback or Face-to-face feedback
This includes giving oral feedback to a whole class after having marked their assignments, before or after returning their actual work to them.

Read full article
Measures of central tendency
Measures of central tendency

The values or measures which lie or fall in the centre or middle of the distribution or data are called measures of Central Tendency. Scores lie in the middle of the distribution.

Read full article
Supervised study and home assignment
Supervised study and home assignment

A Method of Teaching is a process of planning, guiding, sharing and evaluating learning with a group of students. It is a procedure the teacher follows to make learning easy and effective.

Read full article
Official Language and Schedules of the Constitution
Official Language and Schedules of the Constitution

Under Article 343, Hindi in Devanagari script was accepted as the official language of the Union. But, for a period of fifteen years from the commencement of the Constitution, the English language was allowed to be used for all the official purposes of the Union.

Read full article
National flower of India | National symbols of India
National flower of India | National symbols of India

National Flower of India
Lotus is the National Flower of India. Lotus who’s scientific name is Nelumbo Nucifera Gaertn, is a holly flower and occupies a unique and specific position in the art and mythology of ancient India. Lotus is an auspicious symbol in Indian culture.

Read full article