Want to pursue Data Science? SQL is the most imperative skill required in it!
A Beginner's Guide to MySQL Queries part 4! π
RETRIEVAL & LOADING the data!
Thread π§΅
A Beginner's Guide to MySQL Queries part 4! π
RETRIEVAL & LOADING the data!
Thread π§΅
β
RETRIEVE THE DATA
The SELECT command allows the retrieval of information as per our requirements.
You can select/retrieve:-
1. All the data from the table using *
2. A single column
3. Multiple columns
The SELECT command allows the retrieval of information as per our requirements.
You can select/retrieve:-
1. All the data from the table using *
2. A single column
3. Multiple columns
1οΈβ£ Select all columns of the table
SELECT * from table_name;
π E.g., Selecting/Retrieving all the values from the classroom1 table.
2οΈβ£ Select one column from the table
SELECT column_name from table_name;
π E.g., Selecting the student_name column from the table classroom1.
SELECT * from table_name;
π E.g., Selecting/Retrieving all the values from the classroom1 table.
2οΈβ£ Select one column from the table
SELECT column_name from table_name;
π E.g., Selecting the student_name column from the table classroom1.
3οΈβ£ Select multiple columns from the table
SELECT colname1, colname2, colname3 from table_name;
π E.g., Selecting ID, student_name and age columns from classroom1 table.
Note: The retrieval of columns would be in the same order as the columns are mentioned in the table.
SELECT colname1, colname2, colname3 from table_name;
π E.g., Selecting ID, student_name and age columns from classroom1 table.
Note: The retrieval of columns would be in the same order as the columns are mentioned in the table.
β
LOAD THE DATA
To load the data from a file:-
Command -> source filename.sql
π E.g., source Desktop/mysqlsampledatafile.sql
To load the data from a file:-
Command -> source filename.sql
π E.g., source Desktop/mysqlsampledatafile.sql
β’ β’ β’
Missing some Tweet in this thread? You can try to
force a refresh
γ
