Thursday, 4 May 2017

How to add data to a table in sql

How to add data to a table in sql


In this post how to add data to a table in sql , we will discuss about inserting rows in sql tables. This is a very common question how to add data to a table in sql  . Adding data means inserting rows in sql tables. Before we insert data into tables , We first have to create tables in sql database. 
If the tables are already created, then before you enter data into a SQL database table, you have to know the name of the table as well as the various columns of the table. Along with names of the columns, we you have to be familiar with the data types of the various columns of the table.
Is this possible to know the name and data types of various columns of the table, yes this is quite simple to know the name of the columns and their data types. This can be done by using desc table command

Desc Table Command

The Desc Table command of SQL is to describe the structure of the table.
For example if we supply command like this : Desc employee;
This will display the whole structure of the employee table. It will display the name of the columns along with column specifications.
When you came to know the names of various columns and their data types, their widths and constraints, we can add rows to the table.
While inserting rows into tables, you have to take care with number of columns and their data types.
 
How to add data to a table in sql 1
How to add data to a table in sql

How to add data to a table in sql


To  to add data to a table in sql, we have to use insert into command. The use of sql insert statement is quite simple. 
sql insert statement
The sql insert statement is helpful in adding new rows to a table in sql.

The General Syntax of sql insert statement

Insert into <table name> values (value1, value 2,…);

Here table name is the name of the table in which you wants to add rows.
Suppose the name of the table is employee, the insert statement will be like this;

Insert into employee values (101, ‘SAM’);

After execution of the statement, the following message will be displayed
I row(s) created.
Here, you have to be care full, 101 will be added to first column of the table and SAM will be added to the second column of the table.
It is necessary to take care of data types of while inserting rows in a table.                   
With one insert into command, you can add only one row in a table. For Multiple rows , we have to use insert into command multiple times.
Few more examples of Insert into Command.
Given a table named employee with columns ecode->char(4), ename->varchar2(30), ecity->varchar2(30)
  Employee Table
Ecode
Ename
Ecity

Insert into employee values (‘E001’,’SAM’,’Florida’);
Here the first value E001 will be stored in first column of the table, second value SAM will be stored in second column of the table and third value Florida will be stored in  the third column of the table. In this case, user must be aware about the sequence of the columns of employee table. If by mistake he supply insert into command as Insert into employee values (‘SAM’,’E001’,’Florida’);
In this case employee name will be stored in employee code column and employee code will be stored in employee name column.

To avoid such problems, supply insert into like this:

Insert into employee(ecode, ename, ecity ) values (‘E001’,’SAM’,’Florida’);
How to add data to a table in sql oracle

How to add data to a table in sql

This will add a row in database table, in this case E001 will be stored in ecode, SAM will be stored in ename and Florida will be stored in ecity column of the employee table.
Main thing here is , you don't have to remember the sequence of columns in the table. You can supply the above insert into command as : Insert into employee (ename, ecode, ecity ) values (‘SAM’,’E001’,’Florida’);

Here you can see, we had altered the sequence of values, we had written SAM as first value and E001 as second value, we had also altered the sequence of column names in the above statement, ename is given first and then ecode.

How to insert multiple rows in SQL Table

To insert multiple rows in a table,  we have to supply insert into command as
Insert into employee values (&eocde, &ename,&ecity);

When you supply this command, the following output will be generate.

Enter Value for Ecode :
Here you have to supply value for ecode like ‘E001’
After this you will get –
Enter Value for Ename :
Here you have to supply value for ename like ‘SAM’
After this you will get –
Enter Value for Ecity :

Here you have to supply value for ecity like ‘Florida’

After this following message will be generated –
1 row(s) created.

After this sql prompt will come.
Sql>

Here you have to write run
Sql>run;

Run command of sql executes the last executable statement stored in Sql buffer. In this case it is : 

Insert into employee values (&eocde, &ename,&ecity);
Again you have to supply new values, you can repeat this step for as many times as you want.
So this was all about How to add data to a table in sql
Summary
We hope this post How to add data to a table in sql is informative and helpful to you. If you wish you can ask any question regarding this post. We will appreciate social media share of this post by you.


