Question: Part-1 Create new database, table and populate table from CSV file. For this lab you will work from the MySQL command line to create and

Part-1 Create new database, table and populate table from CSV file. For this lab you will work from the MySQL command line to create and new database, add a table with fields, populate the table and then perform queries on the table. Click Windows start button and locate XAMPP Control Center and double-click In the XAMPP control center, click the start button next to MySQL Open a terminal window by clicking Windows start button, type cmd and press enter Type: PATH-%PATH%;c:\xampp\mysql\bin; Press Enter Type: mysql-h localhost-u root-p Press enter When prompted for password, press Enter At the MariaDB [(none)sor MySQL> prompt type the following commands TEE myoutput.txt; Replace (name) with your first name: CREATE DATABASE (name) CHARACTER SET latinl' COLLATE latinl_swedish ci'i USE (name) The prompt should change to MariaDB Ifname)]> CREATE TABLE student tbl ( StudID INTEGER (11) NOT NULL AUTO INCREMENT UNIQUE LastName VARCHAR (20) DEPAULT NULL FirstName VARCHAR (20) DEFAULT NULL Address VARCHAR (30) DEFAULT NULL, city VARCHAR (20) DEFAULT NULL State VARCHAR (2) DEPAULT NULL zipcode VARCHAR (10) DEFAULT NLL PRIMARY KEY (StudID)) Press Enter. Part-1 Create new database, table and populate table from CSV file. For this lab you will work from the MySQL command line to create and new database, add a table with fields, populate the table and then perform queries on the table. Click Windows start button and locate XAMPP Control Center and double-click In the XAMPP control center, click the start button next to MySQL Open a terminal window by clicking Windows start button, type cmd and press enter Type: PATH-%PATH%;c:\xampp\mysql\bin; Press Enter Type: mysql-h localhost-u root-p Press enter When prompted for password, press Enter At the MariaDB [(none)sor MySQL> prompt type the following commands TEE myoutput.txt; Replace (name) with your first name: CREATE DATABASE (name) CHARACTER SET latinl' COLLATE latinl_swedish ci'i USE (name) The prompt should change to MariaDB Ifname)]> CREATE TABLE student tbl ( StudID INTEGER (11) NOT NULL AUTO INCREMENT UNIQUE LastName VARCHAR (20) DEPAULT NULL FirstName VARCHAR (20) DEFAULT NULL Address VARCHAR (30) DEFAULT NULL, city VARCHAR (20) DEFAULT NULL State VARCHAR (2) DEPAULT NULL zipcode VARCHAR (10) DEFAULT NLL PRIMARY KEY (StudID)) Press Enter

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q1, Create a database table Modify table-manager.php Hint : Examine the file table-manager.php Notice the variable $database_table which must be set to the name of your new table required. You will...

Please help to modify the whole Lab 03 code follow the Introduction, thank you so much! Lab 3 code: bank-Detail.csv ID12101,48,FEMALE,INNER_CITY,22467,YES,0,YES,YES,NO,YES,YES...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

DATABASE CAN BE ACCESSED BY THIS: www.papademas.net/phpmyadmin username = "db411"; password = "411"; Objective To write a program that creates a Loan analysis report from class objects created in lab...

Instructions Eat-Da-Burger! is a restaurant app that lets users input the names of burgers they'd like to eat. Whenever a user submits a burger's name, your app will display the burger on the left...

SEED Labs - SQL Injection Attack Lab 3.1 Task 1: Get Familiar with SQL Statements The objective of this task is to get familiar with SQL commands by playing with the provided database. We have...

The bank now needs your help in deciphering whom from its records should be exlusive to premium loans versus those offered micro or less premium loans. Use a database to store then present Loan...

- INSERT DATA INTO TABLE - DELETE Tasks/Assignments(s) Creating Database objects by using Data Definition Language (DDL) : 1. Using the Data Definition Language statement, create new database named...

What is the profitability index for the following set cash flows if the relevant discount rate is 10 percent? What if the discount rate is 15 percent? If it is 22 percent? Year Cash flow 0...

A&B (two individuals) wants to organize an entity to combine their two businesses. Assume the business will average $1 million of taxable income from the combined businesses. What entity would...

In class notes we argued that the cash flows of a corporate bond can be replicated by a long position in a risk - free bond and a short position in a put option. Similarly, we argued that the cash...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. Why is private property, and the protection of property rights, so critical to the success of the market system? LO2

2 The main characteristics of the market system.

10. Below is a production possibilities table for consumer goods (automobiles) and capital goods (forklifts): LO5 a. Show these data graphically. Upon what specific assumptions is this production...