Help please! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Help please!

Author

Topic

Miguel_92
Starting Member

1 Post

Posted - 2014-10-31 : 14:15:09

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

Stalin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-31 : 14:27:04

Stalin, your question is in regards to MySql. SQLTeam.com is for Microsoft SQL Server. You'll want to post your issue on a MySql forum. Try mysql.com.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources