how to copy data from one table to another table in mysql 


INSERT  INTO  TABLE2  SELECT  *  FROM  TABLE1


INSERT INTO TABLE2 (COL1, COL2, COL3) SELECT COL1, COL4, COL7 FROM TABLE1


copy table one database to another database 






CREATE TABLE database2.`tablename2` SELECT * FROM database1.`tablename1`

NOTE:
 it must you have database1 , database2 and tablename1
 


Create similar table in mysql 


CREATE TABLE new_table_name LIKE tablename2;




rename table in mysql 


RENAME TABLE   table1 TO  table2  ;

























































Comments









  1. AnonymousNovember 21, 2018 at 6:56 PM
    It's awesome in support of me to have a site, which is helpful in favor 
    of my experience. thanks admin
    ReplyDelete











Post a Comment


If you Satisfied , Please Leave a comment




















Popular posts from this blog









Call PHP Function In JavaScript Using Ajax





















  how to call php function from javascript function   1. create Folder on WWW Or htdocs (on your computer)     2. create index.php page on your folder and paste this code   index.php   <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>    <script> function addsearchproduct(x){   // this is JavaScript  function      $.ajax({   type: 'POST',   url: "function.php?f=phpFunction&p="+x,           // call php function , phpFunction=function Name , x= parameter     data: {},   success: function(data1){         alert(data1);   } });              } </script>  <input type="button" value="call Php Function" onclick="...








Read more










List of Post Category Wise in wordpress





















 for example show this type  Category 1   post1    post 2    post3 category 2    post 1    post 2 Category 3   post1    post 2    post3    code :  <?php // get all the categories from the database     $cats  =  get_categories ();  // loop through the categries    foreach ( $cats  as  $cat ) {    // setup the cateogory ID     $cat_id =  $cat -> term_id ;    // Make a header for the cateogry     echo  "<h2>" . $cat -> name . "</h2>" ;    // create a custom wordpress query    query_posts ( "cat=$cat_id&post_per_page=100" );     // start the wordpre...








Read more










PHP Script for sending mail with  attachment file





















  send email with attachment in php    code to send email with attachment in php    form.html    <form action="sendmail.php" >  <label> Name:</label>  <input type="text" name="name" id="name" />  <label> email:</label>  <input type="text" name="email" id="email" />  <label> Phone No:</label>  <input type="text" name="ph" id="ph" />  <label> Message:</label>  <input type="text" name="msg" id="msg" />  <label> Resume :</label>  <input type="file" name="txtresume" id="txtresume" />  <input type="submit" name="send mail" value="send mail"  />  </form>    sendmail.php   <?php error_reporting ( 0 );  //ini_set('display_errors','off'); //ini_set('memory_limit', '-1'...








Read more