SQL Teaching

In SQL, data is usually organized in various tables. For example, a sports team database might have the tables teams, players, and games. A wedding database might have tables guests, vendors, and music_playlist.

Imagine we have a table that stores family members with each member's name, species, gender, and number of books read.

Let's start by grabbing all of the data in one table. We have a table calledfamily_members that is shown below. In order to grab all of that data, please run the following command: SELECT * FROM family_members;

The * above means that all of the columns will be returned, which in this case are id, name, gender, species, and num_books_read.

Note: This tutorial uses the SQLite database engine. The different variants of SQL use slightly different syntax.
 
SQL:
Run SQL
Result:
 
Current tables:
family_members
 
idnamegenderspeciesnum_books_read
1Davemalehuman200
2Maryfemalehuman180
3Picklesmaledog0

this is not original website it is link website
tnks for watch this site


ritesh pandey resume click for download
Ritesh Pandey Resume

संपर्क के लिए विवरण भरे

*required
Send message