Saturday, 8 April 2017

Top Best 101 Unique Baby Names for Hindu Girl 2017

Top Best 101 Unique Baby Names for Hindu Girl 2017


The idea of this post Top Best 101 Unique Baby Names for Hindu Girl 2017 is to suggest Baby Names for Hindu Girl. In this post Top Best 101 Unique Baby Names for Hindu Girl 2017we had suggested Baby Names for Hindu Girl at random.

Baby Names for Hindu Girl
Baby Names for Hindu Girl


Baby Names for Hindu Girl starts with A
Aaital
Aarti
Aditi
Akshara
Aksheeta
akshita
Alka
Amita
Anara Gupta
Aneesha
Anita
Anjena
Anjori
Anlita
Anu
Anurita
Anuya
Apoorva
aradhya
Archana
Asha

Baby Names for Hindu Girl starts with B
Bhavya
Bhawna
Bhumika
Bidita
Bipasha
Baby Names for Hindu Girl 1
Baby Names for Hindu Girl


Baby Names for Hindu Girl starts with C
Chandana
Charu
Charul
Chan
Chandani
Chitra
Chanda

Baby Names for Hindu Girl starts with D
Deepti
Dimpi
Deepa
Deepshikha
Dolly
Divya
Diya
Devki
Dinki

Baby Names for Hindu Girl starts with E
Esha
Ekta
Eshita
Eshika


Baby Names for Hindu Girl starts with G
Gayatri
Gayatri
Gia

Baby Names for Hindu Girl starts with H
Himanshi
Hrishitaa
Heena
Hritika
Harali
Hana
Harnoor
Hoor

Baby Names for Hindu Girl starts with J
Jasmin
Juhi
Jui
Jagruthi
Jalbala
Janaki
Janaki
Jasweera

Baby Names for Hindu Girl starts with K


Kitu
Kalya
Kamya
Kamya
Kajal
Kashika

Baby Names for Hindu Girl starts with L
Lovely
Leena
lakshita
Loveleen


Baby Names for Hindu Girl starts with M
Madhuri
Mahak
Mahima
Malathi
Malika
Megha
Mona
Monica

Baby Names starts with N
Naina
Nandita
Neetu
Nikita
Nisha

Baby Names  starts with P
Panchi
Pavani
Pooja
Pooja
Priya
Priyanka
Priyanka
Protima


Baby Names starts with R


Raashi
Radha
Rani
Renu
Riya
Riya
Rohini
Roma
Roshni
Rucha


Baby Names  starts with S


Sahithya
Sakshi
Saloni
Sameera
Samita
Sangeeta
Sangita
Sayali
sejal
Shaurya
Sheeba
Shikha
Shivani
Shruti
Shweta
Sindhura
Siya
Snigdha
Sona
Sonal
Sonali
Sonam
Soumili
Sukanya
Suma
sunaina
Supriya

Baby Names for Hindu Girl starts with T
Tiya
Tapur
Baby Names for Hindu Girl starts with U

Udita
Umang

Wrapping it up


So, these are some interesting Baby Names for Hindu Girl .Feel free to give your suggestions in comment. Help us to spread this more using social share buttons given below.

Friday, 10 March 2017

Top big data sources examples

Top Big Data Sources examples 

In this post Top Big Data Sources examples  , we will discuss about various sources of big data in this post. This is a very common question Big Data SourcesBig data is talk of the town these days. 

Main Big data sources

  • Social media data
  • Banking data
  • Traffic analysis data
  • Online transactions
  • Use of credit cards
  • Use of debit cards
  • Use of search engines
  • Use of Emails
  • Customer queries
  • e learning
  • online surveys
  • Online shoping
why to study sources of big data
The main advantage of big data study is predictive analysis, by analyzing big data we can analyse customer behavior in case of shopping web sites.
watch this video on youtube click here

Thursday, 16 February 2017

core php programming examples

Core php Programming Examples 


