How to link a table to a field a in MySQL server
- by Nek
I have this data from a xml file:
<?xml version="1.0" encoding="utf-8" ?>
<words>
<id>...</id>
<word>...</word>
<meaning>...</meaning>
<translation>
<ES>...</ES>
<PT>...</PT>
</translation>
</words>
This forms the table named "words", which has four fields ("id","word","meaning" and "translation"). On the other hand, the "translation" field can hold several languages like ES,PT,EN,JA,KO,etc... So I create a table ("words.translation", one field is "id" and the others ones are languages ids like "ES","PT",...).
I'm sorry for this newby question, but I'd like to know a couple of things about this one-to-many relationship.
How to join (or link?) this two tables in MySQL?
What information does the "translation" field in the "words" table has to store?
How is the sql query to get all the word information (JOIN syntax used?)
Thanks for your patience.