RE: Newbie Question - Query works in access but not MySQL

Do you have a space between PartNumber and Like? Also there's not need to ORDER BY - the GROUP BY does that anyway (I know that's the case elsewhere) and finally, I have to guess that it's objecting to Obsolete not being in the main select.. have you tried including it and grouping by it? you can

Re: why is this slow?

On Tue, 12 Nov 2002 10:24:34 +0800 Jaime Teng [EMAIL PROTECTED] wrote: At 04:47 PM 11/11/2002 +0800, Thomas Seifert wrote: Are you using MySQL-3.23.x? AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does). Maybe thats the cause? Hi, Yes. Im using 3.23.52(nt). I just upgraded it

Re: Bug? mysql 4.0.4 wouldn't look for my.cnf in the right location.

Pada Tue, 12 Nov 2002 14:43:34 +0900 Chung Ha-nyung [EMAIL PROTECTED] menulis: I compiled mysql 4.0.4 with option --prefix=/local/mysql -- datadir=/mnt/data but it is likely that mysql still look for my.cnf file in $prefix/var directory not in /mnt/data Is it a bug? add

Where can I get innodb monitoring tools?

innodb manual (http://www.innodb.com/ibman.html) mentions about innodb monitoring tools, e.g. innodb_tablespace_monitor. But they don't seem to be included in mysql 4.0.4. Should I buy them or can get somewhere else, like innodb homepage? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub

mysql_install_db hangs

Hello, One of my custommers use mysql database and a few days ago he asked me to solve the strange problem with it. I don't know the history of server so I am unable to feed you with information like what has been changed before problem occured, but below is the describtion of problem itself

Problem compiling mysqlgui 1.7.5

Hi, I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2 but with the make I got this : # gmake gmake: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. It would be great if you could help me with this ! Best regards, Pierre.

problem on installing mysql from mysql-3.23.52-sun-solaris2.8-sparc.tar

Hi, I faced a problem while installing Mysql mysql-3.23.52-sun-solaris2.8-sparc.tar I followd the instructions on INSTALL-BINARY then when I tryed to run mysql it gave my the following error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) the following what

SELECT....UNION SELECT.....

Hallo my friends I am writing a database application program with PHP and MySQL. I have two tables that I want to query in the same time with SELECT...UNION SELECT ... syntax. Too many errors encountered; the rest of the message is ignored: The 2 tables are APPOINTMENT table (APP) and

Re: SELECT....UNION SELECT.....

On Tue, 12 Nov 2002 12:02:04 +0100 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this

RE: How to port MS Access to MySQL ??

MyODBC works fine, but what to do if you have hundreds of tables?=20 its painful job, maybe theres some easier way to do that ? regards, terry sql - Before posting, please check: http://www.mysql.com/manual.php (the

RE: How to port MS Access to MySQL ??

