On 4/19/07, Manuel Vacelet [EMAIL PROTECTED] wrote:
Hi all,
I wonder what is the impact of the disk space left for a mysql DB
(MyIsam, Linux 2.6, Ext3, RAID5).
I mean, I there a kind of limit to not cross to limit the performances impact ?
Hi everybody,
Nobody can answer my question ?
Or
Hi,
I want
select
item detials(date and qty) sum(qty)
'a01', '2007.01.01: 10/2007.02.03: 10',20
'a02', ' 2007.01.10: 20/2007.02.12: 30',50
'a03', ' 2007.01.18: 20', 20
from
table2
date,item,qty
I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a
noticing A LOT of errors in there like the following:
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information
in file: '.\nfcamp\societies.frm'
This spans multiple databases and tables. I am
Guys,
I have the following table that contains some information about a
cars. I'm trying to write a query to determine:
the number of make(name of car), number of models per make(name of
car) and the average number of models/make(name of car) sold in a
particular period.
The two queries
I have a mysql v 5.0 server running on Suse Linux 10.1. It has been
running steadily and properly for several months now. However, when I
came in this morning, my network card in the machine was bad. I
replaced the card and reconfigured the network, but ever since then, I
can only connect to
I would think that:
SELECT email FROM participants
WHERE email NOT IN (SELECT email FROM excluded)
would do the trick
andy
I am trying to do something like this
select email from participants
minus
select email from excluded
It seems there is no minus function in MySQL. I tried
At 11:36 AM 4/23/2007, Drew Burchett wrote:
I have a mysql v 5.0 server running on Suse Linux 10.1. It has been
running steadily and properly for several months now. However, when I
came in this morning, my network card in the machine was bad. I
replaced the card and reconfigured the network,
Thanks for the idea, but I did get the right IP address on it. No DHCP.
Drew Burchett
United Systems Software
Ph:(270)527-3293
Fax: (270)527-3132
-Original Message-
From: Barry Newton [mailto:[EMAIL PROTECTED]
Sent: Monday, April 23, 2007 11:17 AM
To: Drew Burchett
Cc:
I have a table which will be searched via some of the fields in the
column.
An example of the list of searcheable columns:
make
model
body_color
tire_type
hub_caps_type
The thing is that people might do a search using one or many of the
fields as criteria.
For example someone might
James,
A lot depends on how many rows you are searching on. If you only
have a couple thousand rows, then a table scan will still be fast. If you
are searching more rows, say more than 10,000, then using the proper index
will speed things up. Using a compound index is only useful if
I don't feel the implementation direction this article takes is good. It
uses single row binary storage, which anyone who has had to deal with
large files knows is a definate issue.
On Sat, 21 Apr 2007, Kevin Waterson wrote:
This one time, at band camp, Michael Higgins [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
I don't feel the implementation direction this article takes
is good. It uses single row binary storage, which anyone who
has had to deal with large files knows is a definate issue.
Just wanted to thank
Hello MySQL experts,
I am trying to create a view whose access is based on a User ID that
need to be looked up in a different table.
Here is an example of what I'm trying to do:
CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL
SECURITY DEFINER VIEW `shared_v` AS select `Shared`.`ID`
Mysql 4.1 also support this group_concat().
Thank you !
Shuming Wang
14 matches
Mail list logo