MySQL Database Forum

Hi, I'm clear as to what is meant by "The mysql client" in the MySQL core certification revision check list. I understand that the mysql database itself is the "server". Would client then be any program that talks to the server? Perhaps it is referring to mysql, the command line tool? I understand "client side programs", examples being:...

I create a database, foo, then designate a user, pooh, with full privileges, including grant option (pooh is to administer this database, including creating other users): grant all on foo.* to 'pooh'@'localhost' identified by 'zoo' with grant option; Now pooh logs in to the mysql server, and tries to use his grant option

------=_NextPart_000_00E2_01C34DE9.4541BA40 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi, I need a hint how to use myisamchk I use this syntax in a shell but it doesn't work

------=_NextPart_000_004A_01C34E06.17F4DF00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable this is a test message ------=_NextPart_000_004A_01C34E06.17F4DF00--

By convention, MySQL is installed on the SYS: volume... I know you can move the whole data subdirectory... however can you have the different databases stored on different volumes... windows version uses a "sym" file... is there a similar feature for Netware?

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.

------=_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

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...

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...

--=_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...

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_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_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