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). School School Number Name Address PhoneNumber built size 54 John Adams High School 8226 Selby Lane 5056444088 2012-12-13 118500 45 Hogwarts School of Witchcraft and Wizardry 738 North Williams Ave. 5056448362 2001-11-14 414000 119 Dillon High School 475 South University Ave. 5058672818 2006-10-03 102598 345 Green Dale High 772 Grand St. 5056624410 2009-09-17 250345 93 Bayside High 7914 Aspen Drive 5057756575 2000-08-20 175645
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).
School
|
School Number |
Name |
Address |
PhoneNumber |
built |
size |
|
54 |
John Adams High School |
8226 Selby Lane |
5056444088 |
2012-12-13 |
118500 |
|
45 |
Hogwarts School of Witchcraft and Wizardry |
738 North Williams Ave. |
5056448362 |
2001-11-14 |
414000 |
|
119 |
Dillon High School |
475 South University Ave. |
5058672818 |
2006-10-03 |
102598 |
|
345 |
Green Dale High |
772 Grand St. |
5056624410 |
2009-09-17 |
250345 |
|
93 |
Bayside High |
7914 Aspen Drive |
5057756575 |
2000-08-20 |
175645 |
In this question we have to write a SQL query to insert this data given into the table and using select command have to view it.
Let's write this query and hope this helps, if you find any query on the solution, utilize threaded question feature.
Step by step
Solved in 3 steps with 4 images
mysql> CREATE TABLE School (
-> SchoolNumber INT PRIMARY KEY,
-> Name VARCHAR(50),
-> Address VARCHAR(100),
-> PhoneNumber BIGINT,
-> Built DATE,
-> Size INT
-> );
ERROR 1046 (3D000): No
mysql> SELECT * FROM School;
ERROR 1046 (3D000): No database selected
by Bartleby Expert
