MySQL
MySQL is an open-source relational database management system
Top MySQL Articles
Temporary Table in SQL
Temporary Table in SQL. What is Temporary Table in SQL? How to create a temporary Table in SQL? As the name describes , a temporary table is a table created to store temporary data in the database. You can perform SQL operations similar to the permanent table, such as CREATE, UPDATE, DELETE, INSERT, JOIN and more. Temporary tables are automatically deleted when the current client session is terminated. If needed, you can also explicitly delete a temporary table within the session.
How to Truncate a Table in SQL
TRUNCATE Table command in SQL | how to TRUNCATE TABLE in a database | how to TRUNCATE TABLE in SQL | TRUNCATE TABLE in MYSQL, SQL Server and Oracle
How to Rename a Tables in SQL
Rename Table command in SQL | how to rename a table in a database | how to rename a table in SQL | rename tables in MYSQL, SQL Server and Oracle
How to Show Tables in SQL
SHOW Table command in SQL | how to show all tables in a database | list of all user define tables in SQL | show tables in MYSQL, SQL Server and Oracle | retrieve list of all database tables in relational database.
DROP DATABASE in SQL
The SQL DROP DATABASE statement is a powerful command in SQL that is used to permanently delete an existing database from a system, including all its data, tables, views, indexes, stored procedures , constraints and any other elements that belong to it. Once executed, the database and all its contents are permanently deleted and cannot be recovered unless a backup is available. This command should be used with caution, because it permanently deletes the database and all its contents.
CREATE Database in SQL
A database is an organized collection of data stored in a computer system, designed to facilitate efficient data storage and retrieval. Different query languages can be used to create and manage databases and SQL is one such language. Creating a database in SQL is one of the first steps in setting up a structured environment to store and manage data efficiently. After creating a database you can start creating tables, views, stored procedures and other database objects within it.
JOIN in SQL
Join in SQL, JOIN is an SQL operation that combines data from two or more tables based on relationships between columns. JOIN is the most powerful features of SQL to combine data from multiple tables. In this article, we will explore what SQL JOINs are, syntax of SQL JOIN, type of SQL JOINs ( inner join , left join , right join etc), Key Characteristics of SQL JOIN etc
LIKE Operator in SQL
LIKE is an operator. SQL like query syntax. LIKE operator is used in SQL to match a specified pattern within a column containing text data. LIKE supports the use of wildcard characters ( % and _) for pattern matching. Mastering the LIKE operator enhances the ability to perform complex searches, retrieve targeted data, and extract valuable insights from datasets.
AVG in SQL
AVG in SQL Syntax : AVG(colum_name) or AVG(expression). how to compute avg in SQL? AVG function is a aggregate function that is designed to compute the average of specified column or expression. AVG operates on numeric data types (integer, decimal, floating-point) and AVG is particularly useful for performing aggregate calculations across datasets. This article provides a detailed overview of AVG aggregate function with example.
SUM in SQL
SUM in SQL Syntax : SUM(colum_name). SUM function is a aggregate function that is designed to compute the sum or total of values within a specified column or expression. SUM operates on numeric data types (integer, decimal, floating-point) and SUM is particularly useful for performing aggregate calculations across datasets. This article provides a detailed overview of count aggregate functions with example.
Popular Topics
GitGit Commitgit branchArchitecturegit pullLanguage-Conceptsgit commandsGitHubJavaHashMap
Git is an open-source distributed version control system.
Git Commit
git branch is a command used to manage branches
architecture
git pull is a command used to fetching changes form remote repo
This tag is used to understand a basic part of the language.
List of all git commands
GitHub is a web-based hosting service for software development projects that use Git for version control.
Java is a high-level object-oriented programming language. it's firstly released by Sun Microsystems in 1995. Use this tag when you're having queries using or understanding the language. This tag is also applicable to Java libraries and frameworks.
HashMap is a Data Structure.
Popular Articles
System Design Interview Questions | System Design Interview Questions for Freshers | Job Interview System Design Questions | Practice with common System Design Interview Questions | Top companies System Design Interview Questions | Frequently asked System Design Interview Questions
Prepare for your next tech interview with these top Java interview questions and expert answers. Boost your confidence and crack Java interviews.
Mastering the Template Design Pattern in C#, Template Design Pattern in Depth: Structure, Use Cases and Best Practices
how to install docker on amazon ec2 instance. docker installation command on linux machine
Master the Top Design Patterns for Interviews With Real-World Examples | preparing for system design or LLD interviews, learning Design Patterns is essential.
LLD interview preparation Guideline
9 Clean Coding Principles To Keep In Mind, Mastering clean code is essential for building maintainable, scalable, and bug-free software.
Learn everything about React Hooks from useState and useEffect to custom hooks, performance optimization and real-world use cases. Ideal for beginners to advanced developers.
Collections in c# | c# collections | type of collection in c# | collection classes and operations
How to deploy a React application to an Amazon EC2 instance (Amazon Linux instance) using Nginx to serve the build files. We will also set up Node Version Manager (NVM) to manage Node.js versions on the EC2 machine and ensure proper directory permissions for smooth deployment.
Most Popular Tools
Explore our top online tools including a blank page for notes, a QR code generator, word counter and collaborative editor. These free, easy-to-use utilities help you write, analyze, share and organize content faster. Perfect for developers, creators and students to streamline everyday digital tasks efficiently.
Blank Page
Create a blank canvas for your ideas, notes or sketches. Use this tool for rough work and jotting down your thoughts
QR Code Generator
A QR Code Generator is a tool that instantly converts text, URLs or other data into a scannable QR code. Users can create custom QR codes for websites, contact info or messages. It's commonly used for quick access, sharing and printing without needing a backend or complex setup.
Word Counter
Perform various string operations like counting characters, words or letters.
Collaborative Editor
Collab Editor is a powerful, free-to-use online platform that lets you collaborate in real-time. Whether you re working on documents, brainstorming idea, or discussing projects etc