The Syntax for repairing a MySql table is REPAIR TABLENAME,[TABLENAME,] , [Quick],[Extended] This command will repair the table specified if the quick is given. Otherwise MySql will do a repair of only the index tree if extended is given.
How can I insert data into one table from two other tables where i have three tables namely users, role and userrole. Now I want to insert the data into userrole table from users table and role table with a single statement.