July 06 2019 by
Admin
In this article, we have described how to create a table (Insert, Update and Delete) in SQL
In this article, we have described how to create a table (Insert, Update and Delete) in SQL.
In this example, We have created a table with auto-increment or primary key.
Also adding (inserting), deleting, and updating data in the table via SQL is explained.
Create Table Statement
We have explained a create table statement after performing that statement, we have shared the output below.
Screenshot
Insert into statement.
We have inserting some member records below.You can have a look at it and learn.
Screenshot
update statement
We have updating some record based on id using where clause.You can have a look at it and learn.
Screenshot
Delete statement
we have performed deleting activity based on some record using where clause. You can have a look at it and learn.
Screenshot
Truncate statement
we have performed truncate activity below. which is DDL(Data defination langunage ) Statement
Screenshot
Note: All contents are copyright of their authors.