Posts

Delete duplicate values in a column using MySQL

You could have faced a situation where you have huge number of records and have to remove the duplicate entries (like duplicate email id) from it, if you have worked with data import. Of course you could do it programmatically, but you could do it faster using the Database itself.

Rename Database in MySQL

MySQL had supported renaming Database in some earlier versions, but due to some security issues it was removed. So, if you create a Database, you do not have a command to directly rename it. There is a workaround though so that you need not create and populate all the tables to the new database.

Science at Mobile, Joint Initiative of IGNOU and Vigyan Prasar for Science Popularisation through Mobile

IGNOU and Vigyan Prasar have jointly started a new initiative to popularise science through SMS. The services provided by the science@mobile are free of cost to all the users. Interested people can subscribe free of cost mobile content on science and related areas including Science News, Important Days and Events, Science facts, Science Humor, Science Quotes, About Scientists, Health Tips, Green Tips. Register your mobile number in the site :  http://scienceatmobile.ignou.ac.in/Registration.aspx  for receiving SMS. There is an option to set SMS delivery on a daily/weekly basis for all sections.

Google changes Blogger address from .com to per country basis

Google changed the web address of Blogger to per country basis (prasanthkumars.blogspot.com is changed to http://prasanthkumars.blogspot.in). It is learned that this change is for blocking access in individual countries. More on BBC

BSNL - Adding/Changing friends and family numbers

For reference How to add/change friends and family numbers with BSNL (Kerala). *** UPDATE 2: BSNL have moved Kerala Circle users to new Intelligent Network. The new list of SMS and USSD codes are available here.  http://prasanthkumars.blogspot.in/2015/07/bsnl-recharge-friends-and-family-ussd.html  ****** *** UPDATE : FFM Oldnumber Newnumber to 53733 with charge of Rs.5/- to change a single number. Find your registered Friends and Family numbers - Dial *124#  ****** Adding You can have 5 numbers in the FF scheme of BSNL. For adding 5 numbers to FF, send an SMS to 53733 in the following format: FFE<space>Number 1<space>Number 2<space>Number 3<space>Number 4<space>Number 5 You need to enter 5 numbers in the SMS. If not the request will be rejected. You will get a confirmation message once the request is accepted. Please save this message as you will need it for reference when changing the numbers. Changing You can chang...

iPhone users join hands with hackers. What does this mean to us iPhone developers?

Recently it was in the news that ‘Chronic Dev hacker team’ created an app for intercepting error messages sent from iPhone and send it to their team so that they can dig into them to find some bug. This bug can be utilized to create an efficient Jail break for the iPhone. It is reported that the users response had been overwhelming that "In the first couple of days after CDevreporter   is released   they received about twelve million crash reports”. Does this mean a good number of iPhone users are willing to have a Jail break iPhone? Let us try to dig deeper into this.

CSV and SYLK file.

We used to export data in the form of .csv file that is one of the easiest formats available. A .csv file can be opened in even Notepad and if it is opened in Microsoft Excel, you can perform calculation with the numbers also. When you open a certain .csv file, Microsoft Excel may show an error that the file is a SYLK file and confirm to open it. Once you confirm it will show error that 'SYLK: File format is not valid'. If you try to open the same file in Notepad or Wordpad you will not see any issue with the data. The problem actually lies with Microsoft Excel. If the first two characters of the file are the uppercase letters "I" and "D", then MS Excel will consider the file as SYLK file and if you try to open it with MS Excel it will show error as the file is not actually an SYLK file. Solution: Open the file in notepad and change the first two characters of the file to lower case, if they are I and D. So, 'ID' will change to 'id'. ...