Classification of SQL Queries

SQL (Structured Query Language) is a standard language for managing and manipulating databases. SQL is divided into different languages or subcategories based on the type of operation it performs. Here's a classification of SQL languages along with examples of queries:1. **Data Query Language (DQL)**:   - **Purpose**: Used to retrieve data from a database. ...

Read More

Solved: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Follow the given steps to solve the issue. The commands here are for CentOS 8. The solution is same for other OS as well so modify the commands accordingly.Step 1: After the installation of MYSQL is finished, enable and start mysqld as given below:sudo systemctl start mysqldsudo systemctl enable mysqldOnce, done also check the status of the mysqld to verify whether it is running...

Read More

Steps to install HTTPD, PHP, MYSQL and PHPMYADMIN in CentOS 8

Steps to install httpd in CentOS 8sudo yum install dnfsudo dnf updatesudo dnf install httpdsudo systemctl start httpdsudo systemctl enablr httpdsudo systemctl enable httpdsudo firewall-cmd --add-service=http --permanentsudo firewall-cmd --reloadsudo systemctl status httpdsudo dnf update Steps to install PHP in CentOS 8sudo dnf updatesudo dnf install epel-releasesudo...

Read More

Medical store management system with visualization of data (using visual C#.NET and MYSQL)

Send your query regarding this project through email...

Read More

How to restore/import dump file in MySQL workbench ?

The following steps can be applied to import dump file : 1. Open MySQL workbench and connect to database using your password. You can see the window as given below: 2. You will be provided two ways to import the dump files. First, you can import the dump files by selecting the option "import from dump project folder". Here you can select the folder where all your dump...

Read More

How to backup data in MySQL workbench ?

The following steps can be applied to backup data in MySQL using workbench : 1. Open workbench and connect to your database using your username and password. 2. Click on "Data Export" option under "Management" at the left side of the screen. 3. You will find a list of schema from where you can select which of the schema's table do you want to backup. If you want to...

Read More