mysql - How copy data from one table into another? PHP -

following problem there 2 tables, "daten" , "server" in mysql db called "csv" both got "serverid" inside them column. how can copy data in column "serverid" table "server" "daten".

i have numbers in "server" "serverid" auto-increment.

the result want is: in serverid number , want number in other table too.

i tried giving me: "111111111111111111111111111111111111"

$con=mysqli_connect("localhost","thuni","root","csv"); // check connection if (mysqli_connect_errno())   {   echo "failed connect mysql: " . mysqli_connect_error();   }  $sql="select serverid server"; $result=mysqli_query($con,$sql);    //associative array $row=mysqli_fetch_array($result, mysqli_assoc); printf ($row["serverid"]);  // free result set mysqli_free_result($result); 

can me?

insert server (serverid) select serverid daten; 

that insert server serverid daten

the correct way copy datas table :

insert table2 select * table1; 

or

insert table2 (column_name(s)) select column_name(s) table1; 

in script, should that

$con=mysqli_connect("localhost","thuni","root","csv"); // check connection if (mysqli_connect_errno())   {   echo "failed connect mysql: " . mysqli_connect_error();   }  $sql="insert server          select * daten"; mysqli_query($con,$sql); // inserts data daten server  $query = "select serverid server"; $result = mysqli_query($con,$query); // you're selecting serverid in server  echo "the result ". mysqli_fetch_array($result)['serverid']; // gives serverid server