MySQL Forums
Forum List  »  Newbie

HELP PLEASE!
Posted by: Stalin Lema
Date: October 31, 2014 12:54PM

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)
);

Options: ReplyQuote


Subject
Written By
Posted
HELP PLEASE!
October 31, 2014 12:54PM
October 31, 2014 01:10PM
October 31, 2014 03:41PM
October 31, 2014 04:30PM
October 31, 2014 09:43PM
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


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.