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 =
Galen,
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 until the '*/' at
GWW> the e
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 */
>
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 = /var/ru
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
weather_data.Si
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]
> S
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 weather_dat
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
weather_data.Site='
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: Peter
> 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
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';
Th
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 LE
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 Subscriptions.li
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
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 tim
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. juni
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 PR
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
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
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 w
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 again
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 NU
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 */
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 "ROLLB
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 look
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 ar
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 -
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
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
(p
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
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.
http://www.my
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
-> weather_locations.Meta
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
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
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 r
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);
"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).
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
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)
htt
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 :
>
> Hell
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 UN
--- 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.
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 ($m
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");
>
>'detail_start_date_y,detail_start_date_m,detail_start_date_d,detail_start_time_h,detail_start_
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).
>
>
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 c
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 have
47 matches
Mail list logo
