MYSQL ERROR-NO.0
Dear mysql, I just got one simple table. The PHP-Script ist ok (tested on another server), but trying to get data over my server, nothing comes back. So, I put up the lines: .mysql_errno(). - .mysql_error(). It gives back: 0 - What does it mean? Is there maybe NO connection to MySql? Sorry for asking, I haven't found any Error-numbers in the Error-Log at your page. Greetings from Switzerland Christian
mod_auth_mysql
I hope that someone can help with this. I am trying to install mod_auth_mysql as a DSO, but I get errors. Here are the errors when compiling mod_auth_mysql: /usr/local/src/mod_auth_mysql-2.20# cp config.h auth_mysql_config.h /usr/local/src/mod_auth_mysql-2.20# /usr/sbin/apxs -i -a -I/usr/include/mysql -L/usr/lib/mysql \ ? -lmysqlclient -c mod_auth_mysql.c gcc -DLINUX=2 -DMOD_SSL=207101 -DEAPI -DUSE_EXPAT -I../lib/expat-lite -fpic -DSHARED_MODULE -I/usr/include/apache -I/usr/include/mysql -c mod_auth_mysql.c mod_auth_mysql.c: In function `my_set_string_slot': mod_auth_mysql.c:203: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c: In function `safe_mysql_query': mod_auth_mysql.c:405: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c:417: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c:419: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c: In function `mysql_check_group': mod_auth_mysql.c:526: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c: In function `mysql_check_auth': mod_auth_mysql.c:589: warning: initialization makes pointer from integer without a cast mod_auth_mysql.c:613: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c:619: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c:631: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c:633: warning: assignment makes pointer from integer without a cast mod_auth_mysql.c:635: warning: assignment makes pointer from integer without a cast gcc -shared -o mod_auth_mysql.so mod_auth_mysql.o -L/usr/lib/mysql -lmysqlclient cp mod_auth_mysql.so /usr/lib/apache/mod_auth_mysql.so chmod 755 /usr/lib/apache/mod_auth_mysql.so [activating module `auth_mysql' in /etc/httpd/conf/httpd.conf] Here are the errors I get when trying to restart Apache: Cannot load /usr/lib/apache/mod_auth_mysql.so into server: /usr/lib/apache/mod_auth_mysql.so: undefined symbol: register_cleanup Thank You Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help! Error building 4.0.2 under RH Linux 7.2
The Dev. Tree Source MySQL 4.0 no longer builds on this machine, giving lots of errors. Had been able to build from the same source w/o any problems up until a few days ago, when I 'bk resync'ed the source. Any ideas? Thanks for your help! -- A snapshot of build transcript. Invoked by ./BUILD/compile-pentium. -- [sql]# make Making all in share make[1]: Entering directory `/root/mysql-4.0/sql/share' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/root/mysql-4.0/sql/share' make[1]: Entering directory `/root/mysql-4.0/sql' gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex -I. -I../include -I. -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc cc1plus: warning: Ignoring command line option '-Wimplicit-function-dec' cc1plus: warning: Ignoring command line option '-Wimplicit-int' mysqld.cc: In function `void *handle_connections_sockets (void *)': mysqld.cc:2425: warning: `my_socket new_sock' might be used uninitialized in this function mysqld.cc: At top level: mysqld.cc:3045: `disconnect_slave_event_count' was not declared in this scope mysqld.cc:3046: `disconnect_slave_event_count' was not declared in this scope mysqld.cc:3050: `abort_slave_event_count' was not declared in this scope mysqld.cc:3050: `abort_slave_event_count' was not declared in this scope mysqld.cc:3053: `max_binlog_dump_events' was not declared in this scope mysqld.cc:3053: `max_binlog_dump_events' was not declared in this scope mysqld.cc:3056: `opt_sporadic_binlog_dump_fail' was not declared in this scope mysqld.cc:3057: `opt_sporadic_binlog_dump_fail' was not declared in this scope mysqld.cc:3299: `OPT_INNODB_MIRRORED_LOG_GROUPS' was not declared in this scope mysqld.cc:3304: `OPT_INNODB_LOG_FILES_IN_GROUP' was not declared in this scope mysqld.cc:3308: `OPT_INNODB_LOG_FILE_SIZE' was not declared in this scope mysqld.cc:3312: `OPT_INNODB_LOG_BUFFER_SIZE' was not declared in this scope mysqld.cc:3316: `OPT_INNODB_BUFFER_POOL_SIZE' was not declared in this scope mysqld.cc:3320: `OPT_INNODB_ADDITIONAL_MEM_POOL_SIZE' was not declared in this scope mysqld.cc:3325: `OPT_INNODB_FILE_IO_THREADS' was not declared in this scope mysqld.cc:3329: `OPT_INNODB_LOCK_WAIT_TIMEOUT' was not declared in this scope mysqld.cc:: `OPT_INNODB_THREAD_CONCURRENCY' was not declared in this scope mysqld.cc:3337: `OPT_INNODB_FORCE_RECOVERY' was not declared in this scope make[1]: *** [mysqld.o] Error 1 make[1]: Leaving directory `/root/mysql-4.0/sql' make: *** [all-recursive] Error 1 -- ./configure output: -- loading cache ./config.cache checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking build system type... i686-pc-linux-gnu checking for a BSD compatible install... (cached) /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... found checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) gawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) gcc checking whether the C++ compiler (gcc ) works... yes checking whether the C++ compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C++... (cached) yes checking whether gcc accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking C Compiler version... gcc 2.96 checking C++ compiler version... gcc 2.96 checking for ranlib... (cached) ranlib checking for ld used by GCC... (cached) /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... (cached) yes
RE: error granting rights
[snip] mysql GRANT ALL - ON dbname.* - TO username@localhost - IDENTIFIED BY 'password'; [/snip] A. Do you have GRANT capability as the user that you are logged on as? 2. Is dbname.* right? Shouldn't it be just dbname? III. Is user set up as username@localhost? Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL GROUP BY Anomaly?
Perhaps the time component of the date is different, hence you are getting back what looks like duplicate rows but they're not really? - Max Martin Anderson QA Engineer ProfitLogic Eleven Cambridge Center Cambridge, MA 02142 t: 617.218.1946 -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 12:01 PM To: [EMAIL PROTECTED] Subject: MySQL GROUP BY Anomaly? I have 2 tables with RecordDate in them, one has millions of records, one has hundreds of records. If I perform the following query on the table with hundreds; mysql select RecordDate - from tblInfo - WHERE RecordDate BETWEEN '2002-03-04' AND '2002-03-06' - GROUP BY RecordDate; I get three rows back in the result; ++ | RecordDate | ++ | 2002-03-04 | | 2002-03-05 | | 2002-03-06 | ++ but if I run this query against the table with millions of records I get (a small snippet of the results) | 2002-03-06 | | 2002-03-05 | | 2002-03-06 | | 2002-03-05 | | 2002-03-06 | | 2002-03-05 | | 2002-03-06 | | 2002-03-05 | | 2002-03-04 | ++ 34164 rows in set (17.78 sec) Can anyone enlighten me as to what is happening? Both tables are on the same machine, but the one with millions of records is a MERGE table. If I run the query against the individual tables in the merge, they return the proper (3 row) result. Thanks! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: User Variables
At 12:19 -0400 5/9/02, Luc Foisy wrote: hmm. ok i see what you are getting at but you do that every time you use a where clause, do you not? No, not really SELECT value FROM table WHERE value = 5 In this case value is used in the WHERE clause to determine which records to select. Once selected, value can be listed in the column output list. SELECT IF( value 0, value2, value3 ) AS 'value4' FROM table WHERE value4 = 5 In this case, the query is illegal. Aliases cannot be used in WHERE clauses. (You didn't actually try this query, right?) This is the same kind of problem that I *think* you're having with SQL variables: Trying to select a value at the same time that you use it to determine which values to select. Maybe it would help to see this same problem in another context. This is from the Cookbook; it illustrates the same phenomenon of trying to use a value two ways at once: MIN() and MAX() find the endpoints of a range of values, but sometimes when find a minimum or maximum value, you're also interested in other values from the row in which the value occurs. For example, you can find the largest state population like this: mysql SELECT MAX(pop) FROM states; +--+ | MAX(pop) | +--+ | 29760021 | +--+ But that doesn't show you which state has this population. The obvious way to try to get that information is like this: mysql SELECT name, MAX(pop) FROM states WHERE pop = MAX(pop); ERROR at line 1: Invalid use of group function Probably everyone attempts something like that sooner or later, but it doesn't work, because aggregate functions like MIN() and MAX() cannot be used in WHERE clauses. The intent of the statement is to determine which record has the maximum population value, then display the associated state name. The problem is that while you and I know perfectly well what we'd mean by writing such a thing, it makes no sense at all to MySQL. The query fails because MySQL uses the WHERE clause to determine which records to select, but it knows the value of an aggregate function only after selecting the records from which the function's value is determined! So, in a sense, the statement is self-contradictory. In the conditional join, the variable select does not require any information from the joined table, so I wouldn't think it would matter [the above is just because I like to argue and i think too much :)] The single select statement issues no error, and it does retrieve a value (just a little too late), it must be how the select statement is followed through (as in order of operations) Are all joins completed first? (hmm, that would make sense wouldn't it) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL EV56 binary?
Hi, I've an AlphaServer 1200 with dual EV56 533MHz processors and I'm looking for a precompiled MySQL binary (any of the four release trees, I don't mind which). In running the benchmark tests distributed with MySQL on the source distribution of 3.23 I found the results were worse than that of a dual intel 500MHz machine with 2GB less memory. If a person on this list has had success in compiling an efficient binary on this architecture please drop me a note. I have followed the instructions on the manual page for Linux Alpha Notes (http://www.mysql.com/doc/L/i/Linux-Alpha.html), using Compaq's compilers, but as those instructions are optimized for the EV6 I am left thinking there are better/different optimizations for the EV56. Thanks in advance! Ron Jamison - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: User Variables
At 11:57 -0400 5/9/02, Luc Foisy wrote: It may not make any sense to you, but it makes perfect sense to me Okay. Then it would seem that either: - I understand what you want to do, in which case you can't do it, because you're using SQL variables in a self-contradictory way. - I don't understand what you want to do, which is perfectly possible, since even the broken up queries below are pretty impenetrably formatted. Maybe it would look better to you if written as so: SELECT @AddressJoinID := IF (CUSTOMER.ID_ADDRESS_BILLTO 0, CUSTOMER.ID_ADDRESS_BILLTO, CUSTOMER.ID_ADDRESS) AS 'Junk' FROM INVOICEHEADER LEFT JOIN CUSTOMER ON INVOICEHEADER.ID_CUSTOMER = CUSTOMER.ID WHERE INVOICEHEADER.ID = [param:Invoice ID] SELECT INVOICEHEADER.ID AS 'ID_INVOICEHEADER', DATE_FORMAT(INVOICEHEADER.Date,'%Y/%m/%d') AS 'Invoice_Date', INVOICEHEADER.ID_CUSTOMER AS 'ID_CUSTOMER', INVOICEHEADER.SubTotal, INVOICEHEADER.Tax1Total AS 'Tax1Total', INVOICEHEADER.GrandTotal AS 'GrandTotal', CUSTOMER.Company AS 'Cust_Company', CUSTOMER.*, COMPANY.*, TRIM(CONCAT(IF(ADDRESS.UnitNumber IS NULL,'',ADDRESS.UnitNumber),' ',ADDRESS.CivicNumber,' ',STREET.Name,' ',IF(STREETTYPE.Abv IS NULL,'',STREETTYPE.Abv))) AS 'Address_1', ADDRESS.Line2 AS 'Address_2', CONCAT(CITY.Name,', ',PROVINCE.Name) AS 'Address_3', ADDRESS.PostalCode AS 'Cust_PostalCode' FROM INVOICEHEADER LEFT JOIN CUSTOMER ON INVOICEHEADER.ID_CUSTOMER = CUSTOMER.ID LEFT JOIN ADDRESS ON ADDRESS.ID = @AddressJoinID LEFT JOIN STREET ON ADDRESS.ID_STREET = STREET.ID LEFT JOIN STREETTYPE ON ADDRESS.ID_STREETTYPE = STREETTYPE.ID LEFT JOIN CITY ON ADDRESS.ID_CITY = CITY.ID LEFT JOIN PROVINCE ON ADDRESS.ID_PROVINCE = PROVINCE.ID LEFT JOIN COUNTRY ON ADDRESS.ID_COUNTRY = COUNTRY.ID LEFT JOIN COMPANY ON CUSTOMER.ID_COMPANY = COMPANY.ID WHERE INVOICEHEADER.ID = [param:Invoice ID] Can't use an IF() on the join, but we want to join conditionally (customer has two address fields, if one is blank, then use the other one) ( the query does not print out anything directly, values are grabbed from the result set and formatted into a printable form ) Since all the joins in the first query exist in the second query, I should be able to create and use the same variable in the second query ( or the documentation needs to be revamped stating that you can't use variables in the same select statement at all) You *can* use them in the same statement, but as the manual states, if you access a variable that is set in the same statement, the value you access for one row is the value that was assigned from the previous row. And this does not seem to fit what you're trying to accomplish. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL GROUP BY Anomaly?
[snip] Perhaps the time component of the date is different, hence you are getting back what looks like duplicate rows but they're not really? [/snip] The time components are all the same. And if I say this in my query; WHERE RecordDate = '2002-03-04' , it works (returns one row of data) or if I do; WHERE RecordDate '2002-03-04' , it works I am stumped. Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't execute any of the binaries
Description: i installed the binaries of mysql 3.23.49 (tried both tar.gz and rpm) but cannot execute any (neither the deamon mysqld nor the monitor mysql). i can execute scripts but they will fail as they are calling mysqld How-To-Repeat: execute mysqld on my particular machine ;-) Fix: none known. Submitter-Id: ? Originator:jan korger Organization: none MySQL support: none Synopsis: can't execute binaries Severity: critical Priority: Category: mysql Class: sw-bug Release: mysql-3.23.49 (Official MySQL Binary) Environment: System: Linux jan.korger 2.2.12-33 #7 Thu Jun 14 21:50:53 CEST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Sep 10 2000 /lib/libc.so.6 - libc-2.1.2.so -rwxr-xr-x 1 root root 4118299 Sep 20 1999 /lib/libc-2.1.2.so -rw-r--r-- 1 root root 20020054 Sep 20 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 20 1999 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL ERROR-NO.0
On Thursday, 9. May 2002 18:43, Soilant ! wrote: Dear mysql, I just got one simple table. The PHP-Script ist ok (tested on another server), but trying to get data over my server, nothing comes back. So, I put up the lines: .mysql_errno(). - .mysql_error(). It gives back: 0 - Hello Webmaster, Errorcode 0 means that there is no error. Please refer to your PHP-Documentation: http://www.php.net/mysql_errno: or read the description for mysql_errno Api-function in the MySql-Manual. Btw: As a webmaster you also should know, which chars you shouldn't use in Mailaddr Names. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: link problem
adelpfe writes: hi every body i have succeed to compile source examples given with mysql++1.7.9. but i can't link them. i used gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lm -tz -all rigth but , i didn't succeed to link can you help me HI! First of all, you should use g++. Second, you should link in sqlplus too ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: link problem
gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lm -tz - Replace the -c option with -o Hisseine - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 1:43 PM Subject: Re: link problem adelpfe writes: hi every body i have succeed to compile source examples given with mysql++1.7.9. but i can't link them. i used gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lm -tz -all rigth but , i didn't succeed to link can you help me HI! First of all, you should use g++. Second, you should link in sqlplus too ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL GROUP BY Anomaly?
I don't want to doubt you :-) but can you show us a select including the time component? I don't know how date comparison works in MySQL but here is a test I ran in Oracle. I inserted some dates into a table using sysdate which include time information and inserted more records using to_date('2002-05-09', 'dd-mon-') which does not include time information. These records are shown below. Now if you run the two queries you mentioned you also get records back because date comparison that does noy explicitly include a time assumes 12:00:00. I am thinking that if you lool at your date fields closer you will find that some have different timestamps. I could be wrong but it's certainly a quick and easy comfirmation for you to try. 1* select to_char(martin, 'dd-mon- hh:mi:ss') from martin SQL / TO_CHAR(MARTIN,'DD-M 09-may-2002 02:28:14 09-may-2002 02:28:19 09-may-2002 02:28:20 09-may-2002 02:28:20 09-may-2002 02:28:21 09-may-2002 12:00:00 09-may-2002 12:00:00 09-may-2002 12:00:00 09-may-2002 12:00:00 09-may-2002 12:00:00 10 rows selected. SQL select * from martin where martin = '2002-05-09'; MARTIN -- 2002-05-09 2002-05-09 2002-05-09 2002-05-09 2002-05-09 SQL select * from martin where martin '2002-05-09'; MARTIN -- 2002-05-09 2002-05-09 2002-05-09 2002-05-09 2002-05-09 Martin Anderson QA Engineer ProfitLogic Eleven Cambridge Center Cambridge, MA 02142 t: 617.218.1946 -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:23 PM To: [EMAIL PROTECTED] Subject: RE: MySQL GROUP BY Anomaly? [snip] Perhaps the time component of the date is different, hence you are getting back what looks like duplicate rows but they're not really? [/snip] The time components are all the same. And if I say this in my query; WHERE RecordDate = '2002-03-04' , it works (returns one row of data) or if I do; WHERE RecordDate '2002-03-04' , it works I am stumped. Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL GROUP BY Anomaly? SOLVED
[snip] I have 2 tables with RecordDate in them, one has millions of records, one has hundreds of records. If I perform the following query on the table with hundreds; mysql select RecordDate - from tblInfo - WHERE RecordDate BETWEEN '2002-03-04' AND '2002-03-06' - GROUP BY RecordDate; Both tables are on the same machine, but the one with millions of records is a MERGE table. [snip] Had a look at the table description (DESCRIBE tablename;) for the merge table. There was an INDEX set on the RecordDate column. Since the RecordDate columns in each of the tables comprising the merge already have INDEXes set on them, there is no need for the INDEX to exist in the MERGE definition. Removed the INDEX from the MERGE table definition and all appears to be working well. ! Jay [rant] P.S. Snipping is Good Thing, sound listizen behavior. When replying to a message snip out all of the irrelevant portions to make your post easier to read. We all will appreciate each other more. P.P.S. Information is Good Thing. Describe your problem in as much detail as possible, including things like OS version, MySQL version, and anything else which you may think is relevant to the problem you are experiencing or the question that you have. It will help responders to know more and therefore be able to respond more succinctly to your query. P.P.P.S. Apologies are a Good Thing. I reacted rather snippishly to a couple of posts over the past couple of days due to the lack of information in a post where we, the listizens, were supposed to devine what the problem was in order to suggest a solution. Like a subject line of Please HELP NOW, with a message of, My server is running too slow, what could be the problem?. I am sorry I was sarcastic. See P.P.S. above. P.P.P.S. RTFM [/rant] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: adding a new mysql user with rights to add other users
On Thu, 9 May 2002 [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 message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Greetings: What rights do I need to give a new admin user so I can delegate the creation of new regular users BUT not allow this same admin user the ability to delete user he/she did not create in the first place. In short I want to create several of these super users but not allow them to alter what the other super user might create. Thanks Jim -- - Jim Chivas email: [EMAIL PROTECTED] Information And Computing services fax:(604) 323-5349 Langara College Voice: (604) 323-5390 100 West 49th Avenue http://www.langara.bc.ca Vancouver, B.C., Canada V5Y 2Z6 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: link problem
- Original Message - From: Hisseine Dj. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 2:40 PM Subject: Re: link problem gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lm -tz - Replace the -c option with -o Hisseine - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 1:43 PM Subject: Re: link problem adelpfe writes: hi every body i have succeed to compile source examples given with mysql++1.7.9. but i can't link them. i used gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lm -tz -all rigth but , i didn't succeed to link can you help me HI! First of all, you should use g++. Second, you should link in sqlplus too ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem on Load Data!
Hi Jack, For question1, I think you need to use insert with set: insert into table ABC set column3 = , column4 = , column5 = ; I think that should do it. Have you managed to find an answer to question2? Please let me know. Ali From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: problem on Load Data! Date: Mon, 6 May 2002 12:40:08 +0800 Dear all Two Question : 1. I know that the 'LOAD DATA' command loads a bulk of data into a table, but what happen if i only want to load the data into specifc fields on a table instead of whole table. eg. Let say i had a file with 3 column of data, and i want to load these data into a 'ABC' table's field 3 to 5 and leave field 1 2 as it was! 2. I copied a file into server's root directory, and i was trying to load that file's data to table which i had failed using the following command in MYSQL: LOAD DATA infile 'c:\hkd_rate.csv' into table hkd_deposit1 fields terminated by ',' It said couldn't find the file! but if i put the file into the data directory of mysql, then it can find it! So what should i do if i want mysql will able to find that file from root directory? -- Thx a lot! Jack [EMAIL PROTECTED] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
data scrambles
Using MySql 3.23 Using Perl, I have a table that I feed data into. I then retrieve the data and order it to write to arrays for use further on. All works fine. Data remains in proper order (e.g. head[1] is in the same array position as graf[1], etc. The problem occurs now that I am trying to only retrieve a limited number of days using SELECT * from news_stories WHERE (TO_DAYS(NOW()) - TO_DAYS(date_pub) 6) order by date desc, weight; The data is now not matching up. When outputted, head[1] may be paired with graf[4]. I cannot detect a pattern as to why the correct correlation is no longer taking place. Any help or directions to solution in docs would be appreciated. MySQL, database, etc. -- Greg Peretti web developer www.abqjournal.com (505) 823-3888 - - The web of our life is of a mingled yarn, good and ill together. William Shakespeare, Alls Well That Ends Well. The more I know, the less I understand. Don Henley, The Heart of the Matter. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SOP for hosting services?
Peter This might not be exactly the kind of answer you are looking for(or it might not even be what you are really asking), but you can do Transactions programmatically in Cold Fusion. I doubt Ultradev can do that, so you would probably have to code it yourself. there is a good example in the documentation, which you can get online. go to this link and pick the version of CF you are coding for... http://www.macromedia.com/support/coldfusion/documentation.html then look up cftransaction... hope this helps.. thomas On Mon, 6 May 2002, Peter C. Goswick wrote: Hi, I using Macromedia UltraDev to develop my dynamic web site and would like to use mySQL as the RDBMS. My hosting service folks are telling me that I should only update my database on their server via update transactions. They say this is for security reasons. UltraDev provides many good tools for viewing, adding, updating and deleting records for the database but I'm not sure how to produce add/delete/update transactions from UltraDev and I'm not convinced it is necessary to have the added layer of security. Is this standard operating procedure when making changes to mySQL databases or should I tell them that I want direct access to my database? Any help/suggestions/guidelines in this area would be very helpful. Thanks. Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Thomas Harris Lab Specialist Teaching and Learning Technologies Lab (812) 855-7829 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie help
I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i dont see any? None of the coloums are overunning, all data types seem correct... What else could be going on? could i just ignore the warning? thank you bd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help -- Can't Get Logs Up and Running on Mysql - Win32
MySQL is running as a Service in Windows 2000, as one might expect. Tried to get the logs up and running with a my.cnf file in multiple locations, including C:/ and DATADIR\my.cnf, then restarted service, tried logging in, a few inserts, etc - no luck. Flushed logs using mysqladmin too. Here's my my.cnf contents: [mysqld] log-update log [mysql] log-update log I'm hoping the two listings don't conflict with each other. Thanks. DTS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem on Load Data!
I think you have to use a forward slash in your path instead of a backslash. C:/ as opposed to C:\ even in windows operating environments I believe you need to use /. -Original Message- From: ali hafiz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 2:23 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem on Load Data! Hi Jack, For question1, I think you need to use insert with set: insert into table ABC set column3 = , column4 = , column5 = ; I think that should do it. Have you managed to find an answer to question2? Please let me know. Ali From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: problem on Load Data! Date: Mon, 6 May 2002 12:40:08 +0800 Dear all Two Question : 1. I know that the 'LOAD DATA' command loads a bulk of data into a table, but what happen if i only want to load the data into specifc fields on a table instead of whole table. eg. Let say i had a file with 3 column of data, and i want to load these data into a 'ABC' table's field 3 to 5 and leave field 1 2 as it was! 2. I copied a file into server's root directory, and i was trying to load that file's data to table which i had failed using the following command in MYSQL: LOAD DATA infile 'c:\hkd_rate.csv' into table hkd_deposit1 fields terminated by ',' It said couldn't find the file! but if i put the file into the data directory of mysql, then it can find it! So what should i do if i want mysql will able to find that file from root directory? -- Thx a lot! Jack [EMAIL PROTECTED] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem on Load Data!
Wrong. Windows uses \ for their paths, so MySQL should use the same thing. Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Bob Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:59 PM To: 'ali hafiz'; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: problem on Load Data! I think you have to use a forward slash in your path instead of a backslash. C:/ as opposed to C:\ even in windows operating environments I believe you need to use /. -Original Message- From: ali hafiz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 2:23 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem on Load Data! Hi Jack, For question1, I think you need to use insert with set: insert into table ABC set column3 = , column4 = , column5 = ; I think that should do it. Have you managed to find an answer to question2? Please let me know. Ali From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: problem on Load Data! Date: Mon, 6 May 2002 12:40:08 +0800 Dear all Two Question : 1. I know that the 'LOAD DATA' command loads a bulk of data into a table, but what happen if i only want to load the data into specifc fields on a table instead of whole table. eg. Let say i had a file with 3 column of data, and i want to load these data into a 'ABC' table's field 3 to 5 and leave field 1 2 as it was! 2. I copied a file into server's root directory, and i was trying to load that file's data to table which i had failed using the following command in MYSQL: LOAD DATA infile 'c:\hkd_rate.csv' into table hkd_deposit1 fields terminated by ',' It said couldn't find the file! but if i put the file into the data directory of mysql, then it can find it! So what should i do if i want mysql will able to find that file from root directory? -- Thx a lot! Jack [EMAIL PROTECTED] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie help
bd... Two things here: 1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site. and 2.) You haven't given us the warning / error message you received. -Ryan Hatch [EMAIL PROTECTED] wrote: I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i dont see any? None of the coloums are overunning, all data types seem correct... What else could be going on? could i just ignore the warning? thank you bd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Pretty Simple MAX Value question...
I want to select say 100 of 1,000 records and get the highest value for id in that query, however the MAX command always gives me the MAX for the whole table, not just my query. Here's my expression: SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100 No matter what, I will always get the max for the column for the whole tableadding and removing the LIMIT command changes absolutely nothing... Thanks to anyone that might be able to help me... Frustrated, Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Very very Simple UDF Example...
Here is download for Very Simple UDF example for MySQL 4 and Delphi 6. This is by ni means perfect... mike http://www.tctelco.net./~mmgrover/udf.zip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
muti value question
I'm trying to allow an attribute to hold multiple value. I know you can use varray in oracle but I cant find anything in mysql. I found SET but you must set the possible choices from the beginning. This is not good for what I'm doing because these choices will change. The only other thing that I could think of was to just encode all the choices in string and then decode them when I retrieve them. Any ideas. Thanks Michael Davis Temple University Computer Services Consultant 215-204-3902 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: newbie help
Mysql.org is an IMPOSTER's site. What? They are one in the same. -Original Message- From: Ryan Hatch [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:31 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: newbie help bd... Two things here: 1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site. and 2.) You haven't given us the warning / error message you received. -Ryan Hatch [EMAIL PROTECTED] wrote: I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i dont see any? None of the coloums are overunning, all data types seem correct... What else could be going on? could i just ignore the warning? thank you bd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
To: mysql as a Good Person - Conduct Education in the 21st Century
Dear mysql: You may ask yourself How to make people respect you How to win friends How to let your conduct help your health, work, job, career, relationships, spirit, mind, well-being, ... How to make your life smoother and happier How to do whatever you like without being unpleasant to other people How to develop good conduct in your children or students How to make the world peaceful and better You can find all the answers to these questions, and much more, in this great handbook: Complete Conduct Principles for the 21st Century by Dr. John Newton It is the best educational GIFT idea for children, friends, relatives, classmates, students, parents, teachers, other educators, ..., particularly at this special time. BENEFITS to each individual reader: Many! -- such as for health, work, job, career, self-improvement, education, relationships, spirit, mind, well-being, and much more -- almost all the areas that are important to you in the 21st century. People around you will benefit, too. (Please see the PREFACE of the book for details.) EVERYONE may find this handbook useful and helpful, regardless of age (from children to oldsters), occupation, rank, status, gender, religious beliefs, nationality, country, or region. If you are a parent or a teacher, you can learn how to develop good conduct in your children or students from this handbook. Please advise your children or students to read the book. It will result in great benefits for both you and them. (Note: If you are interested in the issue of School Violence, Youth Problems, Violence Prevention, or Conduct Education in the 21st Century, please see the APPENDIX below.) This book is a must for EVERYONE to be better prepared for personal conduct for the 21st century. The book's content is obvious from its title. The complete useful conduct principles cover not only what we should do, but also what we should not do -- especially those faults people make often and easily. This timely, unique, and very important handbook is designed to suit most people, and is self-contained and user-friendly. This book is significantly different and better than competitive works. Some of its innovative contents may help solve problems that Western culture cannot. The book's merit and importance have been recognized and praised by many experts, elected public officials, and world leaders. How to make the world peaceful and better --- You can find the solution in the book. Let's work together to make the world peaceful and better! The author, John Newton, holds a Ph.D. from MIT, and does researches at Harvard. His long-term research on The personal conduct in the human society of the 21st century resulted in this book. It is published by Nicer Century World Organization, headquartered beside Harvard University and MIT, two leading institutes of new knowledge and literature. The book is available in two types of binding: Hardcover (ISBN 0967370574; case bound, Smyth sewn; with dust jacket) and Paperback (ISBN 0967370582; perfect bound). Both editions are unabridged, and are printed on 60 lb, natural, acid-free, excellent and healthful paper. You can get the book from many fine on-line bookstores and traditional bookstores. For your convenience, I herewith provide you with a link directly to the book page in the shopping directory of Yahoo!, the world's No. 1 Internet directory: http://shopping.yahoo.com/shop?d=bid=3680641clink=dmpr-hm/rpcf=setup Some bookstores there offer great discounts (for a limited time). Note that some of the bookstores may disappear there if out-of-stock. In that case, you may want to go to another bookstore. Of course, you may freely go to other bookstores at any time, even if they are not listed in Yahoo!. Please forward this e-mail to people you know -- children, friends, relatives, classmates, students, parents, teachers, other educators, ..., because they can benefit from it, too. This can be a wonderful kindness you provide to them! mysql, best wishes to you! Sincerely yours, Tom Carter, Ph.D. President, Nicer Century World Organization Massachusetts, USA (Nicer Century World Organization is an educational, non-profit, non-partisan organization; it endeavors to make the 21st century nicer than ever before. To accomplish its mission, Nicer Century World Organization is proud to introduce this book.) --- APPENDIX: School Violence, Youth Problems, Violence Prevention, and Conduct Education in the 21st Century In recent years school violence has made many pieces of nation-shaking highlighted headline news, which have astounded the Americans. It may happen at any school, at any time, and by students of any age. Some experts believe this is the most important national crisis the U.S. is facing. In the 21st century the problem will happen not only
RE: newbie help
What makes you think that it is an imposter site? They both have the same IP address, they are both the same site. # nslookup mysql.org Name:mysql.org Address: 64.28.67.70 # nslookup mysql.com Name:mysql.com Address: 64.28.67.70 -Original Message- From: Ryan Hatch [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:31 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: newbie help bd... Two things here: 1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site. and 2.) You haven't given us the warning / error message you received. -Ryan Hatch [EMAIL PROTECTED] wrote: I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i dont see any? None of the coloums are overunning, all data types seem correct... What else could be going on? could i just ignore the warning? thank you bd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie help
Maybe the poster of the message is an imposter developer too? MS -Original Message- From: Steve Buehler [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, May 09, 2002 3:01 PM Subject: RE: newbie help What makes you think that it is an imposter site? They both have the same IP address, they are both the same site. # nslookup mysql.org Name:mysql.org Address: 64.28.67.70 # nslookup mysql.com Name:mysql.com Address: 64.28.67.70 -Original Message- From: Ryan Hatch [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:31 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: newbie help bd... Two things here: 1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site. and 2.) You haven't given us the warning / error message you received. -Ryan Hatch [EMAIL PROTECTED] wrote: I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i dont see any? None of the coloums are overunning, all data types seem correct... What else could be going on? could i just ignore the warning? thank you bd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help! Error building 4.0.2 under RH Linux 7.2
Just tried building Mysql-3.x.x cloned from the Development Tree on the same machine - works like a charm. Still no luck with 4.0.2 Is there any known issue regarding building 4.0.2 under RedHat7.2? Thanks, Vadim. Vadim P. wrote: The Dev. Tree Source MySQL 4.0 no longer builds on this machine, giving lots of errors. Had been able to build from the same source w/o any problems up until a few days ago, when I 'bk resync'ed the source. Any ideas? Thanks for your help! -- A snapshot of build transcript. Invoked by ./BUILD/compile-pentium. -- [sql]# make Making all in share make[1]: Entering directory `/root/mysql-4.0/sql/share' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/root/mysql-4.0/sql/share' make[1]: Entering directory `/root/mysql-4.0/sql' gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex -I. -I../include -I. -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc cc1plus: warning: Ignoring command line option '-Wimplicit-function-dec' cc1plus: warning: Ignoring command line option '-Wimplicit-int' mysqld.cc: In function `void *handle_connections_sockets (void *)': mysqld.cc:2425: warning: `my_socket new_sock' might be used uninitialized in this function mysqld.cc: At top level: mysqld.cc:3045: `disconnect_slave_event_count' was not declared in this scope mysqld.cc:3046: `disconnect_slave_event_count' was not declared in this scope mysqld.cc:3050: `abort_slave_event_count' was not declared in this scope mysqld.cc:3050: `abort_slave_event_count' was not declared in this scope mysqld.cc:3053: `max_binlog_dump_events' was not declared in this scope mysqld.cc:3053: `max_binlog_dump_events' was not declared in this scope mysqld.cc:3056: `opt_sporadic_binlog_dump_fail' was not declared in this scope mysqld.cc:3057: `opt_sporadic_binlog_dump_fail' was not declared in this scope mysqld.cc:3299: `OPT_INNODB_MIRRORED_LOG_GROUPS' was not declared in this scope mysqld.cc:3304: `OPT_INNODB_LOG_FILES_IN_GROUP' was not declared in this scope mysqld.cc:3308: `OPT_INNODB_LOG_FILE_SIZE' was not declared in this scope mysqld.cc:3312: `OPT_INNODB_LOG_BUFFER_SIZE' was not declared in this scope mysqld.cc:3316: `OPT_INNODB_BUFFER_POOL_SIZE' was not declared in this scope mysqld.cc:3320: `OPT_INNODB_ADDITIONAL_MEM_POOL_SIZE' was not declared in this scope mysqld.cc:3325: `OPT_INNODB_FILE_IO_THREADS' was not declared in this scope mysqld.cc:3329: `OPT_INNODB_LOCK_WAIT_TIMEOUT' was not declared in this scope mysqld.cc:: `OPT_INNODB_THREAD_CONCURRENCY' was not declared in this scope mysqld.cc:3337: `OPT_INNODB_FORCE_RECOVERY' was not declared in this scope make[1]: *** [mysqld.o] Error 1 make[1]: Leaving directory `/root/mysql-4.0/sql' make: *** [all-recursive] Error 1 -- ./configure output: -- loading cache ./config.cache checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking build system type... i686-pc-linux-gnu checking for a BSD compatible install... (cached) /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... found checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) gawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) gcc checking whether the C++ compiler (gcc ) works... yes checking whether the C++ compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C++... (cached) yes checking whether gcc accepts -g... (cached) yes
RE: problem on Load Data!
Here is a bit of text I copy/pasted from the documents. The `\' directory character Pathname components in Win95 are separated by the `\' character, which is also the escape character in MySQL. If you are using LOAD DATA INFILE or SELECT ... INTO OUTFILE, you must double the `\' character: mysql LOAD DATA INFILE C:\\tmp\\skr.txt INTO TABLE skr; mysql SELECT * INTO OUTFILE 'C:\\tmp\\skr.txt' FROM skr; Alternatively, use Unix style filenames with `/' characters: mysql LOAD DATA INFILE C:/tmp/skr.txt INTO TABLE skr; mysql SELECT * INTO OUTFILE 'C:/tmp/skr.txt' FROM skr; I have also tested this. The information can be found in section 2.6.2.7 of the html documents that come with the download. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 3:24 PM To: Bob Ryan; ali hafiz; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: problem on Load Data! Wrong. Windows uses \ for their paths, so MySQL should use the same thing. Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Bob Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:59 PM To: 'ali hafiz'; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: problem on Load Data! I think you have to use a forward slash in your path instead of a backslash. C:/ as opposed to C:\ even in windows operating environments I believe you need to use /. -Original Message- From: ali hafiz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 2:23 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem on Load Data! Hi Jack, For question1, I think you need to use insert with set: insert into table ABC set column3 = , column4 = , column5 = ; I think that should do it. Have you managed to find an answer to question2? Please let me know. Ali From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: problem on Load Data! Date: Mon, 6 May 2002 12:40:08 +0800 Dear all Two Question : 1. I know that the 'LOAD DATA' command loads a bulk of data into a table, but what happen if i only want to load the data into specifc fields on a table instead of whole table. eg. Let say i had a file with 3 column of data, and i want to load these data into a 'ABC' table's field 3 to 5 and leave field 1 2 as it was! 2. I copied a file into server's root directory, and i was trying to load that file's data to table which i had failed using the following command in MYSQL: LOAD DATA infile 'c:\hkd_rate.csv' into table hkd_deposit1 fields terminated by ',' It said couldn't find the file! but if i put the file into the data directory of mysql, then it can find it! So what should i do if i want mysql will able to find that file from root directory? -- Thx a lot! Jack [EMAIL PROTECTED] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Most efficient query
I have two tables. One table, which (to protect the innocent :-)) we'll call MainTable, has a list of names with user info like address, etc.. and an auto-incrementing unique id for each. The other, which we'll call MapTable, is simply a key mapping table with ids from MainTable that just basically holds a list of MainTable ids to specify some sort of property (be it that they are disabled or whatever) Table: MainTable ID | NAME 1 Foo 2 Bar Table: MapTable ID --- 2 -- referring to the MainTable ID field I am trying to query the list of records in MainTable that are NOT mapped in MapTable. The query I am using is as follows: select MainTable.ID from MainTable,MapTable where MainTable.ID != MapTable.ID; this query works perfectly on a table with 10 records but when you get into the millions it takes quite a long time. Is there a faster way to get what I want? Thanks, Augey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Pretty Simple MAX Value question...
SELECT MAX(id) FROM (SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100) Dunno if this works in MySQL, I can't access a MySQL database from here to test it out. This should return the value that you want but I would be interested to learn the usefulness of running such a query without restricting it further than simply using LIMIT 100. Do you not need to ORDER BY your data either? What if all your high IDs are after record 100? Of course, I don't know you application, just bein' nosey. - Max Martin Anderson QA Engineer ProfitLogic Eleven Cambridge Center Cambridge, MA 02142 t: 617.218.1946 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: newbie help
Are you trying to load data FROM a text file, or are you trying to load data INTO a textfile? You said I just created a database and tried to LOAD 1 line of data from a text file. but then you stated i need to INTO OUTFILE ... If you wanna load data from a text file into a table, look at: http://www.mysql.com/doc/L/O/LOAD_DATA.html If you wanna load data into a text file, look at: http://www.mysql.com/doc/S/E/SELECT.html Gurhan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 3:34 PM To: [EMAIL PROTECTED] Subject: newbie help I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i dont see any? None of the coloums are overunning, all data types seem correct... What else could be going on? could i just ignore the warning? thank you bd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
time recording
Has anyone on this list used MySQL for time recording? I am a lawyer considering using it for recording time spent on cases where there are many to many relationships between cases, caseworkers, and charge-out rates. I posted to the list under the subject lookup and I learned that one cannot dynamically link tables so I am enquiring if anyone has done it before / reckons they know the best way to go about it. case1 is worked on by A for 30 minutes + B for 60 minutes whose charge out rates are £10 per hour and £15 per hour; -what is the most efficient way to get -£20 due on case1; -£5 work value due to A; -£15 work value due to B. given that caseworkers might go A-Z and beyond, any combination of caseworkers might works on any of the cases, there might be a large number of charge-out rates, and these might be related to different case types and different grades of caseworker. I realise this is essentially a design question, but given the way MySQL works I just wanted to check if anyone out there has done something similar. Any (friendly) suggestions would be welcome. Simon Tierney - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Most efficient query
You can do this with a pretty simple left join as follows: SELECT MainTable.ID from MainTable LEFT JOIN MapTable ON MainTable.ID=MapTable.ID where MapTable.ID IS NULL; Because it is a left join, it will pad all MainTable entries that don't appear in MapTable with NULL's. Hence we can check if those NULLS are there and if they are, then we know there isn't a corresponding entry in MapTable. Thus it will give us the results we want. Hope that helps. Harrison - Original Message - From: Augey Mikus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 5:10 PM Subject: Most efficient query I have two tables. One table, which (to protect the innocent :-)) we'll call MainTable, has a list of names with user info like address, etc.. and an auto-incrementing unique id for each. The other, which we'll call MapTable, is simply a key mapping table with ids from MainTable that just basically holds a list of MainTable ids to specify some sort of property (be it that they are disabled or whatever) Table: MainTable ID | NAME 1 Foo 2 Bar Table: MapTable ID --- 2 -- referring to the MainTable ID field I am trying to query the list of records in MainTable that are NOT mapped in MapTable. The query I am using is as follows: select MainTable.ID from MainTable,MapTable where MainTable.ID != MapTable.ID; this query works perfectly on a table with 10 records but when you get into the millions it takes quite a long time. Is there a faster way to get what I want? Thanks, Augey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Most efficient query
Correction. I can see a mistake in my syntax. the correct statement to pull the list of name in MainTable that ARE in mapMainTable is: select MainTable.Name from MainTable inner join MapTable using (ID); this works. but how can I pull the list of names that ARE NOT in the map table? Augey Augey Mikus wrote: I have two tables. One table, which (to protect the innocent :-)) we'll call MainTable, has a list of names with user info like address, etc.. and an auto-incrementing unique id for each. The other, which we'll call MapTable, is simply a key mapping table with ids from MainTable that just basically holds a list of MainTable ids to specify some sort of property (be it that they are disabled or whatever) Table: MainTable ID | NAME 1 Foo 2 Bar Table: MapTable ID --- 2 -- referring to the MainTable ID field I am trying to query the list of records in MainTable that are NOT mapped in MapTable. The query I am using is as follows: select MainTable.ID from MainTable,MapTable where MainTable.ID != MapTable.ID; this query works perfectly on a table with 10 records but when you get into the millions it takes quite a long time. Is there a faster way to get what I want? Thanks, Augey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Most efficient query
SELECT main.id FROM MainTable main OUTER JOIN MapTable map ON main.id = map.id WHERE map.id = null Does this work? Give it a whirl. Another solution could be to do it like this: SELECT col1, col2, coln FROM MainTable WHERE id IN ( SELECT id FROM MainTable WHERE id NOT IN ( SELECT id FROM MapTable ) ); Does MySQL support a MINUS like command like Oracle? Try them both and report back on performance. Martin Anderson QA Engineer ProfitLogic Eleven Cambridge Center Cambridge, MA 02142 t: 617.218.1946 -Original Message- From: Augey Mikus [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 5:11 PM To: [EMAIL PROTECTED] Subject: Most efficient query I have two tables. One table, which (to protect the innocent :-)) we'll call MainTable, has a list of names with user info like address, etc.. and an auto-incrementing unique id for each. The other, which we'll call MapTable, is simply a key mapping table with ids from MainTable that just basically holds a list of MainTable ids to specify some sort of property (be it that they are disabled or whatever) Table: MainTable ID | NAME 1 Foo 2 Bar Table: MapTable ID --- 2 -- referring to the MainTable ID field I am trying to query the list of records in MainTable that are NOT mapped in MapTable. The query I am using is as follows: select MainTable.ID from MainTable,MapTable where MainTable.ID != MapTable.ID; this query works perfectly on a table with 10 records but when you get into the millions it takes quite a long time. Is there a faster way to get what I want? Thanks, Augey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: time recording
check freshmeat.net There are several time recording tools. You may find one that works for you. Some of them use MySQL as a backend and some don't. While The idea of using MySQL as the backend for a program like this is good, you can't do it with MySQL alone. (Well, and keep your sanity) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Simon Tierney [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 3:49 PM To: [EMAIL PROTECTED] Subject: time recording Has anyone on this list used MySQL for time recording? I am a lawyer considering using it for recording time spent on cases where there are many to many relationships between cases, caseworkers, and charge-out rates. I posted to the list under the subject lookup and I learned that one cannot dynamically link tables so I am enquiring if anyone has done it before / reckons they know the best way to go about it. case1 is worked on by A for 30 minutes + B for 60 minutes whose charge out rates are £10 per hour and £15 per hour; -what is the most efficient way to get -£20 due on case1; -£5 work value due to A; -£15 work value due to B. given that caseworkers might go A-Z and beyond, any combination of caseworkers might works on any of the cases, there might be a large number of charge-out rates, and these might be related to different case types and different grades of caseworker. I realise this is essentially a design question, but given the way MySQL works I just wanted to check if anyone out there has done something similar. Any (friendly) suggestions would be welcome. Simon Tierney - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: To: mysql as a Good Person - Conduct Education in the 21st Century
At 03:57 PM 5/9/2002, you wrote: Dear mysql: You may ask yourself How to make people respect you How to win friends How to make your life smoother and happier How to do whatever you like without being unpleasant to other people Speaking of being unpleasant, I guess you didn't read the chapter about ticking people off by SPAMMING their newsgroups!!! How to develop good conduct in your children or students How to make the world peaceful and better Does it involve putting 10,000 spammers at the bottom of the ocean??? Sheesh. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: change displayed text results?
Hmmm - Off the top of my head, how about: select order, if(SUM(cat1+cat2)=0, '-', SUM(cat1+cat2)) as sum from tbl group by order Although you might need to quote the column name 'order', since that is a reserved word: select 'order', ... group by 'order' I think there's probably a cleaner way to do it, but that _should_ work... - steve At 2:55 PM -0200 5/9/02, [EMAIL PROTECTED] wrote: Hello dear all, I need to make a simple select query like this: select order, SUM(cat1+cat2) from tbl when the result of the SUM is =0 i need to change this 0 and display a character like '-' . Is possible to do this? and how? thanks in advance, regards fabrizio -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | ++ | If only life would imitate toys. | | - Ted Raimi, March 2002 | | - http://www.whoosh.org/issue67/friends67a.html#raimi | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: error granting rights
Yep... I am in as root, so I should have rights to everything. Yep, I have confirmed that the dbname is right, but doublechecking it multiple times. Plus, this happens even on db that I did the same thing to only a week ago. The * just says all tables as I understand it. And, that is what I am doing - setting up the user. That is the whole point. A couple of other considerations: I have PHPMySQLAdmin running - and it runs just fine. I can do most anything with it and have no errors. Also, I did this same thing on a different db just 1 week ago with no errors. This time, I even tried to scroll back through my commands in mysql at the mysql command prompt and re- submit the same commands - I get the same error. I have tried it on a variety of dbs and users, but no success. Thanks for all your help, Mark [snip] mysql GRANT ALL - ON dbname.* - TO username@localhost - IDENTIFIED BY 'password'; [/snip] A. Do you have GRANT capability as the user that you are logged on as? 2. Is dbname.* right? Shouldn't it be just dbname? III. Is user set up as username@localhost? Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My.cnf and large packet size..
Hi Pete, Thanks for the answer, I will search a bit better in the MySQL manual for info about the .cnf files.. (Already did, but couldn't 123 found the information you gave me.) What I understand is that changing the packet size doesn't have a very negative impact, sounds that it works as a protection against faulty query strings.. Thanks for the tip, I am going to play a bit with the configuration file. On the moment I don't have any cnf file, someone pointed me to the directory it should be in, but I already did a 'locate my.cnf' on my unix box, and there wasn't any file on the whole disc... The values used now are in between the my-medium and my-small files.. Maybe it wouldn't be bad to try the my-medium. The memory on my machine allows it, and MySQL is used very intensively. I do thought like to leave things that work well alone, but I will try and see what happens.. Thanks for the help and info.. With kind regards, David Bouw If your default settings are working fine I suggest you only include the max_allowed_packet variable in your my.cnf [mysqld] set-variable = max_allowed_packet=2M My question is what is the disadvantage when I change the max-packet-size (to a higher value)? From the manual a.. max_allowed_packet The maximum size of one packet. The message buffer is initialised to net_buffer_length bytes, but can grow up to max_allowed_packet bytes when needed. This value by default is small, to catch big (possibly wrong) packets. You must increase this value if you are using big BLOB columns. It should be as big as the biggest BLOB you want to use. The protocol limits for max_allowed_packet is 16M in MySQL 3.23 and 2G in MySQL 4.0. Pete Kelly TrafficG.com - Original Message - From: David Bouw [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 9:55 AM Subject: My.cnf and large packet size.. Hi, I am not sure on the following question and hope someone can spare some time to answer it: Due to the fact that I had problems storing a relatively huge text string ( 1 Megabyte) with PHP I found out that (by default???) MySQL has a packet size limitation which prevented me from doing this.. Searching through some mailling lists, I found out you can alter the max packet size in my.cnf. Problem is that I don't have a my.cnf file, I did see that there are some ready-to-use files for various kinds of 'machines'. I also looked at these files. My question is what is the disadvantage when I change the max-packet- size (to a higher value)? Also, will there be a lot of changes when I copy a configuration file to my.cnf. We use MySQL very intensively. (I now have 10 million queries in 8 days!). The database runs on a pentium III - 700 with 128 Megabyte (if meminfo is right - I thought it was a 256 Megabyte machine). I will probably use my-medium.cnf, Mysql (3.23.43) runs with Apache + PHP on the same machine.. Thanks for any help or pointers.. With kind regards, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Pretty Simple MAX Value question...
Hi Andrew, IT is working as it is supposed to , MAX() only returns one row with the highest value. IF you wanna get 100 highest values, just order the rows by id and limit the result set to 100. SELECT id FROM table WHERE DATE = '20020509' ORDER BY id LIMIT 100 Gurhan -Original Message- From: Andrew Kuebler [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 4:31 PM To: [EMAIL PROTECTED] Subject: Pretty Simple MAX Value question... I want to select say 100 of 1,000 records and get the highest value for id in that query, however the MAX command always gives me the MAX for the whole table, not just my query. Here's my expression: SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100 No matter what, I will always get the max for the column for the whole tableadding and removing the LIMIT command changes absolutely nothing... Thanks to anyone that might be able to help me... Frustrated, Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multivalue question
Hi Michael, On Fri, 2002-05-10 at 02:27, Michael Davis wrote: I'm trying to allow an attribute to hold multiple value. I know you can use varray in oracle but I cant find anything in mysql. I found SET but you must set the possible choices from the beginning. This is not good for what I'm doing because these choices will change. The only other thing that I could think of was to just encode all the choices in string and then decode them when I retrieve them. Any ideas. Stuffing multiple values into a single column is contrary to relational principles. Yes it can be useful sometimes, but look at the problems when searching in SET type columns The relational workaround for this is using a separate table, containing id,attribute, PRIMARY KEY (id,attribute). The id is the (autoincrement) id from the main table, and the attribute is whatever property you wanted to link to this id. Because the primary key combines the two fields, you can have multiple attributes per id, while still preventing duplicate rows. With this design you can easily add/remove attributes, check whether an id has a certain attribute, find all ids that have a certain attribute, or find all attributes for a given id. It may appear to be more complicated in design, but since the RDBMS takes care of all the legwork, it's actually very elegant and easy to use in queries. By the way, stuff like this (and much more) is taught in MySQL training courses, see http://www.mysql.com/training/ for details. Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep 2002, https://order.mysql.com/?marl __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Pretty Simple MAX Value question...
At 16:30 -0400 5/9/02, Andrew Kuebler wrote: I want to select say 100 of 1,000 records and get the highest value for id in that query, however the MAX command always gives me the MAX for the whole table, not just my query. Here's my expression: SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100 No matter what, I will always get the max for the column for the whole tableadding and removing the LIMIT command changes absolutely nothing... That's how LIMIT works. It's applied after the rest of your statement. That said, it's not clear to me why you need LIMIT at all. The statement as written should return a single row consisting of a single column (the maximum id value of the rows with the given date). Thanks to anyone that might be able to help me... Frustrated, Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Pretty Simple MAX Value question...
At 16:30 -0400 5/9/02, Andrew Kuebler wrote: I want to select say 100 of 1,000 records and get the highest value for id in that query, however the MAX command always gives me the MAX for the whole table, not just my query. Here's my expression: SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100 No matter what, I will always get the max for the column for the whole tableadding and removing the LIMIT command changes absolutely nothing... As Paul wrote, LIMIT is applied after everything else. Basically, MAX() won't help you here, since it is applied *before* the LIMIT. That's the fundamental problem with the above query. How about this: SELECT id FROM table WHERE DATE = '20020509' ORDER BY id LIMIT 99,1 This applies your date condition, sorts by id in ascending order and then grabs only row 100. Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep 2002, https://order.mysql.com/?marl __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error granting rights
Hmm, I am kinda new at this, but what happens if you specifically log into the user database first? mysql -u root -p mysql It could perhaps also mean your database is corrupted somehow; what do you get when you are running this below? /usr/local/bin/myisamchk /var/db/mysql/*/*.MYI (adjust paths to your install, of course). - Mark - Original Message - From: Mark Shade [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 10, 2002 12:16 AM Subject: RE: error granting rights Yep... I am in as root, so I should have rights to everything. Yep, I have confirmed that the dbname is right, but doublechecking it multiple times. Plus, this happens even on db that I did the same thing to only a week ago. The * just says all tables as I understand it. And, that is what I am doing - setting up the user. That is the whole point. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: merge tables using sql to find table names
Does your master table have a list of table names and the table's characteristics? How is the search called? currently i have a master table called files, the primary key is id and the data tables are called filedata1 filedata2, etc. where 1 and 2 correspond to the file id. Each of the filedata tables contains all the content to dynamically create a new file based on a linked template. file id = 1, name=greenville, contact=bob, template=3, defdirectory = soccer/ etc... filedata1 id = 29, type=1, data1=April 3, we won 6-4 against the bedford bears, data2=null, data3=null id=34, type=1, data1=Welcome to the greenville soccer team web page, data2=null, data3=null when the type=4 it looks for the text in the TextData file. However, when there is much less text, it is stored in the filedata file itself in the data1 column. data1 also contains the text that will be used in the alt tag for images(type=2), and the link's tags for links (type=3), etc. currently i am searching the TextData table using: $sql = SELECT files.location, files.filename, TextData.*, MATCH(TextData.text) AGAINST ('$searchFor') AS score ; $sql .=FROM TextData, files WHERE MATCH(TextData.text) AGAINST ('$searchFor') AND files.id = TextData.fid; 1) i want to be able to merge the FileDataX tables like this- only this doesn't work: error near (SELECT CONCAT... $sql = CREATE TEMPORARY TABLE searchtable (id int, type tinyint, data1 varchar(255), data2 int, data3 int) TYPE=MERGE UNION=(SELECT CONCAT('filedata',id) FROM files WHERE defdirectory LIKE '$defdirectory%') INSERT_METHOD=LAST; and then perform my full text search on data1 where type=1? snip: jay Seems like you would have to call multiple queries no matter what, unless you creat one large merged table for your several thousand small tables. Is this normalization gone overboard? Do all of the tables match in configuration (same # of columns, same datatype per column, etc.)? /snip actaully - i thought about one BIG table, or even medium sized tables however the primary use of the tables is to build one file from one filedata table, with the future ability for files to reference each other, to share data. to simplify the process, the editor reads in the entire table, presents the old data, and then on update, it deletes the entire table, and inserts the new data. otherwise, i would have to look for data that was removed, create an array of deleted rows, and then run the delete query, which actually takes lot more time than delete * from filedataX. There are several other factors that caused me to go the route of several filedata tables for each file. i will also say - my normalization isn't as smart as i'd have liked, and i'm thinking that i may move ALL the text into the textdata table, which is 3 columns fid = files.id INT line = filedatax.id INT text = whatever text TEXT but i have an index on my text column (required for the fulltext seach) and am concerned that if it's tooo big, it'll be a very slow search! as well as slowing down my editor too much, if got it down to about 20:1 small text : large text. ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error granting rights
The command mysql -u root -p mysql is what I used to get in. That is why I am confused. I have always gotten into MySQL that way before, and done the granting with no problems. I can't get to a shell just now, but I will checkthe myisamchk command as soon as I can. Thanks. Mark Hmm, I am kinda new at this, but what happens if you specifically log into the user database first? mysql -u root -p mysql It could perhaps also mean your database is corrupted somehow; what do you get when you are running this below? /usr/local/bin/myisamchk /var/db/mysql/*/*.MYI (adjust paths to your install, of course). - Mark - Original Message - From: Mark Shade [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 10, 2002 12:16 AM Subject: RE: error granting rights Yep... I am in as root, so I should have rights to everything. Yep, I have confirmed that the dbname is right, but doublechecking it multiple times. Plus, this happens even on db that I did the same thing to only a week ago. The * just says all tables as I understand it. And, that is what I am doing - setting up the user. That is the whole point. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling with gcc3 3.0.4
How do i do that? Tried : CC=gcc3 CXX=gcc3 ./configure make -j2 but it does not work. Gives this error : SNIP gcc3 -O3 -DDBUG_OFF -rdynamic -o .libs/mysqltest mysqltest.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/lib/mysql mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x1c): undefined reference to `__cxa_pure_virtual' collect2: ld returned 1 exit status make[2]: *** [mysqlbinlog] Error 1 make[2]: *** Waiting for unfinished jobs creating mysqltest make[2]: Leaving directory `/home/john/mysql-3.23.50/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/john/mysql-3.23.50' make: *** [all-recursive-am] Error 2 // Some System info. OS : Linux 2.4.18 Dist : Red Hat 7.2 Arch : x86 (Dual Athlon) [root@db mysql-3.23.50]# gcc3 -v Reading specs from /usr/local/gcc304/lib/gcc-lib/i386-redhat-linux/3.0.4/specs Configured with: ./configure --prefix=/usr/local/gcc304 --enable-shared --enable-threads=posi x --disable-checking --host=i386-redhat-linux Thread model: posix gcc version 3.0.4 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Good Job
Well, My hat's off to MySql 4 I finally got around my slow query problem... :-) Mysql has beat any other database I have used for this specific purpose... I wrote a quick little app to directly import records to the MYD file. I then run myisamchk -r -q v:\Data\...\..\MyDataFile to reindex the MYI file... I can Import 120 million records in 35 minutes. And reindex them in 40 minutes!! Good Job MySQL Programmers... Mike Grover - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help! Error building 4.0.2 under RH Linux 7.2
Hi Vadim, I don't know but have you read the instructions on the Mysql-website? To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. I've seen your files and its reporting you have a 2.96 compiler greetings Jurgen Campforts Meidoornlaan 2/1 2200 Herentals 0496/60.25.75 http://www.scnoorderwijk.be http://crashke.no-ip.biz -Oorspronkelijk bericht- Van: Vadim P. [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 9 mei 2002 23:07 Aan: [EMAIL PROTECTED] Onderwerp: Re: Help! Error building 4.0.2 under RH Linux 7.2 Just tried building Mysql-3.x.x cloned from the Development Tree on the same machine - works like a charm. Still no luck with 4.0.2 Is there any known issue regarding building 4.0.2 under RedHat7.2? Thanks, Vadim. Vadim P. wrote: The Dev. Tree Source MySQL 4.0 no longer builds on this machine, giving lots of errors. Had been able to build from the same source w/o any problems up until a few days ago, when I 'bk resync'ed the source. Any ideas? Thanks for your help! -- A snapshot of build transcript. Invoked by ./BUILD/compile-pentium. -- [sql]# make Making all in share make[1]: Entering directory `/root/mysql-4.0/sql/share' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/root/mysql-4.0/sql/share' make[1]: Entering directory `/root/mysql-4.0/sql' gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex -I. -I../include -I. -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc cc1plus: warning: Ignoring command line option '-Wimplicit-function-dec' cc1plus: warning: Ignoring command line option '-Wimplicit-int' mysqld.cc: In function `void *handle_connections_sockets (void *)': mysqld.cc:2425: warning: `my_socket new_sock' might be used uninitialized in this function mysqld.cc: At top level: mysqld.cc:3045: `disconnect_slave_event_count' was not declared in this scope mysqld.cc:3046: `disconnect_slave_event_count' was not declared in this scope mysqld.cc:3050: `abort_slave_event_count' was not declared in this scope mysqld.cc:3050: `abort_slave_event_count' was not declared in this scope mysqld.cc:3053: `max_binlog_dump_events' was not declared in this scope mysqld.cc:3053: `max_binlog_dump_events' was not declared in this scope mysqld.cc:3056: `opt_sporadic_binlog_dump_fail' was not declared in this scope mysqld.cc:3057: `opt_sporadic_binlog_dump_fail' was not declared in this scope mysqld.cc:3299: `OPT_INNODB_MIRRORED_LOG_GROUPS' was not declared in this scope mysqld.cc:3304: `OPT_INNODB_LOG_FILES_IN_GROUP' was not declared in this scope mysqld.cc:3308: `OPT_INNODB_LOG_FILE_SIZE' was not declared in this scope mysqld.cc:3312: `OPT_INNODB_LOG_BUFFER_SIZE' was not declared in this scope mysqld.cc:3316: `OPT_INNODB_BUFFER_POOL_SIZE' was not declared in this scope mysqld.cc:3320: `OPT_INNODB_ADDITIONAL_MEM_POOL_SIZE' was not declared in this scope mysqld.cc:3325: `OPT_INNODB_FILE_IO_THREADS' was not declared in this scope mysqld.cc:3329: `OPT_INNODB_LOCK_WAIT_TIMEOUT' was not declared in this scope mysqld.cc:: `OPT_INNODB_THREAD_CONCURRENCY' was not declared in this scope mysqld.cc:3337: `OPT_INNODB_FORCE_RECOVERY' was not declared in this scope make[1]: *** [mysqld.o] Error 1 make[1]: Leaving directory `/root/mysql-4.0/sql' make: *** [all-recursive] Error 1 -- ./configure output: -- loading cache ./config.cache checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking build system type... i686-pc-linux-gnu checking for a BSD compatible install... (cached) /usr/bin/install -c checking whether build environment is sane... yes
DROP DATABASE executes but fails to remove database!
Windows 2K MySQL V ? (recent). Sorry, I'm not at my own machine at present, can't check actual version number. Installed, running and everything is ok, except I created a database called 'xyz' as a test then decided to delete it. I used the command: DROP DATABASE 'xzy';which returns a message that the command executed successfully, affecting however many rows were in the database at the time. SHOW DATABASES; shows that the database is still there. I then re-tried using command: DROP DATABASE if exists 'xyz'; with the same result (no error messages). I then tried using mysqladmin to do the job, with the same result. I then used:DELETE FROM mysql.db WHERE Db = xyz; which also executes successfully. I test by using:SELECT db FROM mysql.Db; which reveals that the database is NOT there. However! SHOW DATABASES; still shows that the database is there! I have also tried right click drop database in the GUI MySQL management window. It fails to remove it. I have stopped and re-started the service and the computer several times. DROP DATABASE works fine for other databases I create and remove, just not this one. Is this a curly one? Any help appreciated. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creating a table from a query/How to?
Hello: Am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) on RH 7.2. I would like to construct a mysql command that select a unique set of data from one table and creates a table with that data. I think I'm close here, but am still getting errors: The query string is as follows: mysql LOAD DATA - SELECT DISTINCT Country from EUR - INTO TABLE EurCount; ERROR 1064: You have an error in your SQL syntax near 'SELECT DISTINCT Country from EUR INTO TABLE EurCount' at line 2 1)SELECT DISTINCT Country from EUR; # executes without error as a stand-lone command 2)EurCount has been created as follows: CREATE TABLE `EurCount` (Country CHAR (255)); 3)The Country column in EurCount has the same data type and size CHAR (255) as the Country column in EUR 1)Is my approach workable? If so, I'd appreciate help correcting syntax 2)Being pointed to documentation would be greatly appreciated 3)I would also like to find list of mysql ERROR codes TIA Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error granting rights
As bizarre as it sounds, it works now. I thought just on a whim I would try it again. I scrolled up and used the exact same commands as before (without retyping them) and it worked fine. I don't know what was wrong, but I suspect it may have had something to do with the amount of activity of MySQL stuff on my server at the time. Thanks all for your input! Mark At 06:10 PM 5/9/2002 -0500, Mark Shade wrote: The command mysql -u root -p mysql is what I used to get in. That is why I am confused. I have always gotten into MySQL that way before, and done the granting with no problems. I can't get to a shell just now, but I will checkthe myisamchk command as soon as I can. Thanks. Mark Hmm, I am kinda new at this, but what happens if you specifically log into the user database first? mysql -u root -p mysql It could perhaps also mean your database is corrupted somehow; what do you get when you are running this below? /usr/local/bin/myisamchk /var/db/mysql/*/*.MYI (adjust paths to your install, of course). - Mark - Original Message - From: Mark Shade [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 10, 2002 12:16 AM Subject: RE: error granting rights Yep... I am in as root, so I should have rights to everything. Yep, I have confirmed that the dbname is right, but doublechecking it multiple times. Plus, this happens even on db that I did the same thing to only a week ago. The * just says all tables as I understand it. And, that is what I am doing - setting up the user. That is the whole point. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple db, multiple table join
Good evening all, I have a strange situation which I cannot think myself out of. To make it simple my db looks like this (hr db, emp_master table) ++---+ | emp_id | last_name | ++---+ | 1 | smith | | 3 | wesson| | 4 | doe | | 6 | clinton | | 7 | bush | ++---+ (tools db, orders table) ++-+-+ | order_id | emp_id |approved_by | ++-+-+ | 1 | 1| 6 | | 2 | 4| 7 | | 3 | 3| 4 | | 4 | 7| 3 | | 5 | 6| 1 | ++-+-+ I want my query results to be similiar to this: if I'm selecting all, this is what I want: 1 smith clinton 2 doe bush 3 wesson doe 4 bush wesson 5 clintonsmith It seems so easy, but I've tried hard and cannot get it to work I've been going along the lines (changed several times) of Select tools.orders.order_id, hr.emp_master.last_name as ordered_by, hr.emp_master.last_name as approved_by from tools.orders, hr.emp_master where ((tools.orders.emp_id=hr.emp_master.emp_id) and (tools.orders.approved_by=hr.emp_master.emp_id)) (I hope I wrote that right, it was freehand, not in db) Thank you for any direction you can give me! Dam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating a table from a query/How to?.....
Hello Again: I'm not usually this lucky, but it seems that the trick is to let mysql do more of the work, and I'm happy to go along with that: What I needed is CREATE TABLE EurCount SELECT DISTINCT Country FROM EUR; (with EurCount being nonexistant) I would appreciate to be pointed to further docs on this topic all the same. regards -tim- I would like to construct a mysql command that select a unique set of data from one table and creates a table with that data. I think I'm close here, but am still getting errors: The query string is as follows: mysql LOAD DATA - SELECT DISTINCT Country from EUR - INTO TABLE EurCount; ERROR 1064: You have an error in your SQL syntax near 'SELECT DISTINCT Country from EUR INTO TABLE EurCount' at line 2 1)SELECT DISTINCT Country from EUR; # executes without error as a stand-lone command 2)EurCount has been created as follows: CREATE TABLE `EurCount` (Country CHAR (255)); 3)The Country column in EurCount has the same data type and size CHAR (255) as the Country column in EUR 1)Is my approach workable? If so, I'd appreciate help correcting syntax 2)Being pointed to documentation would be greatly appreciated 3)I would also like to find list of mysql ERROR codes TIA Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating a table from a query/How to?.....
Hi Tim, On Fri, 2002-05-10 at 11:53, Tim Johnson wrote: I'm not usually this lucky, but it seems that the trick is to let mysql do more of the work, and I'm happy to go along with that: What I needed is CREATE TABLE EurCount SELECT DISTINCT Country FROM EUR; (with EurCount being nonexistant) Indeed, will work. But the below can also be done with INSERT ... SELECT ... if the table already exists. http://www.mysql.com/doc/I/N/INSERT_SELECT.html The SELECT INTO ... syntax is an Oracle construct (not part of SQL-92 or SQL-99), and MySQL does not currently support that variation. I would appreciate to be pointed to further docs on this topic all the same. The online manual can be found at http://www.mysql.com/doc/ Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep 2002, https://order.mysql.com/?marl __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Rounding times
Well, assuming the time is in seconds (as in a UNix timestamp), you could use rounding function: select 600 * round(time_in_seconds/600) (600 being # of seconds in 10 minutes). Read the docs for the round() function - http://www.mysql.com/doc/M/a/Mathematical_functions.html - for some caveats in round behavior. If your system doesn't round the way you want, you'll have to get a bit more complex: select 600 * floor((time_in_seconds+300)/600) This will round 00:05:00, for example up to 00:10:00; use 299 instead of 300 if you want to round down. To do conversions to/from various date time formats, see http://www.mysql.com/doc/D/a/Date_and_time_functions.html Standard warnings about off-top-of-head untested code apply. Also, depending on the format of your database, you might be able to group your data using date_add()/date_sub() functions and INTERVAL operator. See the date time functions link above. -steve At 2:33 PM +0100 5/9/02, Peter Hicks wrote: Hi everyone I have a time value in MySQL that I want to round to the nearest ten minutes - for example, 00:32:15 should round to 00:30:00, and 00:48:05 should round to 00:50:00. I have racked my brains over this, and I can't work out how to do this. I'm attempting to write a query which will create ten-minute summaries from a data-set. Anyone help? Best wishes, Peter. -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | ++ | If only life would imitate toys. | | - Ted Raimi, March 2002 | | - http://www.whoosh.org/issue67/friends67a.html#raimi | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql...category--unlimited sub category level--self join problem...
hello to all mysql list subscribers , I have a problem which I think can be solved by SELF JOIN but I can't figure out how to do it here is table definition CREATE TABLE first ( firstcolumn int(11) default NULL, secondcolumn int(11) default NULL ) TYPE=MyISAM; INSERT INTO first VALUES (0,1); INSERT INTO first VALUES (0,2); INSERT INTO first VALUES (0,3); INSERT INTO first VALUES (2,4); INSERT INTO first VALUES (2,5); INSERT INTO first VALUES (2,6); INSERT INTO first VALUES (5,7); INSERT INTO first VALUES (5,8); INSERT INTO first VALUES (5,9); Now I use this as a table to track unlimited sub category branches like taking the above as example 1 , 2 , 3 are MAIN categories and the category subcategory tree will be 2--4, 5, 6 5-7 , 8 , 9 Now I want to delete the following rows using one or two sql statements 0,2 2,4 2,5 2,6 5,7 5,8 5,9 is it possible ? I can delete upto the second level using the statement DELETE from first where firstcolumn=2 OR secondcolumn=2 so only the rows 0,2 2,4 2,5 2,6 gets deleted but NOT 5,7 5,8 5,9 can you please help me formulate a SQL query which does that ? also if the table has a next level of data like 8 , 10 8, 11 8,12 those also must be deleted... since 10 , 11, 12 are subcategories of 8 , which in turn is a subcategory of 5 which in turn is a subcategory of 2 ..and 2 is the main category so if 2 is deleted all the below TREE must be deleted too ok that's it for a DELETE statement now I want to write a SELECT statement which retrieves all sub categories , sub sub categories , sub sub sub categories and so on ...GIVEN a main category ID so for example based on the above table I want to retrieve 4 ,5 ,6 , 7 ,8 ,9 IF GIVEN 2 as the main cat id also last but NOT the least ..for managing unlimited sub category branches is the above database design the best method ? Thanks to all please help chris __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Splitting a Table
Hi All, mysql newbie here, this may be a silly question, but I couldn't figure out how to word it for a google search I want to take a table that someone created, a break it up so that one table is NOT 125 fields large. I want to separate the table into user info, product info and product definition. everything happens to be in the same table. The table is heavily occupied with 20,000 entries. How would I start to execute this task ? Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't RESTORE...
Hi!! I used BACKUP TABLE command to take the backup of a table...but when i say RESTORE TABLE, i get the following :: mysql restore table rs from '/tmp'; +---+-+--+--+ | Table | Op | Msg_type | Msg_text | +---+-+--+--+ | rs| restore | error| Failed copying .frm file | +---+-+--+--+ 1 row in set (0.00 sec) The output after BACKUP TABLE was :: mysql backup table abc to '/tmp'; +--++--+--+ | Table| Op | Msg_type | Msg_text | +--++--+--+ | ritu.abc | backup | status | OK | +--++--+--+ 1 row in set (0.00 sec) Pls. tell me where i went wrongi locked the table before backup... Thanks... Regards, Ritu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php