Creating Tables in MySQL

-

 Creating Tables in MySQL

          Creating tables in MySQL is important so that a user can add information, delete information, and update an entry using SQL statements. Also, a final statement was created to join all three tables demonstrating the relationships between the three tables. The INSERT function was used to add rows to the first table named tbldvdtitles. The information was inserted and the code and the results are pictured below:



MySQL instructions were used by Oracle to guide the use of MySQL. The next table was a table called tbldvdActors with the information inserted and results below:


Updating and deleting rows were part of the requirements for the interactive assignment and the following code was used:


A third table was created to describe the relationships between actor ID and the ASIN number for each movie and the results were as follows:

Joining all three tables was the last step and the results were as follows:

Information was successfully joined from all three tables. During this interactive assignment, information was inserted one row at a time to ensure accuracy. Multiple rows can be added to one line of code with the following SQL statements:

INSERT INTO table_name (column_list)

VALUES

            (value_list_1),

            (value_list_2),

            ...

            (value_list_n);

            Various ways could have been used to join the three tables, depending on the specifics of the requirements from a project or business. Playing around with MySQL was the easiest way to navigate the new tool being learned for this project and SQL in general is very straightforward in accomplishing an end goal. SQL has under 100 statements that can be used, making the language fairly simple to learn and use, even as a new user. 












Comments

Post a Comment

Popular posts from this blog

Employee Management System - Simple Project

-
Image
  The employee management system project is designed to take user input and store the information as variables for later use. As Miller, Vahid, and Lysecky point out, a variable “is used to remember a value for later use" (2015). Creating the variables of employeeName, employeeSSN, employeePhone, employeeEmail, and employeeSalary were to hold the information to display later in the program. Variable types were string with the exception of the salary input that was set as an integer.             Repetition was very useful in writing this code. Each line was the same just changing the variable name and type in the string. Employee salary was the only line that had an addition with the sep= function to remove the space after the $ sign in the code. This was used for appearance purposes. Setting the variables to strings allowed the user to enter dashes if needed and parenthesis if desired for the phone number. Setting the variabl...
Read more

Explicit and Implicit Variables

-
  What is a Variable? Using implicit or explicit variables is an important decision when choosing what language to use when writing a program or starting to code. In simplest terms, a variable is used to remember a value for later use. The way different programming languages use variables is important for programmers to keep in mind when choosing how to code variables. Implicit variables are when the compiler chooses the type of output and explicit variables are when the programmer pre-assigns variables to have a specific output. Examples of Variables Each can be useful depending on the program that is being written. Boudreau points out that implicit variables can often be easier to use in programming and that sometimes the results can be just fine. However, leaving the compiler making that decision making on an assumption can often lead to problems. Explicit assigning of variables gives a more specific output and result and can be much more reliable. Depending on the lan...
Read more