Kim Christensen wrote:
> Hey list;
>
> Consider this statement:
>
> SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id
> = m.manufactor_id && p.product_id = i.product_id;
>
> Now, each unique product_id from "products" can have more than one
> entry in the "items" table, but I
When I do a SHOW TABLES in MySQL, it shows me a list of tables. But when I
try to do a "select * from countries", I get the error ERROR 1146 (42S02):
Table 'karate.countries' doesn't exist. I cannot drop the table. I cannot
drop the entire schema, and I cannot view the tables themselves. Doe
Nope, no backups happening at the time.
Anyone other ideas?
- John
At 11:42 AM -0500 6/12/06, Dan Buettner wrote:
Hi John -
Yes, at my former workplace, we had a couple of different instances
where we experienced severe crashing problems on G4-based machines.
Prior to using a G4 X
Hi, Daniel,
RE:
> I've had a big time looking for configs over the net and manuals,
> ended search with this:
> http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
[...]
Thanks for the links, I will check them again.
I read most of those that are available on the web.
> their way easil
On Mon, 2006-06-12 at 13:32 -0400, Jesse wrote:
> > Um, did anyone actually answer Jesse's question?
>
> The consensus seems to be that the correct way to pronounce it is My S-Q-L,
> Not My Sequel. So, that's the way I'm going to pronounce it. Actually,
> most of the people I say the name to h
I've had a devil of a time trying to import some data into a table in my
database, and one of the methods that I tried to use was the "visual" MySQL
Migration Tool. I figured I could use it to import data into my existing
database. I only had one table I wanted to import data into. Well, I got
Um, did anyone actually answer Jesse's question?
The consensus seems to be that the correct way to pronounce it is My S-Q-L,
Not My Sequel. So, that's the way I'm going to pronounce it. Actually,
most of the people I say the name to have no idea what I'm talking about
anyway. I only rarely
On 6/12/06, Gaspar Bakos <[EMAIL PROTECTED]> wrote:
-- Forwarded message --
Date: Mon, 12 Jun 2006 11:39:11 -0400 (EDT)
From: Gaspar Bakos
To: Barry <[EMAIL PROTECTED]>
Subject: Re: my-huge.cnf quite outdated
Hello, Barry,
RE:
> Guess we would answer to everyone on the list who
Hi John -
Yes, at my former workplace, we had a couple of different instances
where we experienced severe crashing problems on G4-based machines.
Prior to using a G4 Xserve, we were using a dual-G4 tower as our MySQL
and Intranet server, and as we ramped up MySQL usage, the hard crashing
got
Last year, after the effects of Hurrican Katrina, I decided to use my
expereince in the travel industry to develop a cause related marketing site
to help fund beach renourishment. My first attempt resulted in
www.texasfunbeaches.com, which is a static website I taught myself to build.
The backe
John May wrote:
I've got an xserve running 10.3.9 and MySQL 4.0.27-max that is
restarting itself every 2-3 days. It appears that it is due to a kernel
panic, though I don't have direct access to the machine (colocated) to
verify when it occurs.
There are no crash.logs from MySQL, and watchdo
I've got an xserve running 10.3.9 and MySQL 4.0.27-max that is
restarting itself every 2-3 days. It appears that it is due to a
kernel panic, though I don't have direct access to the machine
(colocated) to verify when it occurs.
There are no crash.logs from MySQL, and watchdog and system.logs
Take away the GROUP BY thing. And after that you just check if the rows are
in the order that you want. The upper row would be the one that GROUP BY
will take. Are you sure that you want the "lowest" value in the
"item_update"? I would like to have the highest value.
If you want the latest date, t
Hi!
When writting a SQL scripts, do you follow any standard SQL naming
convention? Similar to what described in
http://kurafire.net/articles/sql-convention
Does MySQL provides such naming convention guidelines and best practices?
--
MySQL General Mailing List
For list archives: http://lists.mys
-- Forwarded message --
Date: Mon, 12 Jun 2006 11:39:11 -0400 (EDT)
From: Gaspar Bakos
To: Barry <[EMAIL PROTECTED]>
Subject: Re: my-huge.cnf quite outdated
Hello, Barry,
RE:
> Guess we would answer to everyone on the list who wishes to optimize his
> cnf.
I don't guess, and don'
On Sunday 11 June 2006 12:25 am, Octavian Rasnita wrote:
> Hi,
>
> I have the following table:
>
> CREATE TABLE `z` (
> `hash` varchar(16) NOT NULL default '',
> `title` varchar(255) NOT NULL default '',
> `body` text NOT NULL,
> FULLTEXT KEY `title` (`title`,`body`)
> ) ENGINE=MyISAM DEFAU
On 6/12/06, Peter Lauri <[EMAIL PROTECTED]> wrote:
--
Here's what it looks like right now:
SELECT * FROM products p
INNER JOIN manufactors m ON m.manufactor_id = p.manufactor_id
INNER JOIN items i ON i.product_id = p.product_id
The problem is, that each entry in "produc
Gaspar Bakos schrieb:
Hi,
Isn't the my-huge.cnf in the MySQL 5.0.22 distribution quite outdated?
It says "for systems with 512Mb RAM or more". Nowdays this is pretty
basic setup, and 'huge' is probably something in excess of 4Gb RAM.
I wonder if anyone has a recommendation for truly huge system
Thanks friends.
Duncan Hill escribió:
On Monday 12 June 2006 14:16, Gabriel Mahiques wrote:
but I have a problem with this solution, because I have the words in the
middle of the phrase.
For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to
replace IT with Movie Kill Bill Vol 1
On Monday 12 June 2006 14:16, Gabriel Mahiques wrote:
> but I have a problem with this solution, because I have the words in the
> middle of the phrase.
> For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to
> replace IT with Movie Kill Bill Vol 1 in "dvd" format.
> In Another case I
but I have a problem with this solution, because I have the words in the
middle of the phrase.
For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to
replace IT with Movie Kill Bill Vol 1 in "dvd" format.
In Another case I have: "VHS" Trade Konami. . and I want to replace with
"DVD"
update table set field=REPLACE(field, 'vhs', 'dvd');
"Gabriel Mahiques" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> Hello friends.
> In need your help.
> I have a table with a field "Name: Varchar(255)".
> In this field "Name" I have a detail and I need replace in all record
I was getting a little OT there Gaspar.
It might be better for me to file a feature request on mysl
bug reporting page for any un-necessary functionality and
the associated documentation to be removed from mysql
in version 6.0.x, rather than hijacking this thread!
Regards
Keith
On Sun, 11 J
Hello friends.
In need your help.
I have a table with a field "Name: Varchar(255)".
In this field "Name" I have a detail and I need replace in all records a
word for another.
For example: I have "vhs" and I want to change the word "vhs" for the
word "dvd" in all records.
How can I do this?
--
S
--
Here's what it looks like right now:
SELECT * FROM products p
INNER JOIN manufactors m ON m.manufactor_id = p.manufactor_id
INNER JOIN items i ON i.product_id = p.product_id
The problem is, that each entry in "products" may occur more than once
in "items", and they are
On 6/12/06, Barry <[EMAIL PROTECTED]> wrote:
Kim Christensen schrieb:
> Hey list;
>
> Consider this statement:
>
> SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id
> = m.manufactor_id && p.product_id = i.product_id;
>
> Now, each unique product_id from "products" can have mo
On 6/12/06, Barry <[EMAIL PROTECTED]> wrote:
Kim Christensen schrieb:
> Hey list;
>
> Consider this statement:
>
> SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id
> = m.manufactor_id && p.product_id = i.product_id;
>
> Now, each unique product_id from "products" can have mo
How about:
select * from products p
inner join manufactors m on p.manufactor_id=m.manufactor_id
inner join items i on p.product_id=i.product_id and i.item_updated=1
Donna
"Kim Christensen" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/12/2006 06:15 AM
Please respond to
[EMAIL PROTECTED]
Kim Christensen schrieb:
Hey list;
Consider this statement:
SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id
= m.manufactor_id && p.product_id = i.product_id;
Now, each unique product_id from "products" can have more than one
entry in the "items" table, but I only want to
Hey list;
Consider this statement:
SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id
= m.manufactor_id && p.product_id = i.product_id;
Now, each unique product_id from "products" can have more than one
entry in the "items" table, but I only want to fetch the one which
fullf
Hello Ben, all!
Ben Burford wrote:
Hello,
This is my first message, I'm an absolute beginner in Mysql. I did a defaul
t installation of version 3.23.58 on RH Linux AS3.0. [[...]]
I will not comment on the backup issue, that has been done already.
However, I _strongly_ urge you to upgrade
Takanobu Kawabe schrieb:
> Hello, my name is Takanobu Kawabe.
>
> I have gotten a MySQL Network, and the service level is gold , I
> could login MySQL Network on May 20th ,
> but now I can't login. I have tried some times last week,
> and today , but I cannot do
Hello, my name is Takanobu Kawabe.
I have gotten a MySQL Network, and the service level is gold , I
could login MySQL Network on May 20th ,
but now I can't login. I have tried some times last week,
and today , but I cannot do it.
If I try to login (URL is
33 matches
Mail list logo
