Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hello,
I have a query I hope somebody can help me optimize. I have two tables
(given example):
CREATE TABLE area (
Area_ID INTEGER UNSIGNED,
Master INTEGER UNSIGNED
);
CREATE TABLE manager (
Manager_ID INTEGER UNSIGNED,
Person INTEGER UNSIGNED,
AreaINTEGER UNSIGNED
);
I
Tonu,
Thank you, thank you! The formal documentation effort is apparently still
underway based on your notes ... The link you included eliminates a lot of
guesswork! : )
This part of MySQL is written by me and I am sure it worked :)
I'm sure it does -- what I meant was that the way I had it
On Fri, 2002-06-14 at 18:16, Hathaway, Scott L wrote:
I am trying to get something like the following:
Title
-
topic #1
sub topic #1.1
topic #2
sub topic #2.1
sub topic #2.2
from the following table (I am using php for scripting).
forum
Hi Chris,
On Fri, 2002-06-14 at 02:08, Chris Kay wrote:
I have a rather longer query which I would like to get all records past todays date.
Here is my query
$ttwo = date(YmdGi);
snip
On Sat, 2002-06-15 at 05:31, Chuck Payne wrote:
...
// Some where here it's not working.
$sql = SELECT concat_ws(' ', fname, lname)as actor FROM actormovie WHERE
title = '$title' ORDER by lname;
$result = mysql_query($sql);
print $sql;
$actor = ;
while ($myrow =
--- Sinisa Milivojevic [EMAIL PROTECTED] wrote:
Thank you for your bug report.
Anytime! :-)
Regarding inconsistent values returned for MERGE
tables, please refer
to our manual on how are UNIQUE values treated with
MERGE.
I looked fairly thoroughly through the manual before
posting. Which
Peter Normann wrote :
Hello,
I have a query I hope somebody can help me optimize. I have two tables
(given example):
CREATE TABLE area (
Area_ID INTEGER UNSIGNED,
Master INTEGER UNSIGNED
);
CREATE TABLE manager (
Manager_ID INTEGER UNSIGNED,
Person INTEGER UNSIGNED,
Area
Sorry for not mentioning it, but yes I have indexed manager.Person...
Peter Normann
-Original Message-
From: httpd [mailto:httpd] On Behalf Of Joseph Bueno
Sent: 16. juni 2002 10:54
To: Peter Normann
Cc: [EMAIL PROTECTED]
Subject: Re: Help with indexing
Peter Normann wrote :
Hi all,
I accidently deleted some values in table using mysql .
Is there any way to undo the query ?
please advice.
thank you .
ally
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have install MySQL CC (control center) after some months living with
MySQL-front.
I think it is faster but:
1) How to delete a row without giving SQL command? Or append row?
2) How is possible to see in SQL the edit I am doing to one field?
Makis
Heikki Tuuri [EMAIL PROTECTED] writes:
good. I have also modified 3.23.52 so that it will generate a seg fault when
it runs out of memory. That way we will get a stack trace on Linux.
The error occered again. Now I se that I only pick 10 frames of the
stack (curse me for cut'n pasteing). If
A friend of my who is a programmer helped me only after I gave up on the
mailing answering me. So it is fix now. I had to the following...
// This is the actor query
$sql = SELECT concat_ws(\ \, fname, lname)as actor FROM actormovie WHERE
title = '$title';
$result = mysql_query($sql);
Hi to all,
I have builded a beta object for mysql pooling.
The results (with 1000 queries serialized) are still very good:
without pooling a simple SELECT and retrieving data need of around 16 msecs:
~63 queries for second (only)
with pooling a simple SELECT and retrieving data (same previous
Per,
- Original Message -
From: Per Andreas Buer [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, June 16, 2002 2:10 PM
Subject: Re: innodb keeps crashing due to out-of-memory errors.
Oh, by the way. The error does not occur if I use less memory.
please show us your
You might want to take a look at using dbtools 1.1.13 from
www.dbtools.com.br
mysql, query, sql
- Original Message -
From: savaidis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 16, 2002 5:38 PM
Subject: about MySQL CC
I have install MySQL CC (control center) after some
Hiya again,
Ok, based on all the info, feedback and help I got the last time, I was able
to construct the following query:
mysql SELECT weather_data.Temp,
-weather_locations.Name
- FROM weather_data
- LEFT JOIN weather_data ON
-
On Sun, 16 Jun 2002, mohamadally wrote:
Hi all,
I accidently deleted some values in table using mysql .
Is there any way to undo the query ?
No, there is not, unless the table was transactional and you were not in
autocommit mode.
This is where backups come in handy.
When trying to transfer a database from MS Access 2000 to MySQL, I encounter
this error message, ODBC--call failed. 37000: [Microsoft][ODBC microsoft
Access Driver] Syntax error in CREATE TABLE statement.
I am using MyAccess to do the transfer.
I am new at this in the MySQL area and, am running
Hello everybody,
I have two questions:
1) If I create a table with MAX_ROWS=10 and I insert 10 records. Then I
insert more 3 records. Does mysql delete older records and insert new ones??
2) I created a table using this:
CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY
Hi all,
I find php slow when accessing mysql. When I do
$sql='select count(*) from table';
$result = mysql_query($sql);
It takes 10 sec to return. Is this normal speed for php or my Mandrake Linux
configuration problem?
The same query run in mysql return instantly. Thanks
Hi,
Kind of a quick answer huh? If he had binary logging enabld and the last
inserts or updates are still in the log, he can get his data back.
mysqlbinlog and some greping and seding. I dropped a database and while it
wasn't super easy to do, I did get it back.
Eric
At 09:17 AM 6/16/02
AC I find php slow when accessing mysql. When I do
AC $sql='select count(*) from table';
AC $result = mysql_query($sql);
AC It takes 10 sec to return. Is this normal speed for php
Not at all.
If you need help in tuning your server from a PHP and Apache
standpoint, the PHP mailing lists are
On Sunday, 16. June 2002 17:07, Andy Cheng wrote:
Hi all,
I find php slow when accessing mysql. When I do
$sql='select count(*) from table';
$result = mysql_query($sql);
It takes 10 sec to return. Is this normal speed for php or my Mandrake
Linux configuration problem?
It looks like a
On Saturday, 15. June 2002 23:36, mohamadally wrote:
Hi all,
I accidently deleted some values in table using mysql .
Is there any way to undo the query ?
Yes,
for MyISAM-Tables use your backup or your replication server, for
transactional tables like Inno-DB or BDB you can use ROLLBACK
Hi,
I tried something like the following (MySQL 3.23.36 on RH7.1) and got
the error indicated below.
create table product ( /* The main table -- see below... */
id int not null auto_increment,/* some text here */
parid int not null,/* and here */
I think you need to use the following query:
mysql SELECT weather_data.Temp,
-weather_locations.Name
- FROM weather_data
- LEFT JOIN weather_locations ON
- weather_locations.MetarCode = weather_data.Site
- WHERE weather_locations.MetarCode IS NULL;
Sorry, I didn't read the mail through before replying... :-/
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 15:43
To: [EMAIL PROTECTED]
Subject: LEFT JOIN again... Although, this time I think it's a design
flaw rather than a query one
Hiya
I have two tables, 'items' and 'stuff'.
Items has a primary key of itemid. and looksmlike this
ItemID other fields...
1 ...
2
3
4
5
6
Stuff contains something like this:
ItemID type info
1 0blah blah
2 0something
2 1...
3 1...
I want a query
Hello,
I have the following nested query that I would like to port to Mysql:
SELECT * FROM ad_catego
WHERE db_subcategory NOT IN
(SELECT rules.db_subcategory FROM rules
WHERE rules.db_login='$session_login')
AND db_category_int =2
Try
SELECT Items.ItemID, Stuff.info FROM Items LEFT JOIN Stuff ON
(Items.ItemID = Stuff.ItemID (type=0 || type IS NULL));
Peter Normann
-Original Message-
From: mySQL list [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 17:59
To: [EMAIL PROTECTED]
Subject: A LEFT OUTER JOIN question.
SELECT ad_catego.* FROM ad_catego, db_subcategory
WHERE ad_catego.db_subcategory=rules.db_subcategory
AND rules.db_category != '2'
AND rules.db_login !='$session_login';
?
Peter Normann
-Original Message-
From: Balteo [mailto:[EMAIL PROTECTED]]
Sent: 17. juni 2002 00:12
To: [EMAIL
Oops, I meant
SELECT ad_catego.* FROM ad_catego, db_subcategory
WHERE ad_catego.db_subcategory=rules.db_subcategory
AND rules.db_category_int != '2'
AND rules.db_login !='$session_login';
?
Peter Normann
-Original Message-
From: Peter Normann [mailto:[EMAIL PROTECTED]]
Sent: 16.
I am currently a web designer who's taught himself the necessary basics of
PHP and MySQL. I've reached a point where I can't figure out a complex
query.
I have a mailing list that customers can sign up for if they want to receive
Special Offer mailings when products go on sale. So when it's time
Hi Peter,
Thanks a lot - that does the trick!
Incredibly quick response :)
Ian
-Original Message-
From: Peter Normann [mailto:[EMAIL PROTECTED]]
Sent: 16 June 2002 17:06
To: 'mySQL list'; [EMAIL PROTECTED]
Subject: RE: A LEFT OUTER JOIN question.
Try
SELECT Items.ItemID,
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
(Ordered_Items.productid = '23'))
WHERE Customers.id=Subscriptions.customerid
AND
You're welcome, Ian.
Being new to this list, I'm just trying to gather enough credit to get
people to look at my recent post ;-)
Peter Normann
-Original Message-
From: mySQL list [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 18:29
To: Peter Normann; [EMAIL PROTECTED]
Subject: RE: A
Ok,
It seems I spoke to soon here...
SELECT weather_data.Temp AS Temp, weather_locations.Name AS Name
FROM weather_locations
LEFT JOIN weather_data ON weather_locations.MetarCode = weather_data.Site
WHERE weather_data.Site='FACT' OR weather_data.Site='FADN' OR
weather_data.Site='FAJS';
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id
(Ordered_Items.productid = '23'))
WHERE Customers.id=Subscriptions.customerid
AND
Well, my best guess is that you should consider indexing your tables...
If you haven't done so already, indexing will cause dramatic effect on
the speed of the queries...
Peter Normann
-Original Message-
From: Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 19:18
To:
Does
SELECT weather_data.Site, weather_data.Temp, MAX(weather_data.Date) AS
Temp, weather_locations.Name AS Name
FROM weather_locations
LEFT JOIN weather_data ON weather_locations.MetarCode =
weather_data.Site
WHERE weather_data.Site='FACT' OR weather_data.Site='FADN' OR
mysql SELECT weather_data.Site, weather_data.Temp, MAX(weather_data.Date)
AS
- Temp, weather_locations.Name AS Name
- FROM weather_locations
- LEFT JOIN weather_data ON weather_locations.MetarCode =
- weather_data.Site
- WHERE weather_data.Site='FACT' OR
Looks good. However I can't work with my database using iso 8859-2 charset.
Does MyCC support this charset and how to activate it if it does?
Maciek
-Original Message-
From: Jorge del Conde [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 6:01 AM
To: [EMAIL PROTECTED]
Sorry, I forgot:
SELECT weather_data.Site, weather_data.Temp, MAX(weather_data.Date) AS
Temp, weather_locations.Name AS Name
FROM weather_locations
LEFT JOIN weather_data ON weather_locations.MetarCode=weather_data.Site
WHERE weather_data.Site='FACT' OR weather_data.Site='FADN' OR
Hi Heikki.
Heikki Tuuri [EMAIL PROTECTED] writes:
Oh, by the way. The error does not occur if I use less memory.
please show us your complete my.cnf.
# This will be passed to all mysql clients
[client]
#password = my_password
port= 3306
socket =
On Sun, 16 Jun 2002 [EMAIL PROTECTED] wrote:
Hi,
I tried something like the following (MySQL 3.23.36 on RH7.1) and got
the error indicated below.
create table product ( /* The main table -- see below... */
id int not null auto_increment,/* some text here */
snip
Galen,
snip detail - see previous post
GWW There is definitely something wrong with the parser. The '--'
GWW should not be interpreted as a single line comment, causing the
GWW first '*/' to be ignored, so the the entry for the 'id' column is
GWW considered to be part of the multi-line comment
Per,
set-variable= key_buffer=16M
set-variable= sort_buffer=1M
set-variable= record_buffer=1M
set-variable= max_allowed_packet=16M
set-variable= thread_stack=256K
set-variable = innodb_log_file_size=32M
set-variable = innodb_log_buffer_size=8M
set-variable =
48 matches
Mail list logo