Insert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total). Student studentNumber SchoolNumber firstname lastName birthDate 2411 45 Harry Potter 2006-09-15 1217 45 Ron Weasley 2005-08-17 1093 45 Hermione Granger 2006-11-24 2600 45 Neville Longbottom 2007-11-01 2258 54 Topanga Lawrence 2008-03-05 2895 54 Cory Mathews 2007-02-17 1601 54 Eric Mathews 2005-08-22 2725 54 Shawn Hunter 2008-05-31 2056 119 Taylor Kitsch 2009-08-08 2168 119 Zach Gilford 2005-08-02 1803 119 Tyra Collette 2007-08-02 2213 119 Jason Street 2006-01-17 2932 345 Abed Nadir 2007-04-15 2492 345 Jeff Winger 2008-08-10 1440 345 Britta Perry 2006-05-21 2036 345 Annie Edison 2006-05-25 2732 93 Zack Morris 2008-02-18 1927 93 Kelly Kapowski 2009-02-22 1448 93 Jessie Spano 2007-02-15 1972 93 Samuel Powers 2007-04-14
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Insert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total).
Student
studentNumber |
SchoolNumber |
firstname |
lastName |
birthDate |
2411 |
45 |
Harry |
Potter |
2006-09-15 |
1217 |
45 |
Ron |
Weasley |
2005-08-17 |
1093 |
45 |
Hermione |
Granger |
2006-11-24 |
2600 |
45 |
Neville |
Longbottom |
2007-11-01 |
2258 |
54 |
Topanga |
Lawrence |
2008-03-05 |
2895 |
54 |
Cory |
Mathews |
2007-02-17 |
1601 |
54 |
Eric |
Mathews |
2005-08-22 |
2725 |
54 |
Shawn |
Hunter |
2008-05-31 |
2056 |
119 |
Taylor |
Kitsch |
2009-08-08 |
2168 |
119 |
Zach |
Gilford |
2005-08-02 |
1803 |
119 |
Tyra |
Collette |
2007-08-02 |
2213 |
119 |
Jason |
Street |
2006-01-17 |
2932 |
345 |
Abed |
Nadir |
2007-04-15 |
2492 |
345 |
Jeff |
Winger |
2008-08-10 |
1440 |
345 |
Britta |
Perry |
2006-05-21 |
2036 |
345 |
Annie |
Edison |
2006-05-25 |
2732 |
93 |
Zack |
Morris |
2008-02-18 |
1927 |
93 |
Kelly |
Kapowski |
2009-02-22 |
1448 |
93 |
Jessie |
Spano |
2007-02-15 |
1972 |
93 |
Samuel |
Powers |
2007-04-14 |
The SQL queries are given in the below step for Student Table
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images