The Biggest MySQL mistake I made

Welcome file

The Biggest MySQL mistake I made

Ok, as usual I have broken my promise to keep writing post. Anyways, there is a good news too. I have been studying Golang for months now and developing some my own projects.
But today I am going to share completly different thing I met recently.
I was working with a MySQL table and wanted to delete a record from it. So I wrote delete from my_table.. before I put where clause accidentally I hit enter.
So my terminal was like
mysql> delete from my_table
    ->
what I did was, just put ; and press enter.
mysql> delete from my_table
    -> ;
Query OK, 56 rows affected (0.09 sec)
Boom, I have deleted all the records from my table. I had spent another hour plus to manually insert all the records back to table. Luckily I have printed all the records in that table.
SO the lession I learn that day was, never use ; in unknown MySQL queries. If you make a mistake and came -> line, just hit CTRL+c, it will terminate the current query and bring a new line.
I hope you wont make the mistake I made.
Happy Coding!

Comments

Post a Comment

Popular posts from this blog

Youtube-dl cheatsheet

Youtube-dl cheatsheet Hello fellow coders… Today I am going to post something different. Its about a command-line based youtube downloader called youtube-dl . If you dont know about it, please go and check their homepage . This gives you instructions to install it correctly. So today I am going to post some cheats you will need to download best youtube videos quickly. One more important thing, there are no configuration settings to be done before or after installing youtube-dl . Downloading a single video When you need to download a single youtube video, you just type : youtube-dl youtube-video-url This will download the best quality video available. But if you can select specific video quality. I will describe it later. Downloading a playlist When you are interested about a certain youtube play list and want to download, youtube-dl gives an easy way to do it. You just have to use : youtube-dl -cit youtube-playlist-url Download specific videos from a ...
Read more

How to ask a question on StackOverflow

When we do coding we often face many problem. Theoretically ok code may not run in practical environment. So what we should do. First we can ask from our fellow coders near you. If they cant help you, what do you do? You must have checked StackOverflow. Most of the time, we go there just as a reader and read threads about similar problems. But what would happen if non of them help you. You have to ask a question. Here are some tips for asking a good question on StackOverflow. Its not for helping you to complete your homeworks. So never ask, I have to do this, how I can do it. First try something by yourself, even its a simple hello world program. Then ask your question with you used code, expected result and the actual result you got. When you ask a question, be simple and short, include only the necessary details to your question. Always give some details about your environment, such as your OS, software version. Be polite with the fellow coders who tries to help you there....
Read more

Advance usage of Sublime Text-3

          I am posting this for coding your life easily using Sublime Text -3. These are a few but helpful shortcuts every sublime user should know. I hope these will make your coding life very easy and comfortable. Note : => is not a key word, I just use it to show you what is the next step. 1) To find a file :          Keys            : ctrl+p  => File name.          Description : When you need to find a file inside your working directory and you know the                                   name of that file (at least a fraction of it). Else you have to use sidebar. 2) To get a method in a file :          Keys            : ctrl+p  => @ method         Description : When you need to find a method in...
Read more