HELP PLEASE!
Can someone help me understand what the error message is please
SQL query:
INSERT INTO STUDENT
VALUES (
'J0100', 'JONES', 'TAMMY', 'R', '1817 EAGLERIDGE CIRCLE', 'TALLAHASSE', 'FL', '32811', '7155559876', 'SR', TO_DATE(
'02-MAY-97'
), '8891', 1, 3
);
MySQL said: Documentation
#1547 - Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted
Student Table:
DROP TABLE IF EXISTS STUDENT;
CREATE TABLE STUDENT
(
S_ID VARCHAR(6),
S_LAST VARCHAR(30),
S_FIRST VARCHAR(30),
S_MI VARCHAR(1),
S_ADDRESS VARCHAR(25),
S_CITY VARCHAR(10),
S_STATE CHAR(4),
S_ZIP VARCHAR(8),
S_PHONE VARCHAR(15),
S_CLASS CHAR(15),
S_DOB DATE,
S_PIN VARCHAR(5),
F_ID INTEGER(3),
TIME_ENROLLED INTEGER(255),
PRIMARY KEY (S_ID),
FOREIGN KEY (F_ID) REFERENCES FACULTY (F_ID)
);
Subject
Written By
Posted
HELP PLEASE!
October 31, 2014 12:54PM
November 01, 2014 05:32AM
November 02, 2014 04:08PM
November 02, 2014 04:32PM
November 02, 2014 06:00PM
November 03, 2014 05:17AM
November 03, 2014 09:58AM
November 03, 2014 11:54AM
November 03, 2014 12:15PM
November 03, 2014 12:49PM
November 03, 2014 02:09PM