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 can we optimize stored procedure?
Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.
What is difference between microsoft sql and mysql?
State the differences between mongodb and mysql.
Explain the difference between MyISAM Static and MyISAM Dynamic?
What is the difference Delete and Drop ?
How to install mysql?
Is mysql still popular?
I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks
How to calculate the difference between two dates?
What is a string in mysql?
How do I completely remove mysql from windows?