No problem, just didn't want to jump the gun if it was a known issue or
if it were clear from the posted traces that I was doing something
wrong.
-Original Message-
From: Stewart Smith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 10:54 PM
To: Robert DiFalco
Cc: [EMAIL PROTECTE
Hi everyone,
My name is Matthew Zito, and I'm the Chief Scientist for a company called
GridApp Systems based here in New York City. We're currently looking at
extending our database automation software to MySQL, and rather than assume
that MySQL users are facing the same challenges as Oracle
Peter,
I see... I was thinking 'db' might have been a system table name or
something...
This works perfectly, thanks.
Ben
Peter Brawley wrote:
Ben Clewett wrote:
Unfortunately I get:
mysql> SELECT
->
c.table_schema,u.table_name,u.column_name,u.referenced_column_name
-> FROM i
MySQL,
Another general comment, I'm interested in knowing
This excellent script from Peter takes over a minute to run, and only
identified RI (Referential Integrity) to one level of nesting.
If I try to delete a record and get 'a foreign key constraint fails',
this returns instantly with
MySQL,
Another general comment, I'm interested in knowing
This excellent script from Peter takes over a minute to run, and only
identified RI (Referential Integrity) to one level of nesting.
If I try to delete a record and get 'a foreign key constraint fails',
this returns instantly with
Hello, all -
It's been a while since I've posted here, but I read the list daily.
Thanks for all the help.
What I'm dealing with here is memory problems using MySQL 5.0.19 under
FreeBSD. Although I've enabled allocation of more memory per-process,
as described by the FreeBSD notes for 5.0.x
Hello MySQL Users
I have a contract table. Each contract has a certain level, which can be
in a range from 1-5. This information is stored as a number. There is no
additional table for the levels.
I would like to get a list with the amount of contracts of each level -
including 0 for the levels w
Hi Rhino, all,
Rhino wrote:
Hi Chris, Joerg, and everyone else following this discussion,
Joerg, you are correct; the best way to sum the tables is individually
and then add the sums together with program logic of some kind, [[...]]
I'm afraid I jumped in and gave correct but irrelevant inf
The schema of your contract should be like this:
Contract (id, level, ...)
where column 'id' is the primary key, isn't it?
If so, you can try this:
SELECT COUNT(id)
FROM contract
GROUP BY level
- Original Message -
From: "Jay" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 11, 2006 5:4
Thank you, Peng Yi-fan
but incase there is no contract with the level 5, it will not be shown.
I would like to see:
level amount
1 34
2 0
3 18
4 986
5 0
I could add it in the application, but I try to do it within the Query.
btw. the right join I mentioned, doesn
Hi Adam, all,
Adam Wolff wrote:
You could you use UNION to make this all execute in a single query.
Sure you can use UNION to get the data or the (separate) counts from the
four tables, but a plain UNION can not sum over these individual parts.
I have not checked whether you can have a UNI
Hi,
I think the syntax is to be verified.
myisamchk * * -u root -p *
///*.*
mysql will accept only if the passwords is next to "-p" option
**: some frequently used options are mentioned below
-r, --recover
-o, --safe-recover
-e, --extend-check
-q, --quick
-S, --sort-index
-f, --force ( to b
The easiest thing to do would be to create an additional table
containing all the possible valid values for contract level, then join
on that table to show counts. Otherwise it's just not possible to show
what's not there - in your case, think of this: how would MySQL know to
show 5 when there
hi,
Just to add up i have read some where ( i assume in the mailing list
only) that OS recognizes the file based on few codes added at the
starting / ending of a file. So there are ways to create a MYD file
through vi editor as well (this is not from the angle of restoring the
data in that
Ben,
This excellent script from Peter takes over a minute to run, and only
identified RI (Referential Integrity) to one level of nesting.
If I try to delete a record and get 'a foreign key constraint fails',
this returns instantly without any delay and to all nested levels of RI.
How does My
Thank you Dan,
[...]
> Otherwise it's just not possible to show
> what's not there - in your case, think of this: how would MySQL know to
> show 5 when there are no 5's, but not also show the count for every
> other integer that's not there? (6, 7, 8, .. 1048576, 1048577, etc.)
[...]
Sure, easy
No problem, glad to help.
I noticed your comment in an earlier message about it seeming like a
workaround - I don't think it seems like a workaround at all.
Having a table with the possible values makes for a normal database
structure, and an approach that should keep you from having to modif
Sorry for previous post without Subject line - send by accident.
Hi to all!
I have "products" table:
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varchar(255) NOT NULL default '',
`prod_description`
Thanks, Quentin, for the documentation.
Assuming that the Transact-SQL Help file is using various terms in the same
way as MySQL does, particularly "string expression" and "function", I think
we will find that the SQL SELECT will do all of the things that Stephen has
come to expect from the PR
[EMAIL PROTECTED] wrote:
Hi to all!
I have "products" table:
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varchar(255) NOT NULL default '',
`prod_description` text,
`prod_colors` text,
`prod_inclu
Ok. Got it.
And, since the able is already created and with tons of products inside,
how can I change the FULTEXT index?
I'm using phpMyAdmin.
Thanks
> [EMAIL PROTECTED] wrote:
>> Hi to all!
>>
>> I have "products" table:
>>
>> CREATE TABLE `products` (
>> `prod_id` int(8) unsigned NOT NULL a
Hello all,
I just inherited an application that has 2 tables under consideration, "events"
and "attribute_master". They are linked on (events.eventID =
attribute_master.id AND attribute_master.tableis = 'events'). In other words,
attribute_master.id is kinda like a foreign key to events.eventID
Damn, I really didn't mean to use that subject line; Sorry all!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dude! You just confused me with YOUR QUESTION under MY SUBJECT LINE
:) :) :)
You have to change a Subject and send it again. Or we will not know to
whom is sent.
:)
-afan
> Hello all,
>
> I just inherited an application that has 2 tables under consideration,
> "events" and "attribute_master".
<>
Hello all,
I just inherited an application that has 2 tables under consideration, "events"
and "attribute_master". They are linked on (events.eventID =
attribute_master.id AND attribute_master.tableis = 'events'). In other words,
attribute_master.id is kinda like a foreign key to events.eve
[EMAIL PROTECTED] wrote:
Ok. Got it.
And, since the able is already created and with tons of products inside,
how can I change the FULTEXT index?
I'm using phpMyAdmin.
Just create a new index.
http://dev.mysql.com/doc/refman/4.1/en/create-index.html
--J
[EMAIL PROTECTED] wrote:
Hi to all!
Not long ago, some highly knowledgeable people here kindly helped me
out with a fairly complex query...
Finding names of people (and other info) where one or more fields
match the search string in up to five tables (abstracting somewhat):
select distinct
id, firstname, lastname,
At 16:09 +0100 11/5/06, I wrote:
Not long ago, some highly knowledgeable people here kindly helped me
out with a fairly complex query...
...
That's all fine and dandy, but now I need to extend this to a
further four tables...
What I should have added is that for the moment this has to be
p
Following my post about this complex search I'm trying to do...
In the initial post I said I'd tried adding:
left join table_ga as tga on tga.id = r.id
left join table_a as ta on ta.ida = tga.ida
or:
left join (table_ga as tga inner join table_a as ta) on
(tga.id = r.id and ta.i
Yup. The problem solved!
Thanks John!
;)
-afan
> [EMAIL PROTECTED] wrote:
>> Ok. Got it.
>> And, since the able is already created and with tons of products inside,
>> how can I change the FULTEXT index?
>> I'm using phpMyAdmin.
>
> Just create a new index.
> http://dev.mysql.com/doc/refman/4.
I've just noticed in one of my databases a table named 'func', which I'm
positive I never created.
It was empty and has 4 columns:
mysql> describe func;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
Thanks for the response! Unfortunately, it is that simple.
A basic "Select * from vwMyView" yields an updatable recordset.
Adding "Order by Name" to the end does not allow an update.
I should mention that the error associated with the lack of update is:
"Insufficient Key Column Information f
Mysql 4.x
I have a one to many case, key is `id`, in this case, I have tables users
and transactions.
A user can have 1 to x transactions, each transaction has a status to it as
well. I want to be able to get users where there is a transaction status of
'wells', however, there can be more than o
Put your select here to us. With it we can help you better.
"Scott Haneda" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> Mysql 4.x
>
> I have a one to many case, key is `id`, in this case, I have tables users
> and transactions.
>
> A user can have 1 to x transactions, each tr
Scott, is it as easy as SELECT DISTINCT?
SELECT DISTINCT u.username
FROM user u, transactions t
WHERE u.userid = t.userid
AND t.status = 'wells'
Dan
Scott Haneda wrote:
Mysql 4.x
I have a one to many case, key is `id`, in this case, I have tables users
and transactions.
A user can have 1 to
Hello all,
I have inherited this query:
SELECT
events.eventID AS id,
attribute_master.attributeID AS attrib_id
FROM
events,
attribute_master
WHERE
events.status='8' AND
events.eventReview!='' AND
events.modlast > 1146470445 AND
event
At 18:28 -0400 5/11/06, Fan, Wellington wrote:
Hello all,
I have inherited this query:
SELECT
events.eventID AS id,
attribute_master.attributeID AS attrib_id
FROM
events,
attribute_master
WHERE
events.status='8' AND
events.eventReview!='' AND
I appreciate it but SELECT isn't quite what I want. It adds an extra 4
to 6 lines to the output (drawing the table, headers, row counts, etc).
PRINT simply outputs whatever comes after it:
PRINT 'hey you!'
would show:
hey you!
Not a big deal I suppose but it makes for a lot more scrolling
In a high activity OLTP environment with "heavy" UPDATE activity, which
table type is better?
I have one table which has many readers & a decent amount of UPDATE
activity.
Will BDB or MYIsam result in better performance & by how much better (please
quantify?
Stephen Cook wrote:
I appreciate it but SELECT isn't quite what I want. It adds an extra
4 to 6 lines to the output (drawing the table, headers, row counts,
etc). PRINT simply outputs whatever comes after it:
PRINT is not a SQL command. The mysql client (fortunately) does not
speak Basic.
T
40 matches
Mail list logo
