You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'foregin key(auth_email) references tb_student_info(student_email) )' at line 6
时间: 2023-07-17 16:12:27 浏览: 79
The error you encountered suggests that there is a syntax error in your SQL statement near the line that contains "foregin key(auth_email) references tb_student_info(student_email)".
The correct keyword for defining a foreign key in MySQL is "foreign key" (not "foregin key"). Additionally, you may need to ensure that the referenced table and column names are correct. Here's an example of how the corrected SQL statement could look:
```
CREATE TABLE tb_auth_info (
auth_id INT PRIMARY KEY,
auth_email VARCHAR(255),
FOREIGN KEY (auth_email) REFERENCES tb_student_info(student_email)
);
```
Please note that this example assumes you have already created the `tb_student_info` table with a column named `student_email` that matches the data type of `auth_email` in the `tb_auth_info` table.