Saturday 14 September 2013

Create in SQL

The basic sql commands are as follows;-

Create;-this command is used in sql for creating the table.in which we store the data in form of row and column.table consist of row and column..

Ex-

in this "vai " is the table name .
in parenthesis we insert the column name where first column is id second column is name and third column is age.the datatype of id is" int' .for the string value we take "varchar " as a datatype. for varchar we must pass the size.

output;-it displays only column name.

No comments :

Post a Comment