RSS

Monthly Archives: October 2011

Create exact copy of table


Create the existing table’s copy we normally use

Create table <new table> select * from  <existing table>

it works. but it couldn’t create primary key defined in existing table.

To solve this problem use this following query:

Create table <new table>  like <existing table>;

Advertisements
 
Leave a comment

Posted by on October 15, 2011 in Uncategorized

 

Tags: , ,

install Xampp in ubuntu


download the xampp for linux from corresp. site

then open the terminal and follow the instructions below:

  1. cd Desktop
  2. sudo -s
  3. tar xvzf xampp-linux-1.7.4.tar.gz -C /opt
  4. sudo chmod 777 -R /opt/lampp/htdocs
  5. /opt/lampp/lampp

To start xampp type this cmd in terminal:

/opt/lampp/lampp start

To stop xampp type this cmd:

/opt/lampp/lampp stop

 
Leave a comment

Posted by on October 6, 2011 in Dexter, Uncategorized

 

Tags: , , ,

 
%d bloggers like this: