Trying to Write an SQL Table for Class and Keep Running into "ERROR $1064(42000)$: You have an error in your SQL syntax" Here are the Details of my Table:

mysql$>$ CREATE TABLE Customers$($

$->$ Customer$\_$ID INT,

$->$ First$\_$Name VARCHAR$(25),$

$->$ Last$\_$Name VARCHAR$(25),$

$->$ Street VARCHAR$(50),$

$->$ City VARCHAR$(50),$

$->$ State VARCHAR$(25),$

$->$ Zip$\_$Code VARCHAR$(10),$

$->$ Telephone VARCHAR$(15),$

$->$ PRIMARY KEY $($Customer$\_$ID$)$

$->)$;

Query OK$,0$ rows affected $(0\mathrm{.}47$ sec$)$

mysql$>$ DESCRIBE Customers;

$+-------------+-------------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+-------------+-------------+------+-----+---------+-------+$

$|$ Customer$\_$ID $|$ int $|$ NO $|$ PRI $|$ NULL $||$

$|$ First$\_$Name $|$ varchar$(25)|$ YES $||$ NULL $||$

$|$ Last$\_$Name $|$ varchar$(25)|$ YES $||$ NULL $||$

$|$ Street $|$ varchar$(50)|$ YES $||$ NULL $||$

$|$ City $|$ varchar$(50)|$ YES $||$ NULL $||$

$|$ State $|$ varchar$(25)|$ YES $||$ NULL $||$

$|$ Zip$\_$Code $|$ varchar$(10)|$ YES $||$ NULL $||$

$|$ Telephone $|$ varchar$(15)|$ YES $||$ NULL $||$

$+-------------+-------------+------+-----+---------+-------+$

$8$ rows in set $(0\mathrm{.}01$ sec$)$

mysql$>$ CREATE TABLE Orders$($

$->$ Order$\_$ID INT,

$->$ Customer$\_$ID INT,

$->$ SKU VARCHAR$(20),$

$->$ Description VARCHAR$(50),$

$->$ PRIMARY KEY $($Order$\_$ID$),$

$->$ FOREIGN KEY $($Customer$\_$ID$)$ REFERENCES Customers $($Customer$\_$ID$)$

$->)$;

Query OK$,0$ rows affected $(0\mathrm{.}45$ sec$)$

mysql$>$ DESCRIBE Orders;

$+-------------+-------------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+-------------+-------------+------+-----+---------+-------+$

$|$ Order$\_$ID $|$ int $|$ NO $|$ PRI $|$ NULL $||$

$|$ Customer$\_$ID $|$ int $|$ YES $|$ MUL $|$ NULL $||$

$|$ SKU $|$ varchar$(20)|$ YES $||$ NULL $||$

$|$ Description $|$ varchar$(50)|$ YES $||$ NULL $||$

$+-------------+-------------+------+-----+---------+-------+$

$4$ rows in set $(0\mathrm{.}01$ sec$)$

mysql$>$ CREATE TABLE RMA$($

$->$ RMA$\_$ID INT,

$->$ Order$\_$ID INT,

$->$ Step VARCHAR$(50),$

$->$ Status VARCHAR$(15),$

$->$ Reason VARCHAR$(15),$

$->$ PRIMARY KEY $($RMA$\_$ID$),$

$->$ FOREIGN KEY $($Order$\_$ID$)$ REFERENCES Orders $($Order$\_$ID$)$

$->)$;

Query OK$,0$ rows affected $(0\mathrm{.}74$ sec$)$

mysql$>$ DESCRIBE RMA;

$+----------+-------------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+----------+-------------+------+-----+---------+-------+$

$|$ RMA$\_$ID $|$ int $|$ NO $|$ PRI $|$ NULL $||$

$|$ Order$\_$ID $|$ int $|$ YES $|$ MUL $|$ NULL $||$

$|$ Step $|$ varchar$(50)|$ YES $||$ NULL $||$

$|$ Status $|$ varchar$(15)|$ YES $||$ NULL $||$

$|$ Reason $|$ varchar$(15)|$ YES $||$ NULL $||$

$+----------+-------------+------+-----+---------+-------+$

$5$ rows in set $(0\mathrm{.}00$ sec$)$

mysql$>$ INSERT INTO Customers VALUES

$->(10001,$Thomas$,$Bonner$,$My Street$,$Tampa$,$FL$,33611,555-555-5555),$

$->(10002,$Marla$,$Singer$,$Fight Club$,$Los Angles$,$CA$,101599,555-555-1999),$

$->(10003,$Robert$,$Bonner$,$Bro Circle$,$Tampa$,$FL$,33616,555-555-1975),$

$->(10004,$Sheldon<

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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!

Q:

Hello, in this problem I only need numbers 16 and 17 finished, and if you see anything else wrong feel free to change. (only change under "// Type your code here") In PHP 3 --> 3. Problem Description...

Q:

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

Please help with this lab assignment - Java Chapter 16 Lab - Databases Lab Objectives Be able to write SQL statements. Be able to retrieve information from a database. Be able to add information to a...

Q:

Please help me with code not how to use NetBEAN. Can help make the code work and help me to compile and to RUN Is note how to use NetBean I need help with CODE PLEASE Thank I can Run if the Code work...

Q:

Chapter 17 Lab Databases Lab Objectives Be able to write SQL statements. Be able to retrieve information from a database. Be able to add information to a database. Be able to change information in...

Q:

I need help making the SQL statements in visual studio 2017 Please read homework carefully svxGS0201 9 1 0/Project%20Task%2075628 1 %29.pdf MGMT 329: Database Management Project Task 7: Requi The...

Q:

In SQL, Using MAMP It says it thoughout each part. It is SQL. 3. Write one statement to alter the table Booking to add a column, property No, which: a is an integer representing the property No for...

Q:

Advanced Linear Algebra / Advanced Math / Matlab question need help! Some of the needed codes are attached. In the question, it talks about the HW 6.1 but it can be neglected because every thing...

Q:

Advanced Linear Algebra / Advanced Math / Matlab question need help! Some of the needed codes are attached. In the question, it talks about the HW 6.1 but it can be neglected because every thing...

Q:

A certain 3 x 3 matrix A has (1,1) entry a11 tinct eigenvalues. One eigenvalue is unknown, eigenvalue is X eigenvector for the unknown eigenvalue X span{(1, 1, 0), (1, 1, 1)T}. = Use this information...

Q:

Will upvote. (10%) Problem 10: Consider a 120 V AC microwave oven that draws 9.5 A. Randomized Variables I= 9.5 A What is the maximum instantaneous power consumption, in kilowatts, of the microwave?...

Q:

I have been trying to get the rright anwsersswers 3 . 4 7 and 1 . 7 3 years. However the calculations show differntlyently as iI keep getting 3 . 6 7 and 1 . 8 3 yearsa. Macauleyay Durations 2 . A...

Q:

Company A is a small business and Company B is a large business. Company A is more likely than Company B to exhibit the following characteristics, EXCEPT: no clear policies and procedures. general...

Q:

If I gave you this job, what would you accomplish in the first three months?

Q:

Describe your strongest attribute with an example of how it paid off.

Q:

Describe a time when you worked through a difficult coworker situation.

Previous Question Next Question