How can we repair a MySQL table?
Answers were Sorted based on User's Feedback
Answer / malkiet
using myisamchk at prompt
or "repair table TBLNAME" command at mysql prompt.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / opensky
using myisamchk at prompt
or "repair table TBLNAME" command at mysql prompt.
| Is This Answer Correct ? | 2 Yes | 3 No |
How do I download a mysql community server?
What is the difference between truncate and delete?
I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?
How to use count function in mysql?
What is database in php mysql?
What is the difference between the LIKE and REGEXP operators?
How can you plan the logshipping before processing?
What is clob datatype?
How many rows can be inserted in mysql at a time?
What is a mysql view?
How can you make a database as your current database?
What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)