Question: ERROR 1064 (42000): You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL server version for theright syntax to use

ERROR 1064 (42000): You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL server version for theright syntax to use near 'FOREIGN KEY REFERENCES StuID(StuID) )' atline 5

CREATE TABLE Advisors ( AdvID int NOT NULL PRIMARY KEY, LastNamevarchar(255) NOT NULL, FirstName varchar(255) NOT NULL, StuID intFOREIGN KEY REFERENCES StuID(StuID) );

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 Programming Questions!

I'm trying to create a table in MariaDB which is a fork of mySQL. I'mg getting a syntax error. Does anyone know what I am inputting incorrectly? Thumbs up if you can find it. CentOSx64 [Runningl -...

Discuss the FIFO inventory cost method. Why would the FIFO inventory cost method be a good choice? Would the FIFO inventory method follow the actual flow of inventory?

I need help with this SQL statement I keep getting errors: Question: 3) Create a view vHW1_3_xxxx listing the number of staff and the average salary for whom are in Assistant position and work at...

I am having trouble understanding what is the error. Can someone please help me mysql> CREATE TABLE QOPRODUCT ( -> P_CODE Display all 779 possibilities? (y or n) -> P_CODE VARCHAR(10) PRIMARY KEY, ->...

Can someone help me with this? I keep getting an error and I'm typing it in just the way I'm told. I'm using MySQL 5.7 Command Line Client. Here is what I'm stuck on: Enter a LOAD DATA statement that...

The last picture is what I have typed in, and I do not know what I am doing wrong. Could you help me please? Thank you. Your supervisor wants to know the total sales (qty*unitprice) grouped by...

Efficiency is a key goal when completing any Excel worksheet. As the size and scope of the schedule grow, taking an efficient approach to populating it becomes increasingly vital. In the case of the...

How can i successfully import a csv file to a table in my sql. For example my csv file is FleetMainLtenanceRecords.csv my table is PartsMaintenance When putting this code in: LOAD DATA INFILE...

In the executive management model, what are the two possible types of committee a CISO should chair?

Why is this line wrong on mysql trying to creat table for my student database create table Student (ID number, Name VARCHAR(20), Age number, Section CHAR(5), City VARCHAR(20), Primary key(ID)); ERROR...

Refer to the Institute for the Study of Labor: Discussion Paper Series (March 2011) study of how workers respond to wage cuts, Exercise 9.22 (p. 508). Recall that teams of workers were divided into...

What are some products you think technology might be able to develop in the future that you would like? Explain. Do you think these products could add to a companys profits? Why?

dentify the disadvantages of a functional project organization. ( More than one answer may be correct. ) Multiple select question. No change in structure. Lack of ownership. Conflict between...

Use the following information to calculate the true reconciled cash balance: What is the companys true cash balance at April30? Bank statement shows interest earned for month Bank statement shows...

John Goodheart wishes to provide for six annual withdrawals of $3,000 each beginning January 1, 2017. He wishes to make 10 annual deposits beginning January 1, 2007, with the last deposit to be made...

Yaeger Company uses budgets in controlling costs. The company based the monthly budget amounts in the report on an expected production of 60,000 units per month or 720,000 units per year. The...

1. How much work is required for a mechanical hoist to lift a 9000-N automobile to a height of 1.80 m for repairs? 2. A hay wagon is used to move bales from the field to the barn. The tractor pulling...

Your client is facing a possible personal holding company tax or accumulated earnings tax in 2015. Advise the client as to the total tax due and what the effective tax rate will be for this...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

127. Identify four specialized financial analysis tools.

129. Explain the claim: While we theoretically use the effective interest rate to compute a bonds present value, in practice it is the other way around.

125. Identify and describe limitations of ratio analysis.