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
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 _customers_
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
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,
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 way of
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
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
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
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: [EMAIL PROTECTED]
Subject: More Left Join problems
I had posted a message earlier this week about my
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: [EMAIL PROTECTED]
Subject: More Left Join problems
I had posted a message earlier this week about my 'Left Join' taking
too
long
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 formatting the query. Here is
the query in a more readable format. I
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: [EMAIL PROTECTED]
Subject: More Left Join problems
I had posted a message earlier this week about my 'Left Join' taking
too
long
that it 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
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 2002 19:54:46
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 2002 19:54:46
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
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
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:
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
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,
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
GROUP
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,
23 matches
Mail list logo