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
costs something to maintain the index, too. (Time to look for a book on SQL
that talks about such things...)
- Original Message -
From: Jacque Scott
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 6:28 PM
Subject: Re: More Left Join problems
Jacque Scott
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 2:18 PM
Subject: Re: More Left Join problems
Thanks for your time. I didn't think of formatting the query. Here is
the query in a more readable format. I have also taken out most of the
columns in the SEL
are testing
aren't available for the where clause to use.
- Original Message -
From: Jacque Scott
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 2:18 PM
Subject: Re: More Left Join problems
Thanks for your time. I didn't think of format
e the examples
as short as possible. I probably saw and ignored your earlier
question for that reason; I usually just skip messages where it
would take too long to decipher the question--I'd assume that other
people do the same.
HTH
Bill
> Date: Thu, 29 Jan 2004 08:03:25 -0800
> From
gnored your earlier
question for that reason; I usually just skip messages where it
would take too long to decipher the question--I'd assume that other
people do the same.
HTH
Bill
> Date: Thu, 29 Jan 2004 08:03:25 -0800
> From: "Jacque Scott" <[EMAIL PROTECTED]>
> To
I had posted a message earlier this week about my 'Left Join' taking too
long to run. This seems to be happening on all of my queries that have
a 'Left Join'. Does anyone have any suggestions on why this would
happen?
Here is one query which took 45.72 sec to run:
SELECT Products.NSIPartNum
ase?
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
...
Subject: Intermitent join problems
From: Frank Tuvell
Date: Tue, 19 Nov
ase?
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
...
Subject: Intermitent join problems
From: Frank Tuvell
Date: Tue, 19 Nov
I'm using PHP 4.22, MySQL 3.23.53a on a RedHat Apache web
server.
I have a join that 99.9% of the time works fine but there have been
3 occasions in the last few weeks where extra records have found
their way into the resulting dataset. This has happened during high
load times.
The join is a
Hi,
Do anyone know there may be a limitation in mysql to do a 15 tables equi-join?
I did some experiment with it if I only do 10 tables equi-join, it takes seconds to
retrieve the results,
but if I do more than 10 tables, it took forever and run with 100% CPU time to execute
the query.
The
Hi, you need a LEFT JOIN on your query.
See http://mysql.com/doc/J/O/JOIN.html
Try somthing like:
SELECT m.firstname, m.lastname
FROM tbl_membernames as m
LEFT JOIN tbl_paid as p ON (m.name_id=p.name_id and p.year=2000)
WHERE p.name_id IS NULL
On Mon, 2002-04-29 at 09:37, Markus Lervik wrot
Hello, list!
(filter-fodder: sql,query)
I've got a problem that's been bothering me for quite some time:
If I've got two tables, where I list people who's paid their
membership fee, year, etc., and another table with the names
tbl_membernames : name_id, firstname, lastname
tbl_paid: n
> Sir, your query doesn't work on my machine. I either have to GROUP BY
> orderID, or drop orderID and Name from the SELECT clause. I'm not
> sure what you're trying to do, so I don't know which to suggest.
Oh, sorry, I didn't check out what did I wrote... ;) Anyway, I got this work after
GROU
>Hi there,
>
>I have five tables in the database: customers, orders,
>ordercontents, products and payments. The problem is that I should
>get a list which shows some kind of a ledger list (shows who has
>paid and so on).
>
>My first try looks like this:
>SELECT orders.OrderID, customers.Name, S
Hi again,
(Posting this once again because I didn't ever get this back from list server)
I have five tables in the database: customers, orders, ordercontents, products and
payments. The problem is that I should get a list which shows some kind of a ledger
list (shows who has paid and so on).
Hi there,
I have five tables in the database: customers, orders, ordercontents, products and
payments. The problem is that I should get a list which shows some kind of a ledger
list (shows who has paid and so on).
My first try looks like this:
SELECT orders.OrderID, customers.Name, SUM(orderco
23 matches
Mail list logo
