If we do not require a table in a database then we can simply delete it by using the SQL DROP TABLE command. DROP TABLE comes very usefully when we especially want to delete the complete table, and while deleting a table make sure that you delete the correct one. Syntax Follow this syntax to delete a table… Read More »
After creating and selecting a database using CREATE and USE commands now we can create a table inside that database, and keep remember we can create more than one table in a single database. What is a Table in the Database? A table is a collection of rows and columns which form cells like structure and the data… Read More »
If we have multiple Databases in our SQL schema then in order to operate on specific database first, we need to select that it then only we are capable of using the queries on that database. To select a database amongst the multiples ones we use the SQL USE command. Syntax Follow this syntax to select a specific… Read More »
In SQL we have various operators to perform operations on data, and an operator can be represented by a special symbol or by a reserved character. Operators always used along with the SQL statements and they come very handy to perform reading and writing operations. The operators in SQL are divided into 3 major categories: Arithmetic operators Comparison… Read More »
When we use two or more than two combinations of values, operators and SQL functions, then it is considered as an expression. We write an expression as a statement or query which act as a formula to show some output. We often use various expressions to query a database. Expression Syntax SELECT column_name_1, column_name_2, column_name_N FROM table_name WHERE… Read More »
The first step of using SQL is creating a Database, and in Relational Database Management System to create a Database we use the CREATE SQL command. As in the previous SQL tutorials we have mentioned that we cannot have two databases with a similar name so before you name your database make sure that the similar name database… Read More »
Once we have created a database in SQL, we can also delete it by using the SQL DROP command. Syntax follow this syntax to delete a database: DROP DATABASE Database_name; Example let first create a temporary database. CREATE DATABASE temp_db; Output Query OK, 1 row affected (0.29 sec) Verify if the database is created: SHOW DATABASES; Output +——————–+… Read More »
The SQL data type signifies, which type of data would be stored in a specific column, this mean each column has a specific data type. When we create a table then only, we are able to set the data type of each column or when we create a new one. It’s the Job of the SQL developer to… Read More »
Handling and maintaining massive data set would be a heck of a task if it not for database tools. These database technologies make it simple and organized. Every set of application, whether it is a native software or web applications, they all depend on a database for the dynamic approach of content management. These days almost every web-application… Read More »
Every SQL RDBMS follow a similar set of rules and syntax which are known as queries and statements. While writing the queries in SQL we have to take care of syntax, if we write a query with invalid syntax then the SQL throw some errors. Every SQL query or statement starts with a command like SELECT, INSERT, UPDATE,… Read More »
