Paul,
I just picked up your book today: MySQL Cookbook and I just wanted to
comment on how great it is.
I've spent hours at the bookstore looking through mySQL books, and by
far this is the best one I come across.
I strongly recommend it to anybody--Beginners, Intermediate, or Advanced
Users.
TASK:
I have to generate a report with all categories, subcategories and
products in database.
PROBLEM:
I want to write one query that will return:
1. category
2. subcategory: determined by parent_id
3. products in each category or subcategory.
I have four tables with the following structure:
-
At 14:25 -0700 7/18/03, SAQIB wrote:
Paul,
Does this optimize the query? I thought both of the queries will have the
same relational algebra representation. Am I wrong?
They're logically equivalent, yes.
You appear to be under the impression that MySQL will *not* optimize
your original statement.
At 19:15 -0500 7/18/03, Andy Hartman wrote:
After I downloaded the Ver 5 Dev tree how do I get it active. I
tried the Windows stuff on the Mysql site with no luck.
"the Windows stuff"? Please be more specific.
The INSTALL-WIN-SOURCE file in the top-level directory of the source
tree may be o
Also: PhpTriad is now Sokkit. I'm having a very hard time getting PhP to
post to Mysql. I sent them an email requesting help. Will try to
remember to give you any answers I get from them.
[EMAIL PROTECTED] wrote:
Hi!!
I had once installed PHPTriad, a package which installs
php, apache and mys
From the Manual section 2.2.2.1
1. If you are working on an NT/2000/XP server, logon as a user with
administrator privileges.
2. If you are doing an upgrade of an earlier MySQL installation, it
is necessary to stop the server. If you are running the server as
a service, use:
C:\
Hi!!
I had once installed PHPTriad, a package which installs
php, apache and mysql on windows machines, and since I
wanted to update my mysql and php version I uninstalled
the package.
Then I tried installing php manually and did the smae
with mysql, installing it under a different hd. The
p
At 15:15 -0500 7/18/03, Kyle Goetz wrote:
hey, i'm new to mySQL...this meaning that i have tried ~1 times to
install it and get it working over the past few weeks...and it always gives
me the same error (scroll further down to see it) despite following the
manual's windows installation exactly
Hi Andrew,
Unfortunately I am not, but I figured that it would probbaly take only 30-60
minutes to get the system set up on a machine ;-)
Have you tried it yet ?
You could login and use
SHOW TABLES;
DESCRIBE TABLES;
to find the information you require.
Best regards
Nils Valentin
Tokyo/Jap
After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows
stuff on the Mysql site with no luck.
I run WIndows/ME and have Ver3.23 running. When I try to use the instructions for
Compile it fails looking for .c pgms
How do I get this to work... would like to use
Actually all the errors are the same file.. But I suspect the compiler is just dying
at the number
Here is the first page or so from the BuildLog.htm
Build Log
--- Build started: Project: mysqlpp, Configuration: Debug|Win32 ---
Command Lines
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 18 Jul 2003 15:42:47 -0400, Chris Edwards wrote:
>I have multiple OR logic in the where clause.
> where id = 1 or id = 2 or id = 3
>The list is finite, at about 20 ids.
>
You can also do this:
where id in (1,2,3)
- --
jimoe at sohnen-
If you've got 157 errors it probably won't be to hard to track down. What
are the 1st couple of errors? You probably don't have your environment set
correctly.
Pat...
[EMAIL PROTECTED]
SW Florida's 1st ISP
- Original Message -
From: "Ron Ohmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED
I would like to use MySQL++ in an application I am writing in Visual Studio.NET 2003.
Does anyone out there have or could point me to a zip of the source that could easily
be compiled for this purpose. The VC++6 one gave me 157 errors, which would be a bear
to track down.
Thanks!
Ron Ohmer
Hi Rob,
Error_reporting is set to 2039 and the script is not written in an
object-oriented way. When you type too many characters in the textarea, you
can't even get a simple print("Hello World!"); statement to work; I am
really surprised with that...
Could you please offer any other perspectives
Paul,
Does this optimize the query? I thought both of the queries will have the
same relational algebra representation. Am I wrong?
Thanks.
Saqib Ali
-
http://www.xml-dev.com
On Fri, 18 Jul 2003, Paul DuBois wrote:
> At 15:42 -0400 7/18/03, Chris Edwards wrote:
> >Hi
> >
> >This has pr
Hi
This is working...
Thank You
Zoltan
- Original Message -
From: "Cabanillas Dulanto, Ulises" <[EMAIL PROTECTED]>
To: "MYSQL Lista" <[EMAIL PROTECTED]>
Sent: Friday, July 18, 2003 10:54 PM
Subject: RE: SELECT help
> Try with :
>
> SELECT tparts.name,
>a.n
Try with :
SELECT tparts.name,
a.name,
b.name,
tmovement.quantity
FROMtmovement inner join tparts on (tmovement.part_id = tparts.Id)
inner join twarehouse a on (
tmovement.incoming_id = a.Id )
Hey all,
Have a very peculiar problem. First off -
OS: FreeBSD 4.7
MySQL version: Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.7 (i386)
(I have also compiled 3.23.53)
The problem:
I have written a class that connects to and disconnects from the database.
Everything works fine when I instantia
hey, i'm new to mySQL...this meaning that i have tried ~1 times to
install it and get it working over the past few weeks...and it always gives
me the same error (scroll further down to see it) despite following the
manual's windows installation exactly
i have version 4.0.13 for windows and i u
HI all!
I want make the SELECT for this situation.
Example:
Twarehouse
--
IDname
---
01Spring_WH
02Screw_WH
03Toll_WH
Tparts
--
IDname
---
01M3 screw
02
Thanks all, I had to use the use database name as well as put the password in the
first line and that worked...
>>> Paul DuBois <[EMAIL PROTECTED]> 07/18/03 02:59PM >>>
At 14:44 -0500 7/18/03, Taylor Lewick wrote:
>I have a large SQL file that contains a bunch of create table statements...
>How d
At 14:44 -0500 7/18/03, Taylor Lewick wrote:
I have a large SQL file that contains a bunch of create table statements...
How do I get mysql to read in this file and process the sql.
mysql < file.sql
or
mysql db_name < file.sql
if you need to set the database name first.
--
Paul DuBois, Senior
At 15:42 -0400 7/18/03, Chris Edwards wrote:
Hi
This has probably come up before...
Using version 3.23.54
I have multiple OR logic in the where clause.
where id = 1 or id = 2 or id = 3
The list is finite, at about 20 ids.
I know i can say where != if the the OR count is more than half the
after creating the database with "mysql create DATABASE"
do a mysql < .sqlfile.
Make sure to add the line use DATABASENAME; at the top of the sql file.
On Fri, 2003-07-18 at 14:44, Taylor Lewick wrote:
> I have a large SQL file that contains a bunch of create table statements...
> How do I get mys
If your data is properly Normalized, then this is the best way.
Saqib Ali
-
http://www.xml-dev.com
On Fri, 18 Jul 2003, Chris Edwards wrote:
> Hi
>
> This has probably come up before...
>
> Using version 3.23.54
>
> I have multiple OR logic in the where clause.
>
> where id = 1 or id = 2
I have a large SQL file that contains a bunch of create table statements...
How do I get mysql to read in this file and process the sql.
I am not thinking load data infile because it isn't text...
Please No
Hi
This has probably come up before...
Using version 3.23.54
I have multiple OR logic in the where clause.
where id = 1 or id = 2 or id = 3
The list is finite, at about 20 ids.
I know i can say where != if the the OR count is more than half the list
items
Is there any other way to provid
First off, this is the first time I have done replication in MySQL so the
problem very well may be my fault. I run a simple master / slave setup that
Replicates one database. Replication works for a day or two then for
reasons unknown to me I see this on show slave status, "Last_error: error
'Ser
Ola Ogunneye wrote:
Hello all,
I have just finally finished my error free installation of mysql 4.0.13
on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced
Server.
I was able to follow a direction that helped me change the root user to
myname and asign a password to myname. Aft
Hello,
I am trying to find a solution for the following scenario. The topic is
replication/high-availability/redundancy and sync.
I have three computers, A, B and C. "A" and "B" are operating important
hardware (astronomical telescopes TEL_A and TEL_B), and the operation
parameters as well as log
At 12:29 -0500 7/18/03, Tom O'Neill (MySQL User) wrote:
Hi,
Is there a way I can run a query that will delete all items that are not in
a list? For example I have a bunch of records in a table and I want to
remove all of them that are not in a comma delimited list that I have
recieved from anothe
Hi,
Is there a way I can run a query that will delete all items that are not in
a list? For example I have a bunch of records in a table and I want to
remove all of them that are not in a comma delimited list that I have
recieved from another application. I was thinking that I could create a
que
At 12:40 -0400 7/18/03, John Larsen wrote:
Does anybody know if there is a way to aggregate a table then join
it to another table?
I assume this would be possible with a subquery as in
SELECT * FROM t1 WHERE t1.a=(SELECT sum(t2.b) FROM t2 group by t2.c);
Except when I do it with 4.1alpha I get er
Does anybody know if there is a way to aggregate a table then join it to another table?
I assume this would be possible with a subquery as in
SELECT * FROM t1 WHERE t1.a=(SELECT sum(t2.b) FROM t2 group by t2.c);
Except when I do it with 4.1alpha I get error
"[root] ERROR 1240: Subselect returns mo
Nope, same situation...When you hit the submit button, nothing happens...I
check the database afterwards and find out that nothing was inserted...
George
"I think there is a world market for maybe five computers."
Thomas Watson, Chairman of IBM, 1943.
- Original Message -
From: "Rob A. B
are there any of you guys really familar with the mysql table structure of
oscommerce and in particular the search queries?
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Rob,
The script is indeed written in PHP version 4.3.1. The full version of mysql
I am using is 3.23.30-gamma.
Thanks,
George
"I think there is a world market for maybe five computers."
Thomas Watson, Chairman of IBM, 1943.
- Original Message -
From: "Rob A. Brahier" <[EMAIL PROTECTED]>
Is it possible to limit the query time in MySQL (3.x or 4.0)? For
example, I'd like to have any query that takes more than a specified
number of seconds just quit automatically. Seems dumb, but on a web
site, nobody is going to wait minutes for a query to return so they
refresh anyway. So on a
Hello. How can I set up a table that allows multiple file attachments per record.
Basically, if I have a table of clients, and I want to add or remove attached files
for a client, I dont want to have to create a set number of blobcolumns ahead of time,
so is there a way to dynamically add more f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> Java "write once, run anywhere" works for Connector/J: it is the same for
> all platforms.
>
> Works under Windows 2K for me.
>
> --
>
> Quick and simple question. Does the windows ve
Jason - I just tried:
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'X'
on the server machine in a mysql console and I got the following:
ERROR 1045: Access denied for user: '@localhost'
...in addition to my questions below, why doesn't that work! Ahhh!
-Original Message-
F
"Ola Ogunneye" <[EMAIL PROTECTED]> wrote:
>
> I have just finally finished my error free installation of mysql 4.0.13
> on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced
> Server.
>
> I was able to follow a direction that helped me change the root user to
> myname and asign a p
"Colt Brunton" <[EMAIL PROTECTED]> wrote:
> I am trying to adapt a query, (kindly) given by Rudy and I can't seem to
> debug it.
>
> Here is the query:
> CREATE TABLE Contact
>(SELECT
>ContactNo,
>W
Sorry Rudy
Still no luck Can't seem to figure out what's wrong.
CREATE TABLE Contact
SELECT
ContactNo,
Work_Address,
Field20,
Hello all,
I have just finally finished my error free installation of mysql 4.0.13
on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced
Server.
I was able to follow a direction that helped me change the root user to
myname and asign a password to myname. After that, I created 3 da
"Rudy Metzger" <[EMAIL PROTECTED]> wrote:
> Better ifnull(sum(amount_paid),0)
Yes, you are right.
>
> Because if you add up a column which contains NULL and NOT NULL values,
> all NULL values are SKIPPED for the calculation.
>
> This implies that if the column ONLY contains NULL values, the re
Don't do that, if it's possible.
You'll probably slow down the server.
Try to save file in a directory and save to database only the filename. [you
may want to rename the file so you won't overwrite diff pics with the same
name]
vioss
- Original Message -
From: "Egor Egorov" <[EMAIL PROT
Sorry, MySQL does not like the ( ). Try it without them :)
Cheers
/rudy
-Original Message-
From: Colt Brunton [mailto:[EMAIL PROTECTED]
Sent: vrijdag 18 juli 2003 15:38
To: [EMAIL PROTECTED]
Subject: Query debugging
Hi all
I am trying to adapt a query, (kindly) given by Rudy and I can't
"Sreesekhar Palaparthy" <[EMAIL PROTECTED]> wrote:
> Hi,
> I want to store jpg files to BLOB field of a table. That
> table has other fields which are integer and char types. So i
> tried inserting image using
> LOAD DATA INTO .. statement . It got stored , but when i
> retrieve it bac
The checking is done from the mysql command line tool and all special
characters are properly quoted (even tried it with a sequence of characters
without any punctuation marks or anything else). The mysql_query() call has
a die() statement as well but it is not coming up.
George
"I think there is
They type the information from a web page.
George
"I think there is a world market for maybe five computers."
Thomas Watson, Chairman of IBM, 1943.
- Original Message -
From: "Ed Leafe" <[EMAIL PROTECTED]>
To: "Lekeas GK" <[EMAIL PROTECTED]>
Cc: "gerald_clark" <[EMAIL PROTECTED]>;
<[EMAI
"Luc Foisy" <[EMAIL PROTECTED]> wrote:
>
> allowing date range options to the command line would be really neat
Date or datetime option?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___
On Friday, July 18, 2003, at 09:25 AM, Lekeas GK wrote:
The version of MySQL is 3.23, the platform is Solaris, the language is
English and the way I check whether data has been entered in the
database or
not is by running a select query on the database.
Was that of any help? I tried searching t
Hi Roger,
I guess you were right and I made the spelling mistake. ;-)
I read your other posts to, especiall the long one.
I respect your opinion, also I don't fully agree ;-)
At the end everybody has to use what he is happy with. I am strongly
Linux/Unix based so for me there is not need for a A
Lekeas GK wrote:
Gerald,
The version of MySQL is 3.23,
That only spans 50 some odd releases. Which one?
the platform is Solaris, the language is
English
Computer language.
PHP?
Perl?
Python?
Mysql command line tool?
Did the program performing the insert properly quote special characters?
Did
I have what I (and my boss) consider to be a sort of serious problem with an install.
I've downloaded and installed (per an instructor's request), the latest version of
MySQL. Granted, this is not a purchased package, but is required for a class in SQL
I'm taking through Kaplan College. When
I highly recommend you go to http://www.mysqlstudio.com/ and buy
Navicat. Extremely helpful GUI for creating and managing your MySQL
databases!
H
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all
I am trying to adapt a query, (kindly) given by Rudy and I can't seem to
debug it.
Here is the query:
CREATE TABLE Contact
(SELECT
ContactNo,
Work_Address,
Gerald,
The version of MySQL is 3.23, the platform is Solaris, the language is
English and the way I check whether data has been entered in the database or
not is by running a select query on the database.
Was that of any help? I tried searching the net but couldn't find more
information about wh
I've been through the mysql doc for the C API in both mysql 4.0 and 4.1, but
I don't see anything that explicitly supports non-blocking and/or
cancel-able operations. For example, the mysql_real_query API doesn't take
a timeout value and doesn't have any way to issue an asynchronous request.
The m
You supply almost no useful information here.
What version of MySQL are you using?
What platform?
What language?
How do you check to see if anything was entered?
Lekeas GK wrote:
Hi All,
I am managing a small database where a few fields are defined as being of
type text. In my understanding, this
Try this
http://www.cpp-home.com/tutorial.php?22_1
Hope it helps
"dave" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi, is mysql compatible with c++ in linux? I cant seem to get it
> working any sample c++ script would do. thanks in advance.
>
> dave
>
>
> --
> MySQL Gener
Better ifnull(sum(amount_paid),0)
Because if you add up a column which contains NULL and NOT NULL values,
all NULL values are SKIPPED for the calculation.
This implies that if the column ONLY contains NULL values, the result is
NULL.
Would be great if MySQL could post a chart somewhere of how t
"Emanuele" <[EMAIL PROTECTED]> wrote:
>
> I have problem to download
> http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
Worked for me.
But MySQLGUI is no longer under development. Take a look at MySQL Control Center.
--
For technical support contracts, goto https://
Hi All,
I am managing a small database where a few fields are defined as being of
type text. In my understanding, this would allow the user to enter up to
about 65,000 characters in the text field.
However, if the user types about 2,000 characters, then nothing is entered
in the database. I have
Hi all,
i am unable to install mysql 4.0 on my Rh. 6.2 box.
i have glib 1.2.6. When try to install the mysql it
gives the message "Mysql-server-version no.cannot be
installed"
May i know what are the minimum requirment for
installtion of mysql 4.0
Thanks to everyone who replied. I have been able to clean up the code and
it works fine now.
Thanks again.
On Fri, 18 Jul 2003, Rudy Metzger wrote:
> Can you please post the source code?
>
> In any case, I would consider using DBI.
>
> Cheers
> /rudy
>
> -Original Message-
> From: Ashw
Doug Reese <[EMAIL PROTECTED]> wrote:
> hello victoria,
>
> thanks for your response. however, the real goal of my question still
> remains unanswered: given my sample data, how would i find the balance on
> an invoice with one sql statement. sure, i could query for the amount
> paid, then i
"Moritz Steiner" <[EMAIL PROTECTED]> wrote:
> Thanks a lot, that solved my problem!
In additional, wait_timeout is set if you only specify wait_timeout variables. You can
check it with mysqladmin -uuser_name -ppassword var | grep timeout.
mysql client program is running in interactive mode. In t
Thanks a lot, that solved my problem!
Moritz
-Ursprüngliche Nachricht-
Von: Egor Egorov [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 18. Juli 2003 10:16
An: [EMAIL PROTECTED]
Betreff: Re: WG: wait_timeout in my.cnf
On Wednesday 16 July 2003 16:10, Moritz Steiner wrote:
> Like this:
>
>
Java "write once, run anywhere" works for Connector/J: it is the same for
all platforms.
Works under Windows 2K for me.
--
Quick and simple question. Does the windows version of
Connector/J
run under Windows NT, the documentation implies only 9X and ME
On Thursday 17 July 2003 12:59, zafar rizvi wrote:
> hi
> i have running MySQL version 3.23.52.
> and using Linux 8.0
Does your MySQL server crash when you try to connect remotely?
Linux 8.0 - SuSe? Red Hat?
>
> Tx
> ZafAr
> - Original Message -
> From: "Victoria Reznichenko" <[EMAIL PRO
Hi,
I'm new to mysql but my Idea would be if we have
A, B, C, D, E, F, G, H, I.
and the most commun are
A C E
i would of thought doing
ABG
CDH
EFI
to give the best results.
Anthony
- Original Message -
From: "Rudy Metzger" <[EMAIL PROTECTED]>
To: "awarsd" <[EMAIL PROTECTED]>; <[EMA
I'm not sure about NT, but it works under 2000 (for me)
Andrew Olden
School Of Applied Sciences
University Of Glamorgan
x2227, [EMAIL PROTECTED]
-Original Message-
From: William Smith [mailto:[EMAIL PROTECTED]
Sent: 18 July 2003 10:12
To: '[EMAIL PROTECTED]'
Subject: Connector/J
Hi
Hi there
Quick and simple question. Does the windows version of Connector/J
run under Windows NT, the documentation implies only 9X and ME
Regards
Will S.
NOTICE AND DISCLAIMER:
This email (including attachments) is confidential. If you have received
this email in e
The optimal way for query speed would be to combine the most commonly
used categories. Because when you search the query categories, you will
find out that there is a small set of combinations (say 10) which are
used 90% of the time.
Example: you have the categories A, B, C, D, E, F, G, H, I. Afte
Can you please post the source code?
In any case, I would consider using DBI.
Cheers
/rudy
-Original Message-
From: Ashwin Kutty [mailto:[EMAIL PROTECTED]
Sent: donderdag 17 juli 2003 17:12
To: [EMAIL PROTECTED]
Subject: Select via Perl
I am trying to read a file and see if the content
CREATE TABLE NAME (
SELECT name, work
FROM A
UNION ALL
SELECT name, home
FROM A
WHERE home IS NOT NULL
);
CREATE TABLE ADDRESS (
SELECT work
FROM A
UNION ALL
SELECT home
FROM A
WHERE home IS NOT NULL
);
Cheers
/rudy
-Original Message-
From: Colt Br
On Wednesday 16 July 2003 16:10, Moritz Steiner wrote:
> Like this:
>
> # The number of seconds the server waits for activity on a connection
> # before closing it
> wait_timeout= 300
Set interactive_timeout=300, too.
>
> -Urspr?ngliche Nachricht-
> Von: Egor Egorov [mai
HI!
I have problem to download
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
Is there some problem?
Thanks.
Emanuele
81 matches
Mail list logo
