Question

Create a new MySQL database called "players". Create a user for your database named "Jane". Jane is a new employee who, in your challenge, will create a new table called "phillies". This table will hold 1 record only. This record is a description of Jane's favorite sports team, the Philadelphia Phillies. She needs to input the following data for her favorite player, Cole Hamels: Be sure to consider which data types you should use for each data point that needs to be saved into the new database table.

• Player's name
• Player's number (#35)
• Player's position (starting left-handed pitcher)
• Player's ERA (3.6)

Answer 1

Here is how I have done this.

1.Using the phpmyadmin interface of the xampp tool , I have created a new MySQL database and named "players".

2. To add a new user, go to the database-> Privileges->new->Add user and then add user by providing the name , password and specifying his privileges. In this case, the username is Jane and the password can be anything of your choices. Check the boxes you wish to grant the permissions for.

3. Next, we go to the newly created database and add a table named "phillies" with number of columns as 4.

I have chosen the data types as shown in the figure. Note that the player number is the primary key over here

Table name: phillies Add 1 Name Type Length/Values VARCHAR 30 name INT number VARCHAR position 50 DOUBLE ERA

After creating the table, you can now insert the values into the table either by using the GUI or the SQL code.The code for the create table and insert statement has been provided below:

CREATE TABLE IF NOT EXISTS `phillies` (
`name` varchar(30) NOT NULL,
`number` int(11) NOT NULL,
`position` varchar(50) NOT NULL,
`ERA` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phillies`
--

INSERT INTO `phillies` (`name`, `number`, `position`, `ERA`) VALUES
('Cole Hamels', 35, 'starting left-handed pitcher', 3.6);