Creating a table in SQL
SQL i.e. Structured Query Language and is used to access the database. It is ANSI standard. SQL is also used to build the web sites. There are various commands used in sql such as:Insert, Delete, Update, Where, Select, Join, Distinct, etc. A table is a collection of data entries which consists of rows and columns. Select command is used to retrieve or fetch the data from the database.SQL performs various functions:
- SQL can execute queries against the database.
- It can be used to create a database.
- It can also creates a table in a database.
- It is used to insert the records in a database.
- It is used to update the existing records.
- It is also used to delete the existing records.
To create a table in sql first of all we must install the SQL server. Then click on Database and create the new database. After creating the database then click on Tables and create new table. We can also create multiple tables. Nowadays, I am creating a table in sql. Firstly, I created a single table and its very easy to create. But creating multiple tables is bit difficult. These multiple tables are created by using JOIN keyword. I hope soon I'll be able to learn much more about sql.
No comments:
Post a Comment