core php programming examples to swap two numbers 
<?php
$a=20;
$b=10;
echo  "a="." ".$a."  "."b="."  ".$b;
$temp=$a;
$a=$b;
$b=$temp;
echo "<br>";
 echo "after swapping A is"."  ".$a." "."and b is"."  ".$b ;
?>

core php programming examples to Fahrenheit temperature into Celsius 
<?php
$f=55 ;
$c=($f-32)*5/9;
echo $c;
?>
Program to print even numbers between 1 and 20 in php
<?php
for($i=1;$i<=20;$i++)
{
if($i%2!=0)
{
echo $i."  ";
}
}

Program in php to print first 10 natural numbers
<?php
for($i=1;$i<11;$i++)
{
echo $i ."  ";
}
?>

Program in php to generate pyramid
<?php
$i=1;
for($i=1; $i<=3; $i++)
{
for($j=1; $j<=$i; $j++)
{
echo '*';
}
echo '<br/>';
}
?>

Tuesday, 18 October 2016

best iphone deals in india 2016

Best  iphone deals in India 2016  

Here in this post best  iphone deals in india 2016 , we will have an idea about best  iphone deals in india 2016  .

Best Offers on iPhones  , Exclusively here.






Apple iPhone 7 (Gold, 128GB)
         


12MP primary camera with optical image stabilisation, Quad-LED True Tone flash and Live Photos, 4K video recording at 30 fps and slow-motion video recording in 1080p at 120 fps, 7MP front facing FaceTime. 4.7-inch (diagonal) Retina HD 3D Touch capacitive touchscreen display and home button with 1334x750 resolution and wide colour, Splash, water and dust resistant

Apple iPhone 7 (Black, 32GB)

12MP primary camera with optical image stabilisation, Quad-LED True Tone flash and Live Photos, 4K video recording at 30 fps and slow-motion video recording in 1080p at 120 fps, 7MP front facing FaceTime HD camera 4.7-inch (diagonal) Retina HD 3D Touch capacitive touchscreen display and home button with 1334x750 resolution and wide colour, Splash, water and dust resistant

Apple iPhone 6s (Rose Gold, 16GB)

12MP primary camera with auto focus, 4K video recording, flash and 5MP front facing camera 4.7-inch (11.4 centimeters) Retina HD 3D-touch capacitive touchscreen with 1334 x 750 pixels resolution and 326 ppi pixel density iOS v9 operating system with A9 chip 64-bit architecture processor, 2GB RAM, 16GB internal memory and single nano SIM

Apple iPhone 5s (Space Grey, 16GB)

8MP primary camera with true tone flash, auto focus, geo tagging, face detection burst mode, 1.2MP front facing camera with HD video recording and backside illumination sensor 4-inch multi-touch retina display with 1136 x 640 pixels resolution iOS 7 operating system with 16GB internal memory

Apple iPhone 5s (Silver, 16GB)

8MP primary camera with true tone flash, auto focus, geo tagging, face detection burst mode, 1.2MP front facing camera with HD video recording and backside illumination sensor 4-inch multi-touch retina display with 1136 x 640 pixels resolution

Apple iPhone 7 (Black, 128GB)

12MP primary camera with optical image stabilisation, Quad-LED True Tone flash and Live Photos, 4K video recording at 30 fps and slow-motion video recording in 1080p at 120 fps, 7MP front facing FaceTime HD camera , 4.7-inch (diagonal) Retina HD 3D Touch capacitive touchscreen display and home button with 1334x750 resolution and wide colour, Splash, water and dust resistant

Apple iPhone 6s (Gold, 64GB)

12MP primary camera with auto focus, 4K video recording, flash and 5MP front facing camera 4.7-inch (11.4 centimeters) Retina HD 3D-touch capacitive touchscreen with 1334 x 750 pixels resolution and 326 ppi pixel density iOS v9 operating system with A9 chip 64-bit architecture processor, 2GB RAM, 64GB internal memory and single nano SIM











Buy iPhone 6s (16GB) from Snapdeal
iPhone 6s

iPhone 6s (16GB)










After going through this post best  iphone deals in india 2016    , readers will be able to explore the features and prices of iphone5, iphone6 and iphone7.