MySQL Database Forum

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.

------=_NextPart_000_003E_01C34D83.A02DB370 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi!! I had once installed PHPTriad, a package which installs=20 php, apache and mysql on windows machines, and since I=20 wanted to update my mysql and php version I uninstalled=20

hey, i'm new to mySQL...this meaning that i have tried ~10000 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 used the installer once i was done, i...

------=_NextPart_000_0019_01C2D79A.9497FFC0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable HI all! I want make the SELECT for this situation.....

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. =20 I am not thinking load data infile because it isn't text... **************************************************************** =09 Please Note The information in this E-mail message is legally...

Using a Java program, I can connect to the test database in MySQL. The test database is installed using a MySQL utility, and it can be accessed by any user without supplying a password. The relevant lines in my Java (Java version 1.4.1) code are: Connection con = null; String url = "jdbc:mysql:///test"; // <== no user or password specified...

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 query that says: WHERE id != 'item1' AND id...

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 " ERROR 1240: Subselect returns more than 1 record" I though that was the whole...

I am getting errors while compiling DBD-mysql 2.9002 on HP-UX 11.00 I have perl 5.8 downloaded from HP depot installed at /opt/perl Mysql 4.0.13 compiled myself with gcc with Mysql recommended options and working fine I am getting this error ..... Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs

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/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw

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 busy server, MySQL ends up with several queries...

Hello, I'm currently working on a MySQL database that is nearing completion. I need to design some sort of web interface to let people view it (it's read-only). I use Apache and I know Perl, so can somebody point me to a tutorial or something that explains how to call MySQL databases from Perl and display the results neatly formatted in...

--=_9CC2B6D0.7C1D6E08 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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.

------=_NextPart_000_0024_01C34D0E.474DFC80 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable 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...

------=_NextPart_000_0024_01C34D0E.474DFC80 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable 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...

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 checked the max_packet_allowed and the...

------=_NextPart_000_0039_01C34D4C.F19F7B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, =20 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

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 checked the max_packet_allowed and the...

------=_NextPart_000_0039_01C34D4C.F19F7B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, =20 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

Hi, I'm having a problem with decimal places in an ecommerce website. I have insterted the prices for products into the DB and set the decimal places to 2. The problem comes when I enter a number such as 1.50 which then becomes 1.5 in the database. This isn't a problem with my code as if i manually insert the same figure, the result is the...

Thanks a lot, that solved my problem! Moritz -----Urspr=FCngliche Nachricht----- Von: Egor Egorov =20 Gesendet: Freitag, 18. Juli 2003 10:16 An: mysql@lists.mysql.com Betreff: Re: WG: wait_timeout in my.cnf

------_=_NextPart_001_01C34D0C.B261DC50 Content-Type: text/plain; charset="iso-8859-1" Hi there Quick and simple question. Does the windows version of Connector/J run under Windows NT, the documentation implies only 9X and ME

------=_NextPart_000_004F_01C34CC0.ACC94810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI! I have problem to download=20 http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip=

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 back , i'm not able to see the image file.I hope it didn't get stored in proper format. How do i acheieve this ??...

Folks, When creating a table, is there any advantage in specifying the columns in any special order? For example, what about columns with data used more frequently listed first, or column/data types giving some? Or.... am I being pedantic even thinking about such? All help is much appreciated, thanx randelld