Few Question in Mysql. If any one know means tell me?

Am working in live server database without taking backup.
Unfortunately I truncate the table means is there any way to retrieve the truncate table in mysql?

Answer Please...



Like wise same i working in live server database without taking backup.
IF i delete the row in a table. Is there any other way to retrieve the row?



Answer Please.... 



Likewise same while working in MySqlYog
if we have duplicate values in a table. We selecting the row with where condition.
Then it will display the values

Table name: orderdetails
Orderid  Ordernumber  Employeeid
1                  1201          231
2                  1201          231

We select the any one values and click the delete button. Then it will show an alert box of 

Turn off the Tools-->Preferrences -->Prompt if multiple rows are getting updated.

 As per the alert if we turn off that and delete the duplicate values alone. then the original values also deleted from database...


I dont know how to rectify? If any one know this answer inform me

Thanks for your answers in advance.....

Comments

  1. Manki17 July 2015 at 12:07

    #1. No
    #2. No
    #3. Use the following SQL command. DELETE FROM orderdetails WHERE Orderid = 1 AND Ordernumber = 1201 AND Employeeid = 231 LIMIT 1;

    ReplyDelete

Post a Comment

Popular posts from this blog

How do i Increase the capacity of the Eclipse Output console?

Image
Under Window > Preferences , go to the Run/Debug > Console section, then you should see an option "Limit console output." You can uncheck this or change the number in the "Console buffer size (characters)" text box below . ( This is in Galileo, Kepler, Juno, Luna, Mars and Helios CDT ). Here I shared some screen shot of the above                                               Window -->Preferences     Run/Debug --> Console   Uncheck the Limit Console Output. Then click the Apply button for the changes. Then click ok. Now your output console capacity is big to view your complete output.
Read more

An internal error occurred during: "Building workspace". Java heap space

Image
An internal error occurred during: "Building workspace". Java heap space  If you are facing this error while building workspace. The Eclipse told you to close the eclipse.     For that you want to change the Eclipse.ini file. Increase the value of Xmx and Xms value. Open the Eclipse Home directory and search for eclipse.ini file.  Right click that file and give edit    Edit the file and Save the file. Then open the Eclipse and start work on it. Here  i coded the Xms and Xmx value is for my system. Based upon your system RAM. you want to give the values  
Read more

How to convert the Math Number to Words in Java?

How to convert the Math Number to Words in Java import java.util.*; public class NumToWords {     String string;     String st1[] = { "", "one", "two", "three", "four", "five", "six", "seven",             "eight", "nine", };     String st2[] = { "hundred", "thousand", "lakh", "crore" };     String st3[] = { "ten", "eleven", "twelve", "thirteen", "fourteen",             "fifteen", "sixteen", "seventeen", "eighteen", "ninteen", };     String st4[] = { "twenty", "thirty", "fourty", "fifty", "sixty", "seventy",             "eighty", "ninty" };     public String convert(int number) {         int n = 1;         int word;         string = "";     ...
Read more