<h2 id="heading-motivation">Motivation</h2>
I daily read blogposts and one of the guy with 700 post motivated me write every single day.
<h4 id="heading-how-to-insert-data-in-a-table">How to insert data in a table</h4>
<pre><code>insert into employee (empid,empname) values(1,'sandy');
</code></pre><h4 id="heading-how-to-insert-data-only-in-some-columns">How to insert data only in some columns</h4>
<pre><code>insert into employee(empid) values(1);
</code></pre><h4 id="heading-how-to-insert-all-the-columns">How to insert all the columns</h4>
<pre><code>
insert into employee values(1,'amit');
insert into employee values(2,'dhruv');
insert into emplyee values(3,'vikky');
</code></pre>

## Motivation
I daily read blogposts and one of the guy with 700 post motivated me write every single day.

#### How to insert data in a table

```
insert into employee (empid,empname) values(1,'sandy');
```

#### How to insert data only in some columns

```
insert into employee(empid) values(1);
```

#### How to insert all the columns

```

insert into employee values(1,'amit');
insert into employee values(2,'dhruv');
insert into emplyee values(3,'vikky');

```



SQL : How to write insert Query?

Motivation

How to insert data in a table

How to insert data only in some columns

How to insert all the columns