How to Copy Table in MySQL CLI

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.

Leave a Comment

How to Rename MySQL Table in PHPMyAdmin

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”

Leave a Comment

Adding another website

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

Leave a Comment

WordPress templates from Templatic

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

Leave a Comment

Another Websites Launched

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.

Leave a Comment