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/
Go to Top of Page
   

- Advertisement -