how can i conect 2 tables in mysql?

[alin19]

i'm using phpmyadmin

 

would this work?

 

table 1:

CREATE TABLE `ion` (`id` INT( 2 ) NOT NULL ,`test` VARCHAR( 2 ) NOT NULL ,PRIMARY KEY ( `id` ) )

 

table 2:

 

CREATE TABLE `ion2` (`id_test` INT( 2 ) NOT NULL ,`id` VARCHAR( 2 ) NOT NULL ,PRIMARY KEY ( `id` ))

[lemmin]

You might want to be more specific on what you are trying to do. The tables aren't automatically connected, if you create a common field, you use that field to link between the two tables when pulling the data.

[alin19]

i wish to make some conexion, when inserting in a table some values, some of them to be also inserted in the second one, the same with the update,

 

 

can you explain to me how can i pull the the data when i have the 2 tables linked?

 

 

table 1                            table2

 

 

id      nume                      id  prenume

 

with:

 

select * from 'table 1'   

 

i will get nume and prenume?