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

53 Views MySQL, PHP, SQL 2 years ago

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

207 Views MySQL, PHP, Server Side Programming 2 years ago
avatar
Google

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

50 Views DBMS, MySQL, SQL 4 months ago

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

38 Views DBMS, MySQL, SQL 3 years ago
avatar
Google

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

28 Views DBMS, MySQL, SQL 3 years ago

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

40 Views Database, DBMS, MySQL, SQL 3 years ago
avatar
Google

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

27 Views MySQL 3 years ago

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

43 Views DBMS, MySQL, RDBMS, SQL one year ago
avatar
Google

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

28 Views MySQL, SQL 3 years ago

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

35 Views Backend, MySQL, Postgres, SQL 3 years ago
avatar
Google

September 11, 2020

2.2 K Views GCP Cloud Engineer 21 hours ago