MySQLFront will create the tables and pump the data with one button press Alan -Original Message- From: Terry [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 November 2002 22:02 To: [EMAIL PROTECTED] Subject: RE: How to port MS Access to MySQL ?? MyODBC works fine, but what to

Re: update tablename

- Original Message - From: [EMAIL PROTECTED] To: Rodrigo San Martin [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 3:33 AM Subject: Re: update tablename Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you

Reference Integrity - MySQL 4

Hi, Any idea when MySQL will support thi feature? Any idea when MySQL 4 will be available? Thanks a lot. Hernán Seivane TacticaSoft Transformando sus Datos en Activos [EMAIL PROTECTED] http://www.tacticasoft.com 54-11-5238-0014 54-11-5238-0015

slow queries

mysql,query Hi List I have a couple of slow queries listed in my slow log, but I don't know what to do from here to make them fast. Here is an EXPLAIN table: mysql explain w3t_Users; ++--+--+-+-++ | Field | Type

Re: Reference Integrity - MySQL 4

4.0 can be downloaded now and supports RI -- if your tables are InnoDB tables, and you create indexes on the fk columns. The online mysql manual has a lot of information on how to setup InnoDB tables -- chapter 7. Greg. - Original Message - From: Hernan Seivane [EMAIL PROTECTED] To:

installed mysql

*This message was transferred with a trial version of CommuniGate(tm) Pro* I have recently loaded mysql on macosx 10.2 It has loaded it in the directroy /library/mysql presently I have my user prompt on the terminal screen. I know that I need the sql prompt in order to be able to issue sql

last_insert_id()

Hi, I am using C# with ODBC.Net to communicate with MySQL. I want to determine the last ID of an auto_increment field in the database. When I manually perform the insert using the MySQL command window I can then follow up with select last_insert_id() and I get the correct value, however, when

wait_timeout doesnt get set

Hi It seems I cannot set wait_timeout variable. I set it up in /etc/my.cnf with this line: set-variable= wait_timeout=15 under [mysqld] section. I tried MySQL 3.23.48 and 3.23.49a (binary, linux i686 distributions, we cannot use newer ones as they have serious problems under heavy load).

Solaris 2.6

Is there any version of MySQL with a binary distribution available that supports InnoDb for Sun OS 5.6? I cannot build one from source because I do not have a compiler installed (cc) on the box. Jim Sobeck [EMAIL PROTECTED] -

Scrolling Databases

Hi, I have created a contact database using Mysql and want to be able to scroll back and forth through the database. Even after I have done a search and found a record, I want to be able to scroll back or forth from that point on. I am using PHP4 to display the results. This may be something easy

RE: Scrolling Databases

select * from table_name limit 1; or limit 2,1; I hope this helps a bit? Simon -Original Message- From: Beauford [mailto:beauford.2003;rogers.com] Sent: 12 November 2002 15:04 To: [EMAIL PROTECTED] Subject: Scrolling Databases Hi, I have created a contact database using Mysql and want

Installation Help

I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation, I started the server with /usr/bin/safe_mysqld and it appears to

select query error

Hi All, I have a table in mysql as Attributes, which has 10 recordsin it. If I run the query as select * from Attributes, it gives me 10 records, but if i run the query as Select Attribute from Attributes it gives me 9 records. But this error does not occur every time. It comes very rarely. I

Re: Installation Help

Scott Pippin [EMAIL PROTECTED] Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm

RE: Newbie Question - Query works in access but not MySQL

How about if you rewrite the statement to: SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = tblInvTransaction.ProductID Where ((Products.PartNumberLike %A-000%) AND (Products.Obsolete-1)) GROUP BY

RE: Installation Help

I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the same error. Since I installed with the RPM didn't it give root permission? -Original Message- From: Scott Pippin [mailto:spippin;mtctrains.com] Sent: Tuesday, November 12,

SunOS 5.6

Hi, I am looking to install MySQL on SunOS 5.6 (SunOS 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-4) can anyone tell me which version will work and which binary to download. Thanks. Matt. - Before posting, please check:

re: access denied

Inbal, Monday, November 11, 2002, 7:10:49 PM, you wrote: IO I am working with mysql, in windows, visual c++. IO I am trying to run this query from c++ program: IO select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY IO '\0' LINES TERMINATED BY '\r' from table_name IO And

RE: Installation Help

Did you set up root as a user inside of MYSQL? Eventhough root has permission it must be set up as a user inside of MySQL. Phil Iovino [EMAIL PROTECTED] 11/12/02 09:13AM I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the same error.

re: RE: query crushes server

Eugene, Monday, November 11, 2002, 9:40:20 PM, you wrote: EB mysqld-nt.exe has genrated errors and will be closed by Windows. EB You will need to restart the program. EB An error log is being created. EB select distinct a.* from gnrlasoc a, tasks b where a.row_key_1 = b.prim_key; EB The number

Re: how do i savely delete replication bin-logs ?

(This is a repost of an ealier answer): Here's one which takes log rotation a step further than mysql provides for. It is run on the slaves to keep track of their position and then run on the master to purge up to the earliest slave position. This is useful because you can't reliably get all

Granting rights to more hosts, etc

Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; It tells me that there is an error in this command. How can I use a wildcard in this command? Can I

RE: How stable is MySQL 4.x vs 3.23.x?

I have been using the MySql 4.x MAX with absolutely NO problems. It's being used on heavily operated servers, and I upgraded to 4.x for it's incredible index speeds and it's VERY reliable to me. In fact, in our local benchmarks it's kicking the living crap out of Oracle on sql, query. :) ~Kelly

RE: mysql_install_db hangs

Make sure some previous version of MySql isn't running. I have seen this on systems which had the OS installed version of MySql, and I had to issue shell /sbin/service mysql stop shell cd /usr/local/mysqlversion shell ./bin/mysqld_safe -user=theuserid Hope this helps... ~Kelly W. Black

RE: Solaris 2.6

You don't have a compiler installed? Hmmm. This seems tough to believe. Try issuing 'which cc' ~K Black -Original Message- From: leaddog1 [mailto:jsobeck;lead-dog.net] Sent: Tuesday, November 12, 2002 6:44 AM To: [EMAIL PROTECTED] Subject: Solaris 2.6 Is there any version of MySQL

RE: slow queries

Make sure when you are creating the database that U_Number | int(9) unsigned | | PRI | NULL is U_Number | numeric() | | PRI | NULL -Original Message- From: Petre Agenbag [mailto:internet;boesmanland.com] Sent: Tuesday, November 12, 2002 4:27 AM To:

RE: unable to start mysql

Don't re-install.. Fix the problem Try issuing shellcd /usr/local/mysqlversion shell./configure ~K Black -Original Message- From: mod_perl [mailto:shine_perl;spectrum.net.in] Sent: Monday, November 11, 2002 10:23 PM To: [EMAIL PROTECTED] Subject: unable to start mysql hi all, when i

RE: How to port MS Access to MySQL ??

I used MyAccess and it worked very well. One thing I didn't like was that in any table/field name that contained a space, the space was converted to an underscore. I would've rathered it just removed the space so I wrote some VBA to remove all the spaces from field and table names then let

RE: Installation Help

Make sure you issued the correct GRANT statements at the sql, query. mysqluse mysql; Database Changed mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword'; #note that will give FULL access...see the docs to restrict this. mysql FLUSH PRIVILEGES; 0 Rows Affected. ~Kelly W.

RE: Problem compiling mysqlgui 1.7.5

See the file INSTALL_BINARY ~KB -Original Message- From: Pierre [mailto:pierre;epinetworx.com] Sent: Tuesday, November 12, 2002 1:45 AM To: [EMAIL PROTECTED] Subject: Problem compiling mysqlgui 1.7.5 Hi, I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2 but with

Insert many records

Hi, How can I insert many records (for instance: 1.000.000) without to do this by application? Are there a loop sintax like PL/SQL? Regards sql, query - Before posting, please check: http://www.mysql.com/manual.php

Re: why is this slow?

Hi. On Tue 2002-11-12 at 10:24:34 +0800, [EMAIL PROTECTED] wrote: At 04:47 PM 11/11/2002 +0800, Thomas Seifert wrote: Are you using MySQL-3.23.x? AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does). Maybe thats the cause? Yes. Im using 3.23.52(nt). I just upgraded it from 3.23.27.

