#1
  1. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Location
    Hong Kong
    Posts
    71
    Rep Power
    15
    The MySQL has many errors occur.
    "Didn't find any fields in table 'table_name'".

    How can I solve it?
    Have any command or program to re-index the MySQL?
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Location
    Seoul, Corea
    Posts
    10
    Rep Power
    0
    Yon can use SQL command 'alter table' in mysql.
    Execute mysql and do this.

    alter table your_table_name drop primary key;

    and now

    alter table your_table_name add primary key (primary_key_field_name);

    -- Monpetit

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 06:02 PM
  2. Mind Boggling Serialization Error
    By bergy in forum Visual Basic Programming
    Replies: 3
    Last Post: January 6th, 2004, 02:13 PM
  3. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 12:35 PM
  4. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 12:27 AM

IMN logo majestic logo threadwatch logo seochat tools logo