Sometimes I had a problem in repopulating ‘fresh’ tables in MySQL, how to duplicate the table and start it from id 1? Here is ‘serial’ command line to copy tables with an empty data in it, and start the counting from 1 again.

Execute this SQL queries (via PhpMyAdmin or MySQL command line interface):

create table groups2 like groups; drop table groups; create table groups like groups2; drop table groups2;

Done, and you’l get a fresh table with the same field as the source.

If you like me, who doesn’t like to remember any gibberish command line code, you can install PHPMyAdmin and do the task from there. Here are the steps:

1. After you logged on, choose the database and the table you want to rename
2. Find “Operations” and click
3. Find table options and rename from there.

Pretty easy, isn’t it?

» Continue reading “How to Rename MySQL Table in PHPMyAdmin”

Here is my latest web project, How To Invest, mostly talks about investment analysis and management, which I studied in my undergraduate school.

Just bought templates at Templatic.com and surprisingly they give me three more premium templates for free!

After almost 4 years in this business, I decide to expand my website portfolio into much much larger and wider topics. Although still in the same games, but I thought it still better than relying only on 1 or 2 website only. The latest project already created are forex-related websites which is Real Time Forex Quotes, FX Platforms, Free Forex Demo Account and Forex Trading Secret. All of them built using wordpress CMS. The next step is building a useful content for the readers for each sites, and start building high quality links to them. I hope in the end of this month I can finished 6 more forex related sites.