Refer SQL-create Database & Table and create a Database named "Studysql" and a table named "tbl_biodata"
The created Table and Database in SQL is :
Next step is , right click on the id field , and select Set Primary Key option , so that the id field can't repeat ( see a key symbol is appeared near to the id field).
Also from the column properties, set identity sepcification as YES (So that it will increment by one by entering each field).
See the figure below :
And , save the table (tbl_biodata) , then write clock on the table name and select OPEN TABLE from the drop down menu.
(Note that , a star (*) can see on the table name , and it indicate that the table is not saved. See the below picture, and we can see that the star is not there , which shows that the table , tbl_biodata , is saved).
Then start entering details .
After entering values , the table :
How to type SQL-Query ?
Select the created Database "Studysql" and right click to select "New Query" .
Then a code window will appear , and we can write Queries there.
How to Execute SQL-Query ?
Select the menu Query Designer and then click on the option Execute Query . You can use CTRL + R also .
Or , See the symbol for executing Query as given below :
Now , we are going to apply SQL Commands in this table, from next chapter onwards.
ID
|
NAME
|
AGE
|
CITY
|
PHONE
|
1
|
Priyada
|
25
|
Cochin
|
1000000001
|
2
|
Mohan
|
30
|
Cochin
|
2000000002
|
3
|
Jaimon Jacob
|
40
|
Vytila
|
3000000003
|
4
|
Sumith
|
24
|
Kottayam
|
4000000004
|
5
|
Shaiju
|
36
|
Thrissur
|
5000000005
|
The created Table and Database in SQL is :
Next step is , right click on the id field , and select Set Primary Key option , so that the id field can't repeat ( see a key symbol is appeared near to the id field).
Also from the column properties, set identity sepcification as YES (So that it will increment by one by entering each field).
See the figure below :
And , save the table (tbl_biodata) , then write clock on the table name and select OPEN TABLE from the drop down menu.
(Note that , a star (*) can see on the table name , and it indicate that the table is not saved. See the below picture, and we can see that the star is not there , which shows that the table , tbl_biodata , is saved).
Then start entering details .
After entering values , the table :
How to type SQL-Query ?
Select the created Database "Studysql" and right click to select "New Query" .
Then a code window will appear , and we can write Queries there.
How to Execute SQL-Query ?
Select the menu Query Designer and then click on the option Execute Query . You can use CTRL + R also .
Or , See the symbol for executing Query as given below :
Now , we are going to apply SQL Commands in this table, from next chapter onwards.
