Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Explain INSERT Statement in SQL ?

The insert statement will insert data into a defined table in the database.  Because it is usually easier to open the table in SQL. While inserting a row, if you are adding value for all the columns of the table you need not specify the column(s) name in the sql query. But you need to make sure the order of the values is in the same order as the columns in the table.

 

Syntax:

 

  INSERT INTO <table> (<column i, . . . , column j>)

  VALUES (<value i, . . . , value j>);

Related Posts Plugin for WordPress, Blogger...
Flag Counter