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

How to fix "username is not in the sudoers file" in debian

Hello fellow coders Recently I installed Debian-9 in my old laptop and tried to execute sudo command and I got above error saying that action will be reported. So today in this short post, I am going to tell you how to fix this problem. First, open your terminal and put su - Enter your password and then just type visudo This will openup a file with nano editor and it has few values, do not change any of them, just go to the line root ALL=(ALL:ALL) ALL and below it add a new line myuser ALL=(ALL) ALL save the file and then try to execute commands with sudo.. I hope this short post will save you a lots of times, in next blog I will bring you what are the meanings of these lines. Also a good Golang tutorial comming soon. Good Luck
Read more

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

A Go Journey - Part 1

Hello fellow coders, Merry Christmas and a Happy New Year!! I am about to start a fresh project with Golang. I will update the blog through out the project. Here I am going to create a simple blogging platform using Golang's micro-architecture just like I created using Laravel and Django . I just started Golang.  As I understood it sofar, we can call it as a combination of C and Python programming languages. It has the power of C with easy coding style like Python. For me, the most weirdest thing is variable/function declaration in Go. as an example, to define a string variable var myname string = "sachith" // function syntax func myfunction() string { return "Hello World" } a bit strange, isnt it? for variable definitions, there is a short method. myname := "sachith" Golang's capabilities and performances are the main attraction fo r this relatively new language. Golang is not considered as an O...
Read more