SQL Basic- SQL Syntax

SQL Basic- SQL Syntax

21:29

          SQL Syntax:           






SQL Syntax

Database Tables

A database contains one or more tables. Each table is identified by a name (e.g. "Student" or "Product"). 

Tables contain records (rows) with data.

Below is a selection from the "Student" table:


StudentID            StudentName              Address               Country
1            Ajay              Noida               India
2            Ajeet              Bareilly               India
3            Shivam              Nagaland               India

The table above contains three records (one for each student) and four columns (StudentID, StudentName, Address, Country).



SQL Statements

Most of the actions you need to perform on a database are done with SQL statements.The following SQL statement selects all the records in the "Student" table:




Exmaple:

              SELECT * FROM Student         


After executing this statement, You see result as follows:



StudentID            StudentName              Address               Country
1            Ajay              Noida               India
2            Ajeet              Bareilly               India
3            Shivam              Nagaland               India

About

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Subscribe to: Post Comments ( Atom )