Re: how to prevent inserting duplicate rows?
how do I OVERWRITE the previous entry in the table? ie. is there a SQL command to do like INSERT, but if duplicate found, overwrite with the new value. See REPLACE into tablename http://www.mysql.com/doc/R/E/REPLACE.html Take care, seth - 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
Got timeout reading communication packets
Hi! I posted this last week, but, haven't seen any replies yet, and, generally, there seems to be a lack of replies in the archives on the Got timeout reading communication packets related issues. Here is the issue again: We have started doing some rather large replace intos and inserts (~3MB) using a client written in C. However, these queries are truncating at around 100k - meaning, it inserts about 100k or so of the blob field.. but, stops and truncates out the rest of the query. There is no error returend by the connection, but, the error log does have errors such as these: 010323 11:15:19 Aborted connection 45 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) The same occurs if I pipe the query directly to mysql from the command line. No error, but the data field only has about 100k of the data there before it just stops. The table looks like this: # MySQL dump 8.13 # # Host: localhostDatabase: reflectivity # # Server version3.23.35 # # Table structure for table 'measurement_extended_data' # CREATE TABLE measurement_extended_data ( content_typeID tinyint(3) unsigned NOT NULL default '0', contentID int(10) unsigned NOT NULL default '0', arrayID smallint(5) unsigned NOT NULL default '0', positionID mediumint(8) unsigned NOT NULL default '0', testID smallint(5) unsigned NOT NULL default '0', iteration smallint(5) unsigned NOT NULL default '0', test_locationID smallint(5) unsigned NOT NULL default '0', date_added int(10) unsigned NOT NULL default '0', added_by mediumint(8) unsigned NOT NULL default '0', data blob NOT NULL, PRIMARY KEY (content_typeID,contentID,arrayID,positionID,testID,iteration), KEY test_locationID (test_locationID), KEY testID (testID) ) TYPE=MyISAM; Smaller queries work fine. It's just when they seem to be over 1 or 2MB. /etc/my.cnf looks like this: # MySQL Configuration File # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] port= 3306 socket = /tmp/mysql.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=256M set-variable= max_allowed_packet=7096128 set-variable= thread_stack=128K set-variable= back_log=50 set-variable= max_connections=512 set-variable= tmp_table_size=15M set-variable= table_cache=6000 set-variable= sort_buffer=3584K set-variable= join_buffer=512K set-variable= connect_timeout=2 set-variable= record_buffer=1M set-variable= flush_time=900 set-variable= wait_timeout=300 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [myisamchk] set-variable= key_buffer=32M set-variable= sort_buffer_size=48M As you can see we bumped up the max_allowed_packet because we were getting server has gone away errors. - Box is a 1Ghz XEON /w Redhat 7.2 and 1GB RAM - MySQL version is: 3.23.35 - Query is a fairly straight forward insert or replace into and is verified as clean. Am I missing a configuration directive? Is something else up? Thanks! Seth - 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
unique and primary constraints
hi sql ppls, if i set a field as a primary key, does it automatically make sure its unique or should i declare a UNIQUE constraint as well? or will primary do the job by itself. thanks - Josh [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
MYSQLDUMP feature request :)
Hello mysql, Resently MYSQL have introduced transaction support, which at least in INNODB allows to make consistent backup/recovery. The bad thing about this is - MYSQLDUMP does not support anything about this, so I had to done the same things buy hands. The Idea is quite simple - to add transaction start in the begin of backup and in the begining of recovery. This would take a consistent backup of all of the tables, and as well will allow consistent recovery, at least if not using drop table. -- Best regards, Peter mailto:[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: unique and primary constraints
if i set a field as a primary key, does it automatically make sure its unique or should i declare a UNIQUE constraint as well? or will primary do the job by itself. a primary key is always unique. No need to give it an extra unique index. Greetings, Ansgar http://www.mysqlfront.de/ - 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: Compiling MySQL 3.23.39 on HP-UX 11.00.
Michael Widenius wrote: Jack Configure Command: Jack -- Jack CFLAGS=-D_REENTRANT Jack CXXFLAGS=-D_REENTRANT \ Jack ./configure Jack --prefix=/opt/mysql Jack \ Jack --with-pthread Jack --with-named-thread-libs=-lpthread \ Jack --with-mysqld-ldflags=-L/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3 Jack -lgcc \ Jack --with-client-ldflags=-L/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3 Jack -lgcc Why do you need to include the path to libgcc ? Normally this is an indication that something is wrong. I've been fooling around in an (vain) effort to get the Msql-MySQL perl binding to work. (Yes, I have followed the README ;) ). I have tried that command without the libgcc stuff and it does seem to work. Jack MySQL Source Changes: Jack - Jack ### I believe these could be fixed just by corrected the configure Jack script tests, Jack ### as they're all #ifdef tests Jack edited readline/nls.c to unconditionally #include locale.h Jack edited libmysql/libmysql.c to unconditionally #include pwd.h Jack edited mysys/mf_pack.c to unconditionally #include pwd.h Jack edited include/global.hto unconditionally #include stdlib.h configure should test for the above include files and use these if they exist on your system. Have you any idea why configure didn't include these on your system? I have myself compiled MySQL on HPUX 11.0 with just ./configure and I didn't get any compile errors. I think the problem is that some of the gcc header files have changed from version 2.95.2 to 2.95.3, defining __va__list, which is defined by HP-UX include files. Excerpt from config.log: configure:7645: checking for locale.h configure:7655: gcc -E -D__STDC_EXT__ conftest.c /dev/null 2conftest.out In file included from /usr/include/locale.h:157, from configure:7651: /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3/include/stdio.h:30: warning: `__va__list' redefined /usr/include/locale.h:26: warning: this is the location of the previous definition configure: failed program was: #line 7650 configure #include confdefs.h #include locale.h I haven't yet worked out what to fix to stop this (eg: does gcc *need* that #define?) This was using the precompiled gcc binary from http://hpux.connect.org.uk/ Hope that helps jack - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL query problem
On Fri, 22 Jun 2001, Thomas J Keller wrote: select zip, city, county from zipcodes where zip between 68400 and 68500; here is a portion of the garbled output: |68442 | STELLA | RICHARDSON |43 | STERLING | JOHNSON |444 | STRANG | FILLMORE |5 | SWANTON | SALINE +---+--+-+ Not too sure what could be wrong, but I did something like this: mysql select * from country where contid between 10 and 20; ++--++ | id | country | contid | ++--++ | 9 | Benin| 10 | | 10 | Bermuda | 11 | | 11 | Birmania | 12 | | 12 | Bolivia | 13 | | 13 | Botswana | 14 | | 14 | Bulgaria | 15 | | 15 | Burkina faso | 16 | | 16 | Burundi | 17 | | 17 | Buthan | 18 | | 18 | Cambogia | 19 | | 19 | Camerun | 20 | ++--++ 11 rows in set (0.00 sec) It works! My table is: mysql desc country; +-+-+--+-+-++-+ | Field | Type| Null | Key | Default | Extra | Privileges | +-+-+--+-+-++-+ | id | int(5) | | PRI | NULL| auto_increment | select,insert,update,references | | country | varchar(35) | | MUL | || select,insert,update,references | | contid | int(5) | | UNI | 0 || select,insert,update,references | +-+-+--+-+-++-+ Similar to yours. Does your table hold any data less that 65000? Try select zip, city, county from zipcodes where zip=68400 and zip= 68500; Regards Adrian - 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
last_insert_id() Bug???
i have tables forward and mail with the auto_increment field - mid i have the following sql queryes: insert into mail(mid,gdate,folder,txt,html,email,subj,date,uid,size,attach, attachbefore, attachafter,message,flag)values(NULL,now(),1,'+g_text+','+g_html+','+g_from+','+g_subject+','+szDate+',+buf+,+buf1+,+buf2+,+szfirstattach+,+szlastattach+,'+g_header.c_str()+',+flag[0]+); insert into forward(fwuid,message,email,user,subj,date,uid,mid,size,attach)values(NULL,'+message+','+g_from+','','+g_subject+','+szDate+',+buf+,last_insert_id(),+szmessagesize+,+buf2+); But some times last_insert_id() returns 0; Any suggestions??
mysql_init
I get the following error, if I run DBI,DBD,mysql .../DBD/mysql/mysql.so: symbol mysql_init: referenced symbol not found! What can I do against this? Stepan - 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
Kylix with MySQL
Hi Everybody! I want to develop some database application under RedHat 7, with Kylix using MySql. I'm using MySql 3.23.38. It uses libmysql.10, default limbysql.6. Kylix native MySql driver cannot connect to MySql server on the same (neither localhost, nor IP) but MySql is Accessible from Windows/ODBC via network, and with the MySql Clients. Error: Invalid UserName/PassWord. Does anybody have some information how to solve the problem? I would use the highest MySql Version. I heard somewhere that Kylix supports libmysql.6 only. If that's the problem what is the highest MySql version using that lib. Shall I change the whole MySql installation or the libfile only? I would appreciate some help. regards Akos
[request] IP Address Functions
Hello, I have a feature request: How about adding a built-in function to convert IP addresses from strings to INT UNSIGNED, and another function to convert vice versa. This makes it easier for e.g. people whose web applications log IP addresses in MySQL; it is more efficient to store IP addresses as INT UNSIGNED than VARCHAR(10). Also, mask operations (e.g. '' and '|') can be performed on INT UNSIGNED. I have attached two C functions (ip2num to convert from string to unsigned long, and num2ip to convert from unsigned long to string) that could be used as code if someone decides to make a built-in function for this. -Philip Mak ([EMAIL PROTECTED]) /* ip.c * * Functions for converting IP addresses between strings and * unsigned long int. */ unsigned long ip2num(char *char_ip) { char num_ip[5]; unsigned long *long_ip; num_ip[4] = 0; sscanf(char_ip, %d.%d.%d.%d, num_ip, num_ip+1, num_ip+2, num_ip+3); long_ip = (unsigned long *) num_ip; return *long_ip; } char *num2ip(unsigned long num_ip) { static char char_ip[10]; char *ips; ips = (char *) num_ip; sprintf(char_ip, %d.%d.%d.%d, (unsigned char) *ips, (unsigned char) *(ips+1), (unsigned char) *(ips+2), (unsigned char) *(ips+3)); return char_ip; } main() { unsigned long ip; ip = ip2num(64.29.16.235); printf(64.29.16.235 = %lu\n, ip); printf(%lu = %s\n, ip, num2ip(ip)); } - 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: Got timeout reading communication packets
You are possibly not escaping binary fields. You should use mysql_escape_string() function on binary objects prior to inserting it in the INSERT command, or use load_file() function. -- 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: mysql guis
[EMAIL PROTECTED] writes: what are peoples recommendations on linux guis for mysql? I've used mysqlfront on windows, but now I finally got linux onto my work laptop, I'm looking for a nice gui for linux, (gnome,kde, whatever, doesnt matter). Thanks ___ Sean O'Donnell Hi! You might try our mysqlgui, it works on both Unix and Windows. -- 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: mySQL database running on a CD?
- Is it possible to use mySQL for this purpose? Yes - Is it possible to set the database to be read-only? If you use the compress command for your data in the database in not only makes the files smaller is also makes them read only.. - We need to transfer the database structure/data to the new database. I have seen the script 'oracledump.pl' that dump an Oracle database into a mySQL dump file. Does this works fine? Sorry I have not tried this so don't know Simon - 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: [request] IP Address Functions
Philip test [EMAIL PROTECTED] writes: Hello, I have a feature request: How about adding a built-in function to convert IP addresses from strings to INT UNSIGNED, and another function to convert vice versa. This makes it easier for e.g. people whose web applications log IP addresses in MySQL; it is more efficient to store IP addresses as INT UNSIGNED than VARCHAR(10). Also, mask operations (e.g. '' and '|') can be performed on INT UNSIGNED. I have attached two C functions (ip2num to convert from string to unsigned long, and num2ip to convert from unsigned long to string) that could be used as code if someone decides to make a built-in function for this. -Philip Mak ([EMAIL PROTECTED]) HI1 Have you taken a look at INET_ATON and INET_NTOA functions ?? -- 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: $sth-{mysql_insertid} not working in 3.23.38?
x My problem with this is that I have no control over the versioning. I'm x using an ISP who was gracious enough to upgrade one of the servers (hosting x our largest clients) to 3.23 because it was having a BUNCH of other x problems. x So if the {mysql_insertid} thing is an issue, is there a fix? Does the x latest DBD/DBI package fix it? Or is it strictly a MySQL issue and just x needs to wait for a new release? There is exist two alternative versions of DBD drivers for MySQL on CPAN at this moment: distribution DBD-MySQL and ditribution Msql-Mysql-modules. AFAIK first distribution has driver which had bug with $dbh-{mysql_insertid} in its old versions. You should ask your ISP to install latest version of Msql-Mysql-modules or latest version DBD-MySQL. It is better to install Msql-Mysql-modules because DBD-MySQL is experimental driver. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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: transactions
Hello All, I'm current working on project, converting a flatfile system, to use MySQL, which supports transactions w/Innobase tables. My questions is, as I'm sure many have coded using transaction w/Perl and DBI. I understand that there as some draw backs to using transactions when not necessary, but very beneficial, when needed. What are some good guide lines or rule of thumb to following when using transactions type tables? This is from 'man DBI'. I don't think I can add anything to it: The recommended way to implement robust transactions in Perl applications is to use `RaiseError' and `eval { ... }' (which is very fast, unlike `eval ...'). For example: $dbh-{AutoCommit} = 0; # enable transactions, if possible $dbh-{RaiseError} = 1; eval { foo(...)# do lots of work here bar(...)# including inserts baz(...)# and updates $dbh-commit; # commit the changes if we get this far }; if ($@) { warn Transaction aborted because $@; $dbh-rollback; # undo the incomplete changes # add other application on-error-clean-up code here } -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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
What does the max_connect_errors do ?
What does the max_connect_errors do ? Is it : if I have that many connect errors, MySQL will stop ? [database] - 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
For relexion - Zur Entspannung (Off topic !!!)
Worked the whole day with mysql ? Want some nice relexion ? Den ganzen Tag mit MySQL herumgeschlagen ? Du brauchst etwas schöne Entspannung ? Here is a site which uses MySQL as database too. ;) Hier ist eine Seite die auch MySQL als Datenbank benutzt ;) Register with sexportal.de Registriere dich bei sexportal.de Soft things are free and for the hard stuff you get 25% off if you use the following link. Softe Sachen sind kostenlos und für die harten bekommst du 25% Rabatt, wenn du den folgenden Link benutzt. http://www.sexportal.de/?recruiter=Maverick _ Get Your Private, Free E-mail from MSN Hotmail at 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
Re: transactions
At 3:40 PM +0400 6/25/01, Ilya Martynov wrote: Hello All, I'm current working on project, converting a flatfile system, to use MySQL, which supports transactions w/Innobase tables. My questions is, as I'm sure many have coded using transaction w/Perl and DBI. I understand that there as some draw backs to using transactions when not necessary, but very beneficial, when needed. What are some good guide lines or rule of thumb to following when using transactions type tables? This is from 'man DBI'. I don't think I can add anything to it: There was some discussion on the DBI list recently on this topic that indicated that under some conditions having PrintError enabled could result in the transaction being committed when an error occurred. I haven't observed that to happen myself, but to avoid the problem, it may be prudent to add this to the two lines preceding the eval: $dbh-{PrintError} = 0; The recommended way to implement robust transactions in Perl applications is to use `RaiseError' and `eval { ... }' (which is very fast, unlike `eval ...'). For example: $dbh-{AutoCommit} = 0; # enable transactions, if possible $dbh-{RaiseError} = 1; eval { foo(...)# do lots of work here bar(...)# including inserts baz(...)# and updates $dbh-commit; # commit the changes if we get this far }; if ($@) { warn Transaction aborted because $@; $dbh-rollback; # undo the incomplete changes # add other application on-error-clean-up code here } -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.com/) | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Paul DuBois, [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: transactions
On Mon, 25 Jun 2001 07:42:39 -0500, Paul DuBois [EMAIL PROTECTED] wrote: Paul, appreciate the feedback, but my question wasn't in reference to the actual coding and how it's used, this I understand, I was referring to when a transaction is best used, in what type of a scenario. ;) TIA At 3:40 PM +0400 6/25/01, Ilya Martynov wrote: Hello All, I'm current working on project, converting a flatfile system, to use MySQL, which supports transactions w/Innobase tables. My questions is, as I'm sure many have coded using transaction w/Perl and DBI. I understand that there as some draw backs to using transactions when not necessary, but very beneficial, when needed. What are some good guide lines or rule of thumb to following when using transactions type tables? This is from 'man DBI'. I don't think I can add anything to it: There was some discussion on the DBI list recently on this topic that indicated that under some conditions having PrintError enabled could result in the transaction being committed when an error occurred. I haven't observed that to happen myself, but to avoid the problem, it may be prudent to add this to the two lines preceding the eval: $dbh-{PrintError} = 0; The recommended way to implement robust transactions in Perl applications is to use `RaiseError' and `eval { ... }' (which is very fast, unlike `eval ...'). For example: $dbh-{AutoCommit} = 0; # enable transactions, if possible $dbh-{RaiseError} = 1; eval { foo(...)# do lots of work here bar(...)# including inserts baz(...)# and updates $dbh-commit; # commit the changes if we get this far }; if ($@) { warn Transaction aborted because $@; $dbh-rollback; # undo the incomplete changes # add other application on-error-clean-up code here } -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.com/) | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-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: [request] IP Address Functions
Hi, I have a feature request: How about adding a built-in function to convert IP addresses from strings to INT UNSIGNED, and another function to convert vice versa. Have you taken a look at INET_ATON and INET_NTOA functions ?? Yes, you might want to take a read of section 7.4.12, 'Miscellaneous Functions', in the current MySQL manual: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html I assume you must also be using an old version of MySQL, as these functions were only added in version 3.23.15, so you should upgrade your installation of MySQL. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [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: MyODBC through ADO
The easiest way to work out what your connection string should be is to create a new text file in explorer, rename it Something.UDL, and double click it: You then get the MS Data Link editor dialog. Select the MS OLEDB Provider for ODBC Drivers as the Provider, select your ODBC datasource (I don't know if you can use a file DSN) and hit the OK button. If you open the UDL file with a text editor, you can read the connection string. I have had problems using the MySQL OLEDB Provider, which is why I recommend using the ODBC OLEDB Provider. First I'l install the MySQL in a remote NT server and also MyODBC in Client machine. Then I'll create a File DSN using MyODBC. Now what Provider name (eg For Oracle MSDAORA) and ConnectString should I give ? - 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
MySQLGUI
What do we require to use the MySQLGUI with our MYSQL server. We are looking to manage the users and tables over the web from an NT machine. Can you please advise us. I think that you may have a very large market out there is it works in the way that i have been lead to believe. Thanks James James Wilkinson [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Chief Executive Ruella James plc 21-22 Great Castle Street, London, W1N 7AA. +44 (0)20 7 290 6555 (Switchboard) +44 (0)20 7 290 6554 (Fax) +44 (0)20 7 290 6552 (Administration) +44 (0)20 7 290 6556 (Accounts) This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any opinions expressed in the email are those of the individual and not necessarily the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivery to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. If you have received this email in error, or if you are concerned with the content of this email please notify the IT helpdesk by email on [EMAIL PROTECTED] mailto:[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
Question on select
Hello Guys, I have a char field, and I'd like to have select ordering it by lowercase caracteres, uppercase caracters then special characters. I was reading about sort and this seems to be related to charset of the server, and I dont have access to change this. I was thinking on making this select a select of 3 selects. On the first one I'd select where the column starts with [a-z]. On the second one [A-Z], and the third one would be NOT [a-z] AND NOT [A-Z], both three sorted. The question is . how can a query that selects all records having a column STARTING with a-z lowercase Hope hearing from you soon, Leonardo Rodrigues Persocom Network
Re: Got timeout reading communication packets
You are possibly not escaping binary fields. You should use mysql_escape_string() function on binary objects prior to inserting it in the INSERT command, or use load_file() function. Thanks Sinisa for the reply! There really isn't any binary data.. and, we are calling mysql_escape_string.. here is the snippet of code: // START SNIP int state; unsigned int encoded_str_length = 0; MYSQL_RES *result; MYSQL_ROW row; char *sql, *escaped_data; escaped_data = new char[2*strlen(data)+1]; //required by mysql sql = new char[2*strlen(data)+600];// +1 encoded_str_length = mysql_escape_string(escaped_data,data,strlen(data)); sprintf(sql,%s%d%s%d%s%d%s%d%s%d%s%d%s%d%s%d%s%d%s%s%s, REPLACE into reflectivity.measurement_extended_data set content_typeID = ,content_typeID, , contentID = ,contentID, , arrayID = ,arrayID, , positionID = ,positionID, , testID = ,testID, , iteration = ,iteration, , test_locationID = ,test_locationID, , date_added = ,date_added, , added_by = ,added_by, , data = ',escaped_data,'); state = mysql_query(connection,sql); delete [ ] sql; delete [ ] escaped_data; if (state != 0) { Application-MessageBox(mysql_error(connection),NULL,MB_OK); return 0; } // END SNIP And, as I mentioned, if I do something like: bin/mysql -u -p database foo.sql where foo.sql contains the query checked for sanity the exact same result occurs. - 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 I force SELECT to use a specified INDEX?
Hi, I have a table with several complex indexes: (source,description,timestamp,id) (timestamp,id) as well as individual indexes (id) (timestamp) (type) (source) (description) mysql describe eventlog; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(10) unsigned | | PRI | NULL| auto_increment | | timestamp | int(10) unsigned | | MUL | 0 || | type| tinyint(4) | | MUL | 0 || | source | char(15) | | MUL | || | description | char(100)| YES | MUL | NULL|| +-+--+--+-+-++ I perform the following search: SELECT * from eventlog where description like '%...%' order by timestamp desc, id desc; SELECT * from eventlog where source = .. description like '%...%' order by timestamp desc, id desc; For whatever reason, the second search is consistently very slow (20 sec) inspite the fact that there is an index definition to its effect. I find the first search fast - relatively giving me 0~1 on average, 2~5 at worst. Was the 1st search fast because it uses only one index (description) while the 2nd search slow because it uses the complex index (source,description) ? Jaime - 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: Got timeout reading communication packets
Seth Northrop writes: You are possibly not escaping binary fields. You should use mysql_escape_string() function on binary objects prior to inserting it in the INSERT command, or use load_file() function. Thanks Sinisa for the reply! There really isn't any binary data.. and, we are calling mysql_escape_string.. here is the snippet of code: And, as I mentioned, if I do something like: bin/mysql -u -p database foo.sql where foo.sql contains the query checked for sanity the exact same result occurs. At a small glance, your code looks OK. Try looking at resulting string sql in gdb or just print it out to stdout. That might catch your bug. I noted however that you forgot to quote string constants !! MySQL commands lenghts are limited only by max_allowed_packet, which can be extended up to 16 Mb in 3.23 and 4 Gb in 4.0. As you are coding in C++, try using MySQL++. You can use streams tehre, so you do not have to think about possible errors you have made in sprintf(). You can also use quote and escape manipulators for easier programming. -- 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
couldnt select database
hi, new to the list so here goes! i have mysql version 3.23.38 installed on a win98 pc running apache with php 4 installed. i am working through the book and so have created a database called 'test'. i have also put a server, user and password into the mysql database. i have connected to this using php code. then i recreated a second database called guest. when i try to connect to this i get a cant select message from my php code. i have tried different names and flushing the privileges but nothing i do will help. i have also deleted all the databases and recreated them and agin, the only one i can connect to is one called test this is driving me mad!! does anyone have any ideas?? cheers, jake 28 23a great queen street london wc2b 5bb t 020 7404 4828 f 0870 164 3109 [EMAIL PROTECTED] m 07931 507 442 - 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: MySQLGUI
James Wilkinson writes: What do we require to use the MySQLGUI with our MYSQL server. We are looking to manage the users and tables over the web from an NT machine. Can you please advise us. I think that you may have a very large market out there is it works in the way that i have been lead to believe. Thanks James Hi! All you have to do is download mysqlgui static binary for Windows from it's page on www.mysql.com. Then start it and fill-up all entries carefully in the Options book and save them, just as described in README that comes with a distro. Read carefully all text files that come with it. MySQL.help and README were edited and corrected by none else then my friend Paul DuBois. Soon, version 1.7.5-1 for Windows will hit mysqlgui page. Try that version. We have not yet got any bug reports on that one. -- 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: MySQLGUI
On Mon, 25 Jun 2001, James Wilkinson wrote: What do we require to use the MySQLGUI with our MYSQL server. a) myqsl server with a user configured for remote login (assuming mysql is on one machine, GUI is on another). b) GUI client c) Config the client to use the appropriate user and password. d) Login. -- Sapere aude My mind not only wanders, it sometimes leaves completely. - 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: Got timeout reading communication packets
At a small glance, your code looks OK. Try looking at resulting string sql in gdb or just print it out to stdout. That might catch your bug. Thanks again for the reply. The query looks sane.. As I mentioned, I spit it out to a file and piped it directly to mysql (after inspecting it). At least where it truncates there isn't anything abnormal (the blob is merely a tab delimited string of ints) and the same truncation occurs. MySQL commands lenghts are limited only by max_allowed_packet, which can be extended up to 16 Mb in 3.23 and 4 Gb in 4.0. Nodz.. that's what I thought. This is our setting: set-variable= max_allowed_packet=7096128 Confirmed in variables: | max_allowed_packet | 7095296 It's definately not that big, and, we aren't getting the standard expected errors when you exceed packet size (such as mysql server has gone away). The only clue we have is this: 010624 19:44:23 Aborted connection 231 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) - 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: Got timeout reading communication packets
Seth Northrop writes: 010624 19:44:23 Aborted connection 231 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) The above only implies that your program exited without calling mysql_close(). Nothing to do with your problem. But, as I told you , you did not quote string constants. And shoot out your resulting string to some file for inspection. That might help you find your error. -- 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
MySQLGUI Issue
I am new to MySQL and this may be more of a training issue on my part than a problem. I can not seem to get the 'edit table' or 'create table' function to work. Not sure if I don't know the sequence of things to do or what. Please advise. Regards Marty Bell * Marty Bell, P.E. 972.575.6032 [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: $sth-{mysql_insertid} not working in 3.23.38?
As of a couple of months ago, there is a bug with DBI's implementation of $dbh-{'mysql_insert'}. It didn't handle 64-bit IDs correctly. We converted everything to use SELECT LAST_INSERT_ID(). It works. MySQL is fine, the problem was in DBI. Don't use SELECT MAX(ID) ... as that will not do what you want and you'll corrupt your own data! Best, Kyle P.S. Spam bot: database, row, query, mysql. On Saturday 23 June 2001 11:07, xris wrote: So if the {mysql_insertid} thing is an issue, is there a fix? Does the latest DBD/DBI package fix it? Or is it strictly a MySQL issue and just needs to wait for a new release? As it is, it seems that: my ($id) = $dbh-selectrow_array(SELECT MAX(id) FROM tbl;); Don't use this!!! - 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
What's wrong with my GRANT example?
Hi, I am sorry for asking stupid questions, but I am at the end of my trials. I simply want to setup a user who can connect from anywhere and write some table and read from another one. Here's what I do: GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO dataexport@localhost IDENTIFIED BY 'somepassword'; GRANT SELECT ON sessiondb.LANGUAGELIST TO dataexport@localhost IDENTIFIED BY 'somepassword'; GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO dataexport@% IDENTIFIED BY 'somepassword'; GRANT SELECT ON sessiondb.LANGUAGELIST TO dataexport@% IDENTIFIED BY 'somepassword'; FLUSH PRIVILEGES; Looking into the tables tables_priv and user, everything looks good. So does the output of SHOW GRANTS for dataexport@localhost. However, it still doesn't work. (See output below.) Any ideas, what might be wrong? Thanks, Jochen C:\cvs12\tmc:\Programme\mysql\bin\mysql mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 674 to server version: 3.23.39-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO dataexport@localhost IDENTIFIED BY 'somepassword'; Query OK, 0 rows affected (0.01 sec) mysql GRANT SELECT ON sessiondb.LANGUAGELIST TO dataexport@localhost IDENTIFIED BY 'somepassword'; Query OK, 0 rows affected (0.00 sec) mysql GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO dataexport@% IDENTIFIED BY 'somepassword'; Query OK, 0 rows affected (0.00 sec) mysql GRANT SELECT ON sessiondb.LANGUAGELIST TO dataexport@% IDENTIFIED BY 'somepassword'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql exit Bye C:\cvs12\tmc:\Programme\mysql\bin\mysql --user=dataexport --password=somepassword sessiondb Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 675 to server version: 3.23.39-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql select * from sessiondb.LANGUAGELIST; ERROR 1142: select command denied to user: 'dataexport@localhost' for table 'languagelist' mysql quit Bye - 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: transactions
The first that springs to mind is: pricture 2 tables. Pocket and Store. (Where pocket as in i have got money in my pocket, and store as in Let's go buy some shoes in the store!. Pocket ( money integer ) ; Store ( money integer ); Now, suppose you are supposed to TRANSFER 10 dollars from Pocket to Store. You buy some sheap shoes at some arbitrary store. SELECT money FROM Pocket... UPDATE Store... UPDATE Pocket... Do this in a transaction! If something goes wrong updating Pocket, and only the Store gets updated, you are one lucky bastard!! And we don't want that, none of us!! ;) Daniel Åkerud Paul, appreciate the feedback, but my question wasn't in reference to the actual coding and how it's used, this I understand, I was referring to when a transaction is best used, in what type of a scenario. ;) TIA - 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: conflicts with new version
Richard Kurth [EMAIL PROTECTED] writes: I am trying to reinstall mysql on a cobalt server I removed the first version but when I go to install the new version I get this message below saying it conflicts with another version could you tell me how I can correct this. I have looked through the entire directory structure and can not find any other files that relate to mysql file /etc/logrotate.d/mysql from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /etc/rc.d/init.d/mysql from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/isamchk from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/isamlog from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/mysql_install_db from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/mysql_zap from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 This is correct you don't want to install, you want to upgrade: rpm -Uvh mysql* (or rpm -Fvh mysql* if you only want to update the packages you have installed) -- Trond Eivind Glomsrød Red Hat, Inc. - 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
problems with MySQL GUI
Hi: Im using Windows 2000, and Im having problems with MySQL GUI. It works intermittently. Sometimes it just closes out for no apparent reason. Sometimes it will not let a known good user log in. Sometimes it will let a known good user log in, but then will not let that user create a database, and then the next time you try it will let the same user create with no problems. Arnie
Re: Got timeout reading communication packets
Sorry to suggest this but is it just possible that the 'data' object you are doing a strlen on is not null terminated or in fact contains earlier null characters which are terminating your effort. I have made this mistake several times when using mysql_escape_string. Now to avoid it I just use pointer arithmetic. Seth Northrop wrote: You are possibly not escaping binary fields. You should use mysql_escape_string() function on binary objects prior to inserting it in the INSERT command, or use load_file() function. Thanks Sinisa for the reply! There really isn't any binary data.. and, we are calling mysql_escape_string.. here is the snippet of code: // START SNIP int state; unsigned int encoded_str_length = 0; MYSQL_RES *result; MYSQL_ROW row; char *sql, *escaped_data; escaped_data = new char[2*strlen(data)+1]; //required by mysql sql = new char[2*strlen(data)+600];// +1 encoded_str_length = mysql_escape_string(escaped_data,data,strlen(data)); sprintf(sql,%s%d%s%d%s%d%s%d%s%d%s%d%s%d%s%d%s%d%s%s%s, REPLACE into reflectivity.measurement_extended_data set content_typeID = ,content_typeID, , contentID = ,contentID, , arrayID = ,arrayID, , positionID = ,positionID, , testID = ,testID, , iteration = ,iteration, , test_locationID = ,test_locationID, , date_added = ,date_added, , added_by = ,added_by, , data = ',escaped_data,'); state = mysql_query(connection,sql); delete [ ] sql; delete [ ] escaped_data; if (state != 0) { Application-MessageBox(mysql_error(connection),NULL,MB_OK); return 0; } // END SNIP And, as I mentioned, if I do something like: bin/mysql -u -p database foo.sql where foo.sql contains the query checked for sanity the exact same result occurs. - 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
Recovery Problem
Hi All, I'm trying to recover data from a table after all rows in the table were accidentally deleted. I have looked at the .MYD file and all of the information still seems to be there, albeit, flagged as deleted (I assume). Is there any way to recover this information, and undelete it? and if so, How? I don't fancy the idea of having to type everything in again. Any help would be much appreciated. rgds, Paul Kelly. Software Architect TERMINAL FOUR Software Ltd. 1, Herbert Street, Dublin 2, Ireland. T: +353 1 2403110 F: +353 1 6615504 - 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
Recovery Problem
Hi All, sorry if this is duplicated... I'm trying to recover data from a table after all rows in the table were accidentally deleted. I have looked at the .MYD file and all of the information still seems to be there, albeit, flagged as deleted (I assume). Is there any way to recover this information, and undelete it? and if so, How? I don't fancy the idea of having to type everything in again. Any help would be much appreciated. rgds, Paul Kelly. Software Architect TERMINAL FOUR Software Ltd. 1, Herbert Street, Dublin 2, Ireland. T: +353 1 2403110 F: +353 1 6615504 - 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
DISTINCT AND NON DISTINCT
Hi All, I've been reading up on how to do joins on the mysql site. Is there not an inverse function for DISTINCT, so that I can pull out duplicate data as opposed to DISTINCT data...or will I have to get this information by using joins? Thanks very much for your help. Anna
RE: Recovery Problem
I have been told that once deleted you can not get the data back (can some one correct me)... Have you got all your update logs or binary logs? If you have you should be able to run the sql quires form there and so just recreate your data! This mite be stating the obvious but like any data base they has humane users backups are needed! I hope this help? Simon -Original Message- From: Paul Kelly [mailto:[EMAIL PROTECTED]] Sent: 25 June 2001 17:16 To: '[EMAIL PROTECTED]' Subject: Recovery Problem Hi All, sorry if this is duplicated... I'm trying to recover data from a table after all rows in the table were accidentally deleted. I have looked at the .MYD file and all of the information still seems to be there, albeit, flagged as deleted (I assume). Is there any way to recover this information, and undelete it? and if so, How? I don't fancy the idea of having to type everything in again. Any help would be much appreciated. rgds, Paul Kelly. Software Architect TERMINAL FOUR Software Ltd. 1, Herbert Street, Dublin 2, Ireland. T: +353 1 2403110 F: +353 1 6615504 - 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: MySQLGUI Issue
Marty Bell writes: I am new to MySQL and this may be more of a training issue on my part than a problem. I can not seem to get the 'edit table' or 'create table' function to work. Not sure if I don't know the sequence of things to do or what. Please advise. Regards Marty Bell * Marty Bell, P.E. 972.575.6032 [EMAIL PROTECTED] Well, you are right. One of these feautres is half finished and the other on TODO. But neiterh will be done as a new client is coming from MySQL named VCC. -- 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: problems with MySQL GUI
Arnie Miles writes: Hi: Im using Windows 2000, and Im having problems with MySQL GUI. It works intermittently. Sometimes it just closes out for no apparent reason. Sometimes it will not let a known good user log in. Sometimes it will let a known good user log in, but then will not let that user create a database, and then the next time you try it will let the same user create with no problems. Arnie Hi! I have never heard of a problem as the one you describe. MySQLGUI uses normal C API functions for the functions you describe and does not have a will of it's own on that matter. Are there any error messages. Click on the button in the lower left corner of the main window and see if there are any error messages. Also, please do not, that Save' button saves user profile permanently, while Apply button saves settings only in memory, iso epse, only while mysqlgui is running. -- 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: DISTINCT AND NON DISTINCT
On 6/25/01 9:10 AM, anna soobrattee [EMAIL PROTECTED] wrote: Hi All, I've been reading up on how to do joins on the mysql site. Is there not an inverse function for DISTINCT, so that I can pull out duplicate data as opposed to DISTINCT data...or will I have to get this information by using joins? Thanks very much for your help. Anna You could use 'group by' like so. x = value that is either distinct or not distinct: Select x, count(*) from table_where_x_is_in group by x having count(*)1; Hope that helps. (BTW, you can also combine fields, but they have to appear in the 'select' and in the 'group by' part. More in the really good manual). I hope that accomplishes what you wanted. Hannes - 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
I have downloaded the source file mysql-3.23.39.tar.gz But when I do gunzipmysql-3.23.39.tar.gz tar -xvf mysql-3.23.39.tar I get this eror message tar: Error exit delayed from previous errors after the tar is done Then I cd mysql-3.23.39 ./configure --prefix=/usr gmake I get this error gmake[2]: Leaving directory `/afs/fnal.gov/files/code/e875/general/mysql-3.23.39/readline' Making all in libmysql gmake[2]: Entering directory `/afs/fnal.gov/files/code/e875/general/mysql-3.23.39/libmysql' gmake[2]: *** No rule to make target `libmysql.c', needed by `libmysql.lo'. Stop. gmake[2]: Leaving directory `/afs/fnal.gov/files/code/e875/general/mysql-3.23.39/libmysql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/afs/fnal.gov/files/code/e875/general/mysql-3.23.39' gmake: *** [all-recursive-am] Error 2 Any ideas Thanks ED Edward Tetteh-Lartey ! [EMAIL PROTECTED] Research Associate! 979.845.3235 Texas AM University ! 4242 TAMU, College Station TX 77843-4242 - 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
I have downloaded the source file mysql-3.23.39.tar.gz But when I do gunzipmysql-3.23.39.tar.gz tar -xvf mysql-3.23.39.tar I get this eror message tar: Error exit delayed from previous errors after the tar is done Then I cd mysql-3.23.39 ./configure --prefix=/usr gmake I get this error gmake[2]: Leaving directory `/afs/fnal.gov/files/code/e875/general/mysql-3.23.39/readline' Making all in libmysql gmake[2]: Entering directory `/afs/fnal.gov/files/code/e875/general/mysql-3.23.39/libmysql' gmake[2]: *** No rule to make target `libmysql.c', needed by `libmysql.lo'. Stop. gmake[2]: Leaving directory `/afs/fnal.gov/files/code/e875/general/mysql-3.23.39/libmysql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/afs/fnal.gov/files/code/e875/general/mysql-3.23.39' gmake: *** [all-recursive-am] Error 2 Sounds like a corrupt download. Try downloading again with a differnet browser, or better yet use wget. destiney - (des-ti-ny) - n. 1. deity of all things html, 2. common internet addict, 3. lover of late 80's heavy metal music, 4. Activist for the terminally un-elite; see also - cool guy, des, mr. php... It's 4:00am, your web site is still up, why are you? http://phplinks.org/ http://destiney.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: Perl DBI Error 19 -solved
Just if somebody is interested: I solved the mystery with Error 19. All I needed to do was introducing a second statement handle for the update query. (BTW, the script runs probably faster using '$sth = $dbh-do' instead of '$sth = $dbh-prepare', followed by '$sth = $dbh-execute'). Hannes On 6/24/01 4:05 AM, Hannes Niedner [EMAIL PROTECTED] wrote: I am having trouble with DBI. I wrote a little script that should update fields in one table (uid_test) based on values in another table (merge). I updates one row and then dies with: os prompt: blah blah 1 1011877 101 Error during processing for table uid_test Error 19 (fetch() without execute()) The selected values (primary_id, other_id) are both INT(12) and so are the fields of the target table (superceded_by, uid_new). Please have a look at the Perl code snippet below. As I said it works for the first row. BTW if there is pure sql code that would do the job, I would be delighted to learn about. Thanks Hannes -snippet- #issue query $sth = $dbh-prepare ( SELECT primary_id, other_id FROM merge ORDER BY other_id ) or bail_out (Cannot prepare query from merge); $sth-execute () or bail_out (Cannot execute query from merge); while (@ary = $sth-fetchrow_array ()) { $counter++; my ($primary_id) = $ary[0]; my ($other_id) = $ary[1]; print $counter\t$primary_id\t$other_id\n; #update the data in the target table $sth = $dbh-prepare ( UPDATE $table_name SET superceded_by=$primary_id, status=\'1\', time=null WHERE uid_new=$other_id ) or bail_out (Cannot prepare sql (UPDATE $table_name)!); $sth-execute () or bail_out (Cannot execute sql(UPDATE $table_name)!); } if (!defined($DBI::err)) { print $counter sequences retrieved from table merge, cleaned out and successfully updated in table niedner.$table_name.\n; }else {bail_out (Error during processing for table $table_name\n); } #clean up $sth-finish () or bail_out (Cannot finish query from database); $dbh-disconnect () or bail_out (Cannot disconnect from database); exit (0) --snippet end - 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
FLOAT bug
In doc '21.19 Solving Problems with No Matching Rows' item 5 states. 5.If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you can't use =! This problem is common in most computer languages because floating-point values are not exact values: mysql SELECT * FROM table_name WHERE float_column=3.5; - mysql SELECT * FROM table_name WHERE float_column between 3.45 and 3.55; In most cases, changing the FLOAT to a DOUBLE will fix this! This is just plain wrong. Floating point values are precise and since the advent of the IEEE standard are generally the same across platforms. The following example fails and is a bug not a problem with the language or the hardware. CREATE TABLE bug1 ( floatType float default NULL ) TYPE=MyISAM; DESCRIBE bug1; INSERT INTO bug1 VALUES (0.0); INSERT INTO bug1 VALUES (1.0); INSERT INTO bug1 VALUES (1.23); INSERT INTO bug1 VALUES (1.5); SELECT * FROM bug1 ; SELECT * FROM bug1 WHERE floatType=0.0 ; SELECT * FROM bug1 WHERE floatType=1.0 ; SELECT * FROM bug1 WHERE floatType=1.23 ; /* no record returned */ SELECT * FROM bug1 WHERE floatType=1.5 ; (The above test was run with an HP client and sever, I haven't run other combinations) There are three possible source for the error. 1) The hardware if a floating point processor is being used (not very likely). 2) The OS encode/decode statement if no fpp is being used (I've seen this problem in the past but it is not very likely today). 3) Encode/decode routines used within MySQL. I don't know the design of MySQL so I don't know if this is possible but if and attempt is made to standardize the bit pattern stored on disk for float values then it is the most likely cause of the problem. BTW: The solution proposed in the documentation is completely unacceptable when you are trying to update a record based on its value. If you used the suggested procedure then you would update all the records between 3.45 and 3.55 which is not acceptable. Regards, Tom Krehbiel - 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
Triggers or calculations in the future for MySQL?
Hi... The only cause that I´m on this list is because Blueworld is makeing Lasso Professional 5 with built in MySQL database server. Because I am a Mac person I´m used to the powers of text string calculation in Filemaker pro. The information I have got, tells me that MySQL does not have triggers built in for the same purpose. Is this true? if I have three comlumns in my MySQL_DB: first_name, sur_name, age. I need to have a fourth column that is a concatenated version of this: My name is Mika Sjøman and my age is 21 And I need it automatically to be done by the database server. Is this possible in MySQL? If there arn´t - please make a support for triggers. Warm hugs from the MacOS X community to the DW team of MySQL! Kind regards Mika Sjøman - 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
Couldn't select database
Hi Jake, Your problem appears similar to a problem I had but... you aren't providing quite enough information.. Are you working as a user on the same local host or are connecting across a network? To eliminate a MySQL problem ( so you can concentrate your efforts on PHP code) try to connect directly from the command line with MySQL as follows.. #root$ mysql yourdatabasename -h hostname -u username -p password You can eliminate -h and -p if your on the same machine without password. See if this will connect.. BOb T - 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
Error 46
To install MySQL :: I downloaded mysql-3.23.39-hp-hpux11.00-hppa2.0w.tar.gz. I did unzip, I have changed $MYSQL path from mysql-3.23.39-hp-hpux11.00-hppa2.0w/bin/mysqlaccess file. I ran scripts/mysql_install_db command I started database using bin/safe_mysqld Then I got the below output : --- [2] 27887 [sechp1 256%]Starting mysqld daemon with databases from /nfs/acadia/home/lm/mysql/mysql-3.23.39-hp-hpux11.00-hppa2.0w/data Pid 27894 killed due to text modification or page I/O error 010625 14:37:50 mysqld ended - In error log file I found the following -- 010625 14:44:08 mysqld started 010625 14:44:08 /nfs/acadia/home/lm/mysql/mysql-3.23.39-hp-hpux11.00-hppa2.0w/bin/mysqld: Can't lock file (errno: 46) 010625 14:44:08 /nfs/acadia/home/lm/mysql/mysql-3.23.39-hp-hpux11.00-hppa2.0w/bin/mysqld: Normal shutdown 010625 14:44:08 mysqld ended --- Would anyone please tell me what this error 46 is? - 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 Presentation Peer Review?
MySQL folks, I'm going to be giving a MySQL Server and Application Performance Tuning presentation at the O'Reilly Open Source Convention in July. http://conferences.ora.com/oscon/ If anyone has the time and interest, I'd appreciate it if you could look over the slides I've prepared and see if I've said anything stupid, missed information, etc. It wouldn't take more than about 10 minutes of time, I think. Since MySQL is very community drives, I figure that it only makes sense to harness our collective knowledge a bit more. I certainly don't have any sort of proprietary knowledge hidden away... I'm just trying to help other folks with the same struggles that many of us have been through. So the more input, the better off we are. And, of course, I'll put you in the credits. If you're interested, please mail me privately and I'll get you the URL and try to set your expectations a bit. :-) As a side note, I'm doing another presentation on a MySQL topic (roughly on the topic of Building a Perl API for fault-tolerant MySQL/Perl applications) later on this year. I don't have slides yet, but if you'd like to look at them when they're done and tell me what I'm missing, I'd appreciate the help. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 9 days, processed 69,664,068 queries (84/sec. avg) - 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
Lat/Long storage?
I need to store latitude and longitude in a MySQL table. It needs to allow human entry. Do you have a preferred storage technique for these numbers? Nelson Goforth -- - 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: Lat/Long storage?
mysql desc zipcodes; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(10) unsigned | | PRI | NULL| auto_increment | | zipcode | char(5) | | MUL | 0 || | latitude | double(6,4) | YES | | NULL|| | longitude | double(6,4) | YES | | NULL|| +---+--+--+-+-++ works ok for me.. -Original Message- From: Nelson Goforth [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 4:03 PM To: [EMAIL PROTECTED] Subject: Lat/Long storage? I need to store latitude and longitude in a MySQL table. It needs to allow human entry. Do you have a preferred storage technique for these numbers? Nelson Goforth -- - 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
general user Q
Hi, I'm a user of MySQL and I'm wondering if there's a page somewhere that lists and describes the general basic commands in SQL. I'm particularly interested in finding out if there's a copy command so I don't have to use the insert command to create large records (with about 25 fields...). Thanks. - 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
SQL Commands - DJW
HI Everyone I am looking for a summary/examples of the syntaxes and operators one may use in standard sql statements For example select name from epm_tble where name like 'abc%' select x, count(*) from table_where_x_is_in group by x having count(*)1; Regards Danie Weideman - 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
I Think I Need ' H E L P' on table's privileges
HI: I need some help on table's privileges, I've read the manual but still don't get it working. Background: I'm working on a windows program which needs to connect to a MySQL database on a linux server using MyODBC32. I've installed and configured MyODBC and MySql as follows: Supposing my linux server has the IP address 192.168.3.1 , my windows client has the IP address 192.168.3.2 and ODBC32 (on windwos client) has the following parameters under User DSN tab: Driver: MySQL WindowsDSN: linuxsvr MySQL host: 192.168.3.1 MySQL database name: water After Installing MySQL on linux I set it up like this: #Installing the grant tables ./scripts/mysql_install_db #Starting daemon ./safe_mysqld --user=mysql #Setting root password ./mysqladmin -u root password hello #Creating database .-mysqladmin -u root -phello create water #grant all privileges to a user called mortz conected from any node ./mysql -u root -pwater mysqlgrant all privileges on water.* to mortz@'%' identified by 'hello' with grant option; This way didn't work, whenever I try to connect from my windows program, after the login prompt from MyODBC a message appears telling me access denied for user mortz. I tried this way too: mysqlgrant all privileges on water.* to mortz@'192.168.3.0/255.255.255.0' identified by 'hello' with grant option; but still doesn't work After I tried to connect from the linux server using the client and same user mortz: ./mysql -u mortz -phello water and I did connect, it means the local privileges are OK but I can't connect from outside. I know there are no tables in the database water but that's precicely what I want because I'm creating a program which uploads data (and tables) from dbase4 to MySQL how ever I can't even create tables if I don't get access first... Any help would be appreciated... Rodrigo Morteo Ortiz - 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
Modifiying values in table_a with values from table_b
What I want to do is not overly complicated (and it works the way I did it) but I want to find out if it can be done easily using MySQL only. Table_a: col1, col2, col3 Table_b: col1, col2, col3 Currently, to replace values in col1 in Table_a with values of col2 in Table_b, I do the following: while read col1 col2; do echo col1 echo col2 # so I can see what's happening mysql -uuser -ppassword database eof UPDATE Table_a SET col1 = $col2 WHERE Table_a.col2 = $col1 eof done Table_b # data from comma delimited file (exported) I hope that you can see what I am trying to do. I tried to do the same thing prior to importing it into MySQL but gave it up. It was simply too long to go over two WHILE loops with 1600 and 95000 records respectively. So now, I have this kludge where I have glued shell script with MySQL. How could I accomplish the same in MySQL alone? Thanks in advance. -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - 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: SQL Commands - DJW
http://www.mysql.com/doc/ HI Everyone I am looking for a summary/examples of the syntaxes and operators one may use in standard sql statements For example select name from epm_tble where name like 'abc%' select x, count(*) from table_where_x_is_in group by x having count(*)1; - 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: Got timeout reading communication packets
Seth Northrop writes: 010624 19:44:23 Aborted connection 231 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) The above only implies that your program exited without calling mysql_close(). Nothing to do with your problem. But, as I told you , you did not quote string constants. And shoot out your resulting string to some file for inspection. That might help you find your error. Recently, we had exactly that error *a lot* .. in the end it was caused by a dodgy 100 MHz switch. Fixed the hardware, the problem went away. Paul Wilson iiNet Ltd - 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
Sub-selects in a insert statement - is it possible to rewrite?
As I've understood it mysql doesn't support sub-selects inside for example insert statements (apart from inset ... select). Background-stuff: What I'm working on is parsing logfiles and inserting them into a mysql database through the C API, to minimize traffic and to maximize time, I was hoping I could get away with a single insert query instead of having to do a select and then use that information to form a insert. This is how I'd like the query to work: insert into host (host_id, host_IP) values ((select from mail mail_id where mail_addr = [EMAIL PROTECTED]), '127.0.0.1') The table host has columns: email, host, host_id where host_id would be used as a forreign key in a table with the actual log entries in. Is it possible to do this in a single INSERT or would I have to use a select and then a separate insert? I'm open for any suggestions (and no the host columns shouldn't be normalized into the table with the log entries as that would be a table with 200k+ rows, and I'd prefer to have hosts in a separate table to make it easier to present a list of hosts that have logged something without doing queries on the much bigger log table). Cheers, -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. - 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
Connect to remote mySQL server
How can I connect to remote mySQL through ODBC using internet? I notice that ODBC ask for IP address or host name, can I use my IP address of my remote host and connect through internet? Thanks ST Ooi Malaysia - 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: Sub-selects in a insert statement - is it possible to rewrite?
This is how I'd like the query to work: insert into host (host_id, host_IP) values ((select from mail mail_id where mail_addr = [EMAIL PROTECTED]), '127.0.0.1') Try: insert into host (host_id, host_IP) select mail_id, '127.0.0.1' from mail where mail_addr = '[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
runnning my sql with windows98 and pws
is someone abble to tell me how can i do for running an sql database with windows98 without crashing my systeme? Also, using asp ( activex server page ), is it possible with mysql version3,23?
Question about mysql.sock.
database,sql,query,table,mysql The error message is : Connection failed Connection error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) my program is : #include stdlib.h #include stdio.h #include mysql.h int main(int argc, char *argv[]) { MYSQL my_connection; int res; mysql_init(my_connection); if (mysql_real_connect(my_connection, localhost,monty, something, nvod, 0, NULL, 0)) { printf(Connection success\n); res = mysql_query(my_connection, insert into task_log(task_id,content) values(111,'c programing')); if (!res) { printf(Inserted %lu rows\n, (unsigned long)mysql_affected_rows(my_connection)); } else { fprintf(stderr, Insert error %d: s\n,mysql_errno(my_connection),mysql_error(my_connection)); } mysql_close(my_connection); } else { fprintf(stderr, Connection failed\n); if (mysql_errno(my_connection)) { fprintf(stderr, Connection error %d: %s\n,mysql_errno(my_connection),mysql_error(my_connection)); } } return EXIT_SUCCESS; } my machine is : red hat 6.0 mysql 3.23.32 I can use mysql -u monty -psomething to login . under dirctory of /var/lib/mysql/ srwxrwxrwx 1 mysqlmysql 0 Jun 23 19:51 mysql.sock under dirctory of /tmp -rwxrwxrwx 1 wz wz 0 Jun 25 09:39 mysql.sock Are these message is correct? how to fix it? Have somebody know? Thanks. eagle [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
Data Entry Forms
I've created a MySQL database and linked the tables to a MS Access front end so that I could build the data entry forms using MS Access. Is there a better way to create the data entry forms in a Windows environment without using Microsoft or proprietary solutions? What is are the most widely used methods for creating data entry forms for MySQL in a Windows environment? Regards, Steve == Stephen Reynolds [EMAIL PROTECTED] http://www.sreynolds.net - 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: Kylix with MySQL
The problem is that Kylix does not yet support libmysqlclient.so.10, only libmysqlclient.so.6. You only have to replace the client libs. I used the ones from 3.22.32 and they work fine. Kevin McBrearty ATG Automation Technologies Group Ltd. -Original Message- From: Bagi kos [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 6:07 AM To: [EMAIL PROTECTED] Subject: Kylix with MySQL Hi Everybody! I want to develop some database application under RedHat 7, with Kylix using MySql. I'm using MySql 3.23.38. It uses libmysql.10, default limbysql.6. Kylix native MySql driver cannot connect to MySql server on the same (neither localhost, nor IP) but MySql is Accessible from Windows/ODBC via network, and with the MySql Clients. Error: Invalid UserName/PassWord. Does anybody have some information how to solve the problem? I would use the highest MySql Version. I heard somewhere that Kylix supports libmysql.6 only. If that's the problem what is the highest MySql version using that lib. Shall I change the whole MySql installation or the libfile only? I would appreciate some help. regards Akos - 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: Data Entry Forms for MySql
Hello I often use an html editor to create forms, use PHP4 as a cgi and enter the data directly into MySql. This does not necessitate Microsoft, and has worked very well for me. -warren - Original Message - From: Stephen Reynolds [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 25, 2001 8:24 PM Subject: Data Entry Forms I've created a MySQL database and linked the tables to a MS Access front end so that I could build the data entry forms using MS Access. Is there a better way to create the data entry forms in a Windows environment without using Microsoft or proprietary solutions? What is are the most widely used methods for creating data entry forms for MySQL in a Windows environment? Regards, Steve == Stephen Reynolds - 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: Data Entry Forms
You have several options, a few of the more common solutions include: C, C++, Delphi, Perl, PHP, HTML, CGI, etc... Simple data entry forms can often be easily implemented using a web-based solution (which also simplifies deployment)... On Tue, 26 Jun 2001, Stephen Reynolds wrote: I've created a MySQL database and linked the tables to a MS Access front end so that I could build the data entry forms using MS Access. Is there a better way to create the data entry forms in a Windows environment without using Microsoft or proprietary solutions? What is are the most widely used methods for creating data entry forms for MySQL in a Windows environment? Regards, 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
HP-UX 10.20 and MySQL
Is there some kind soul out there that can email me a tarball og the MySQL module for an HP-UX machine? I've tried to compile the module - but it says that I have to compile MySQL with +z or +Z, gcc doesn't have a +z or +Z ( and mysql should be compiled with gcc ) but it does have an -fPIC and -FPIC, which matters all the same to the compilation of the MySQL module: The error is: LD_RUN_PATH=/opt/mysql/lib:/lib/pa1.1 ld -o ./blib/arch/auto/DBD/mysql/mysql.sl -b -L/usr/local/lib dbdimp.o mysql.o -L/opt/mysql/lib-L/opt/mysql/lib -lmysqlclient -lm ld: DP relative code in file /opt/mysql/lib/libmysqlclient.a(libmysql.o) - shared library must be position independent. Use +z or +Z to recompile. *** Error exit code 1 Stop. *** Error exit code 1 Stop. Can somebody email me the compiled module? Correct me if I'm wrong? A uname -a gives: HP-UX host B.10.20 C 9000/879 20902531 2-user license Best Regards Harry Varvarigos Project Management Integration Siemens Limited 885 Mountain Hwy Bayswater, 3153 Victoria, Australia. Ph: 0417 318 246 Fax: 03 9721 2633 [EMAIL PROTECTED] CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Siemens Ltd., ABN 98004347880, or Siemens (NZ) Limited immediately. - 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