RE: Newbie Question - Query works in access but not MySQL

That did it. Thank you very much. - Ed Mark Armer [EMAIL PROTECTED] 11/12/02 9:12:15 AM How about if you rewrite the statement to: SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID =

Column aliasing

I would like to add a column in one of my tables that is an exact copy of (or alias) for another column, except that it has a different name. Why? I'm joining two tables that were previously separate and I want to use 1 main idexing column (e.g. the same numbering scheme). However a whole

Re: Insert many records

You could pu tmany records in a file and use mysql -u user -p infile.sql to load in al the records in the file. Or try http://www.mysql.com/doc/en/LOAD_DATA.html -Corey Tisdale The Grill Store More --- Alexander Burbello [EMAIL PROTECTED] wrote: Hi, How can I insert many records (for

Problem in using MySQLGUI 1.7.5-2

Hi, I'm Edison Xavier. I have installed the MySQL 3.23.52 on an RedHat 8.0. In the local client (running on the same machine as the server) I can connect using any registered user like this: mysql -u xavier -p This connection occours perfectly. I have installed the MySQLGUI 1.7.5-2 on my

yo

Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. - Before posting, please check:

yo

Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. Pd. la versión que instalé es par windows.

Waiting on cond?

I was wondering if someone could tell me what Waiting on cond meant in a process state. We have a build system that is continuously running our unit test suite over new checkins. Earlier today I got an alert that steps were beginning to timeout. I looked into it and in each case it (the build

limited queries to one returned row

Hi all, is it possible to limit a result so that only the first record in a query can be returned for a specific user? I want to do this so that someone who does not have intimate knowledge of a large (10 records) table cannot issue commands to grab *all* of the data. Thanks ahead of time

Re: yo

Hi, Maybe on IRC(UNDERNET) is possible to have chance to find MySQL tutorials in spanish. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -

RES: Insert many records

Try to use AccessDump. It generate multiples INSERT, one for each row. It´s so good. http://www.intranet2internet.com/public/default.asp Lucky Jacob -Mensagem original- De: Alexander Burbello [mailto:burbello;pop.com.br] Enviada em: terça-feira, 12 de novembro de 2002 16:29 Para:

Why does safe_mysqld runs as root?

Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: [mysqld] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock [mysql_server] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock Any thoughts are welcome. Thanks

Re: Why does safe_mysqld runs as root?

On Tue, Nov 12, 2002 at 12:06:36PM -0800, David Kramer wrote: Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: Because you start it as root, maybe? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,

RE: yo

Hola Roberto, Si tu vas a http://www.free-translator.com/ y le ponse http://www.mysql.com/documentation/mysql/full/ en Systran, traducira la documentacion de MySQL a la lengua que seleciones. Entonces asi lo puedes grabar en to computadora y ya vas a tener por donde empezar. Se va a demorar un

mysqldump performance

Hi, all sql, query. Does anyone of you know the performance of mysqldump to backup tables? Thank you, Jing _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail

Windows cnf file location

Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: Why does safe_mysqld runs as root?

Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Thanks, DK -Original Message- From: Jeremy Zawodny

Re: Windows cnf file location

Hi! On Tue, 12 Nov 2002, John Chang wrote: Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. For example, in c:\winnt\my.ini or in c:\my.cnf You can specify a custom config file location to mysqld with the

How to link tables in MySQL

1 - any way to search archives of MySQL list? 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... Thanks for any help

Re: Newbie to the list ...no [MYSQL] in the subject sql query not problem.???

- Original Message - From: [EMAIL PROTECTED] To: working4aliving [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 12:29 PM Subject: Re: Newbie to the list ...no [MYSQL] in the subject??? Your message cannot be posted because it appears to be either spam or simply off topic to our

Impossible SQL ???

I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer Autonumber Field1 Integer Unique Field2 Integer not

Re: Granting rights to more hosts, etc

Octavian Rasnita wrote: Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; grant all on database.* to 'user'@'%' identified by 'password'; It

Re: Insert many records

I know I can do it by application. But I would like to know if are there other way to do the same. sql, query [EMAIL PROTECTED] escreve: In a message dated 12/11/2002 18:46:08 GMT Standard Time, [EMAIL PROTECTED] writes: Hi, How can I insert many records (for instance: 1.000.000)

password MYSQL

I just changed the root password for MYSQL from the default and now it gives me the error Access is denied when I try to connect using phpMyadmin. It doesn't even ask for a password. How can I login in? Thank you. - Before

Re: Windows cnf file location

Hi, John, my.cnf is used as config file on windows. By default it is at, e.g. c:\winnt your boot system directory. It's not a log file. From: John Chang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Windows cnf file location Date: Tue, 12 Nov 2002 15:27:05 -0500 Where is the config file

Re: Windows cnf file location

Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. Under Linux, MySQL server executables and eight MySQL utulities read options from /etc/my.cnf, and under Windows they read from c:\windows\my.ini and c:\my.cnf, in that

Re: How to link tables in MySQL

On 11/12/02 12:41 PM, tmb [EMAIL PROTECTED] wrote: 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... You join

Re: How to link tables in MySQL

You can still use Access to build your queries then click the SQL button and you'll have the the code for the command line. Access SQL is a little different but you should still be able to get an idea on how to do it. - Ed tmb [EMAIL PROTECTED] 11/12/02 12:41:49 PM 1 - any way to search

Re: Why does safe_mysqld runs as root?

David Kramer wrote: Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Where is mysql being started from? Are you familiar

Re: mysqldump performance

Jannie Qu wrote: Does anyone of you know the performance of mysqldump to backup tables? Depends on locking, of course, but pretty similar to select * on * ... (if such were possible). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock

Re: password MYSQL

Hi! First, try connecting from the command-line mysql client. mysql -u root -p -h ser.ver.ip.addr Then enter your password (if you don't have a root password you can dismiss -p) Also, if that works, try resetting cookies from your browser, as phpMyAdmin relies on cookie authentication. Iikka

RE: last_insert_id()

The .Neta Adapter.. does it make a persistent connection? If the connection drops between the first insert and the call to select, then the return would be zero Alan -Original Message- From: Cain O'Sullivan [mailto:cos;iinet.net.au] Sent: Wednesday, 13 November 2002 16:13 To: [EMAIL

Re: Impossible SQL ???

On 11/12/02 12:43 PM, Charlie [EMAIL PROTECTED] wrote: I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure: Field0 Integer

RE: How to link tables in MySQL

AFAIK, MySQL doesn't have any sort of referential integrity checks with fields. conceptually, you can do it, and write your program to force it, but the database itself doesn't have it. John Meyer P.S. shouldn't it be table1.fieldA -Original Message- From: R. Hannes Niedner

Re: last_insert_id()

This looks like the same problem I have with MS Access. It seems MS Access uses the SELECT id FROM table_name WHERE is IS NULL, and this syntax clears the last insert ID field. My solution is here: --- One Line URL, might wrap ---

RE: How to link tables in MySQL

FROM table1 t1 LEFT JOIN table2 t2 ON t1.field=t2.field -Original Message- From: John Meyer [mailto:johnmeyer_1978;yahoo.com] Sent: Wednesday, November 13, 2002 8:14 AM To: MySQL Mailinglist Subject: RE: How to link tables in MySQL AFAIK, MySQL doesn't have any sort of referential

delayed inserts and messages in the host.err log

This is just a should I be concerned question. I am getting a few messages in the mysql error log about delayed inserts and the database not being able to obtain a lock. The database is averaging about 250 queries per second. We are using delayed inserts for most every insert and the data

Re: delayed inserts and messages in the host.err log

On Tue, Nov 12, 2002 at 02:18:44PM -0800, [EMAIL PROTECTED] wrote: This is just a should I be concerned question. I am getting a few messages in the mysql error log about delayed inserts and the database not being able to obtain a lock. The database is averaging about 250 queries per

Re: Windows cnf file location

Is there a good or bad reason to create the config file in the MySQL folder? On production servers which logs do you turn on? Typically what things do you set on in the config file on a production server? Thank you. At 10:37 PM 11/12/2002 +0200, you wrote: Hi! On Tue, 12 Nov 2002, John Chang

Re: Windows cnf file location

At 20:51 + 11/12/02, Jannie Qu wrote: Hi, John, my.cnf is used as config file on windows. By default it is at, e.g. c:\winnt your boot system directory. Not quite. In the Windows system directory, the filename is my.ini. In C:\, the filename is my.cnf. In the MySQL data directory, the

RE: Why does safe_mysqld runs as root?

By boot sequence Im guessing you mean my different run levels? rcX.d? Im guessing that I need to set the user value within the start-up script it self rather than my.cnf??? I thought my.cnf was the config file that the start-up scripts reference, by me setting a the attribute user=mysql under

RE: delayed inserts and messages in the host.err log

Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space, If it persists, use vmstat 1 ~Kelly W Black -Original Message- From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com] Sent:

Re: Impossible SQL ???

Hi. On Tue 2002-11-12 at 13:43:09 -0700, [EMAIL PROTECTED] wrote: I can't seem to come up with a solution to the following SQL query, and have a project dependent on a solution. I'd rather not load the whole database and then parse it in the code. With the following Database structure:

RE: Why does safe_mysqld runs as root?

At 12:36 -0800 11/12/02, David Kramer wrote: Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your In *your* my.cnf file? Which file is that? /etc/my.cnf or something else? You may be placing the

Re: Why does safe_mysqld runs as root?

David Kramer wrote: By boot sequence Im guessing you mean my different run levels? rcX.d? Im guessing that I need to set the user value within the start-up script it self rather than my.cnf??? I thought my.cnf was the config file that the start-up scripts reference, by me setting a the

Re: How to link tables in MySQL

John Meyer wrote: AFAIK, MySQL doesn't have any sort of referential integrity checks with fields. conceptually, you can do it, and write your program to force it, but the database itself doesn't have it. Or you can use REFERENCES with InnoDB tables; http://www.mysql.com/doc/en ... search

Re: Impossible SQL ???

Thanks for the reply, but it isn't quite what is needed. The problem is that I need all the records between the two occurances of identical values in field 2, with no records which occur before or after those two occurances. For example, the following table with 3 fields: 11 10 2

RE: Why does safe_mysqld runs as root?

Get on out there with your bad self Michael !! :) ~KB -Original Message- From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net] Sent: Tuesday, November 12, 2002 3:23 PM To: David Kramer Cc: '[EMAIL PROTECTED]' Subject: Re: Why does safe_mysqld runs as root? David Kramer wrote: By

Re: Why does safe_mysqld runs as root?

Black, Kelly W [PCS] wrote: Get on out there with your bad self Michael !! Oh yeah :-) Long day, mind you, http://www.tuxedo.org/~esr/faqs/smart-questions.html came to mind, but I refrained myself (the first time). SQL ... QUERY ... KEYWORD ... STUPID ... SPAM ... SYSTEM ... SUICIDE ...

Re: Impossible SQL ???

Hello. What you wrote does not obviously fit to your previous description. On Tue 2002-11-12 at 16:25:40 -0700, [EMAIL PROTECTED] wrote: The problem is that I need all the records between the two occurances of identical values in field 2, with no records which occur before or after those

Re: Where can I get innodb monitoring tools?

At 18:11 +0900 11/12/02, Chung Ha-nyung wrote: innodb manual (http://www.innodb.com/ibman.html) mentions about innodb monitoring tools, e.g. innodb_tablespace_monitor. But they don't seem to be included in mysql 4.0.4. Should I buy them or can get somewhere else, like innodb homepage? Section

Re: Granting rights to more hosts, etc

At 17:46 +0200 11/12/02, Octavian Rasnita wrote: Hi all, I've seen the following command line in a MySQL book, but it doesn't work on my computer running MySQL 3.2 on Windows 2000: grant all on database.* to user@% identified by 'password'; It tells me that there is an error in this command.

Re: Impossible SQL ???

Hello, It seems to me that there is a fundamental reason why this can not be accomplished with a single SQL query. The process requires that the search algorithm maintains state between rows. i.e. the decision to keep or discard rows from the table as the algorithm descends down the table is not

RE: Installation Help

At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote: Make sure you issued the correct GRANT statements at the sql, query. mysqluse mysql; Database Changed mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword'; That's not quite right. - GRANT * is not legal, I suspect you

Count Rows in two tables

Hello all, Does anybody have a SQL string to count the rows in two different tables and give you a total number of rows? I have been trying to find an answer for a couple of days and seems like a simple string. Thank you Rick

RE: Count Rows in two tables

You can't count the join? Alan -Original Message- From: Rick Baranowski [mailto:rickb;baranconsulting.com] Sent: Wednesday, 13 November 2002 12:10 To: [EMAIL PROTECTED] Subject: Count Rows in two tables Hello all, Does anybody have a SQL string to count the rows in two

Re: Count Rows in two tables

On 11/12/02 5:36 PM, Alan McDonald [EMAIL PROTECTED] wrote: You can't count the join? Alan Hello all, Does anybody have a SQL string to count the rows in two different tables and give you a total number of rows? I have been trying to find an answer for a couple of days and seems like

Re: Count Rows in two tables

Does it have to be in a single query. You could use a Union query and then total the results in your program. Select Count(Field1) From Table1 Union Select Count(Field1) From Table2; Rick Baranowski [EMAIL PROTECTED] 11/12/02 5:10:14 PM Hello all, Does anybody have a SQL string to count

Re: Count Rows in two tables

Alan McDonald wrote: You can't count the join? Alan if you count the (unqualified) join you'll end up with the product of the two table counts. Murad -Original Message- From: Rick Baranowski [mailto:rickb;baranconsulting.com] Sent: Wednesday, 13 November 2002 12:10 To:

  1   2   >