Cristi,
> Ok, if you do not recommend a big ( about 20 columns ) table,
how
>can I do the join then and how do I add to each customer with the
same
>street name, street number, block of flats number and flat number,
an id
>that will help me join them ?
Oh, you mean get all the _customer
Hi,
Ok, if you do not recommend a big ( about 20 columns ) table, how
can I do the join then and how do I add to each customer with the same
street name, street number, block of flats number and flat number, an id
that will help me join them ?
I need to be able to see a customer even if
Hi,
I have the data from MS Access to MySQL, half imported by now, that
is not the problem, the same with importing from excel files.
The problem is how can I get all the data in one big table ?
Best regards,
Cristian Stoica
Peter Brawley wrote:
Cristi,
>In theory it is simple b
Cristi,
> In theory it is simple but I need some help on how that will be
>"translated" to mysql, I have a concept in mind, but I do not know
>how
to exactly apply it to the situation.
> I am in a situation where I have the data gathered from more
persons
>and everybody had a personal
Hi,
First of all thank you for your reply.
The table names I've wrote in the e-mail were just for info, I do
use underscore instead of space, as you can see I do the same for the
fields in the table.
In theory it is simple but I need some help on how that will be
"translated" to mysql
Cristi,
> I have the following tables: ( some in Microsoft Access and some
> in Excel ) and I want to migrate the data into MySQL and develop
> an interface in PHP for easy administration and control...
A few points:
1. Instead of spaces, use underscores or nothing in table names
2. If Ad
Hi,
I have the following tables: ( some in Microsoft Access and some in
Excel ) and I want to migrate the data into MySQL and develop an
interface in PHP for easy administration and control.
*1) Sales Representative Code
*sr_id INTEGER ( unique )
sr_user VARCHAR
sr_name VARCHAR
sr_email
