MySql Tutorials
MySql Tutorials, sql commands explaination in details
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
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
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
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
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
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 ?
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
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
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 (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
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
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
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
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
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
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.
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
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
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
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.
Some important study notes
