Question: Create an database. 2. Create an table in that database. The table will have five columns: 2a. Two columns will have two different numeric datatypes.
Create an database.
2. Create an table in that database. The table will have five columns:
2a. Two columns will have two different numeric datatypes.
2b. Two columns will have two different character datatypes
2c. One column will contain date or time data.
3. Populate that table with six rows of data.
Show the following:
1. The command you used to create the database.
2. The command you used to create the table.
3. The command you used to populate the table.
4. A screen clip of running "SELECT * FROM ;"
I want to see all six rows of data in your table.
You may name the table and columns anything you wish.
You may make the columns any datatype you wish as long as
two are numeric, two are string, and one is date/time.
When populating the table, please do not enter personal information
about you or anyone else.
Using Postgres
Step by Step Solution
3.34 Rating (148 Votes )
There are 3 Steps involved in it
Certainly here are the steps to create a database create a table populate it with data and perform a ... View full answer
Get step-by-step solutions from verified subject matter experts
