Javatpoint Logo

91-9990449935

 0120-4256464

Javatpoint Logo

SQL INSERT INTO VALUE

There are two ways to insert values in a table.

In the first method there is no need to specify the column name where the data will be inserted, you need only their values.

The second method specifies both the column name and values which you want to insert.

Let's take an example of table which has five records within it.

It will show the following table as the final result.

ROLL_NONAME AGECITY
1ABHIRAM22ALLAHABAD
2ALKA20GHAZIABAD
3DISHA21VARANASI
4ESHA21DELHI
5MANMEET23JALANDHAR

You can create a record in CUSTOMERS table by using this syntax also.

The following table will be as follow:

ROLL_NONAMEAGECITY
1ABHIRAM22ALLAHABAD
2ALKA20GHAZIABAD
3DISHA21VARANASI
4ESHA21DELHI
5MANMEET23JALANDHAR
6PRATIK24KANPUR




Latest 4 Tutorials on JavaTpoint