Category: MySQL
10 posts
Create Function to Insert Post and Update Post in Single Function using PHP
Hello there, In this tutorial we will learn how to create function to insert post and update post in single function using core php, here's an example function that can both insert a new post and upda... Read Mores
Prathmesh Yelne
23-Mar-2023 9:12:24
How to Send Realtime Notifications if User Follow using PHP & Mysql
Hello there, in this tutorial we will learn how to send real-time notifications to a user when someone follows them, you can use a combination of PHP and MySQL along with a WebSocket connection. Here ... Read Mores
Prathmesh Yelne
17-Mar-2023 21:31:15
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
How to Find the Nth Highest Salary in SQL ?
Finding the nth highest salary in SQL is a common interview question and a practical task in database management. Here are several approaches to solve this problem, each with detailed explanations and... Read Mores
Prathmesh Yelne
20-Jun-2024 17:29:50
How to insert multiple rows in SQL ?
To insert multiple rows in SQL we can follow the below syntax:
INSERT INTO table_name (column1, column2,column3...)
VALUES
(value1, value2, value3…..),
(value1, value2, value3….),
... Read Mores
Prathmesh Yelne
16-Dec-2021 16:49:13
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
What is a unique key in SQL ?
Unique Key is a constraint in SQL. So, before understanding what exactly is a primary key, let’s understand what exactly is a constraint in SQL. Constraints are the rules enforced on data columns on... Read Mores
Prathmesh Yelne
16-Dec-2021 16:40:54
How to delete a column in SQL ?
To delete a column in SQL we will be using DROP COLUMN method:
ALTER TABLE employees
DROP COLUMN age;
We will start off by giving the keywords ALTER TABLE, then we will give the name of the tab... Read Mores
Prathmesh Yelne
16-Dec-2021 16:39:14
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
What is MYSQL ?
To understand exactly what is MYSQL, we need to understand what is DBMS and RDBMS. DBMS stands for Database Management System. When we have a huge database with us, we would need a proper managemen... Read Mores
Prathmesh Yelne
14-Dec-2021 17:11:27
What is Primary Key in SQL ?
Introduction :
In the world of databases, a primary key is a fundamental concept that plays a crucial role in maintaining data integrity and ensuring efficient data retrieval. It is a concept th... Read Mores
Prathmesh Yelne
24-Jul-2023 17:44:20
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
How to insert date in SQL ?
If the RDBMS is MYSQL, this is how we can insert date:
INSERT INTO tablename (col_name, col_date) VALUES (‘DATE: Manual Date’, ‘2020-9-10’);
... Read Mores
Prathmesh Yelne
14-Dec-2021 17:00:30
How to Create a Table in SQL – Postgres and MySQL Example Query
Knowing how to create tables in SQL is an important and fundamental concept.
In this tutorial, I will walk you through the SQL syntax for the CREATE TABLE statement using code examples for bo... Read Mores
Prathmesh Yelne
27-Oct-2021 16:44:42
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago