about hostnames after setup of MySQL
Mac OS XS 10.2 when you install the OS you have the oppt'y to put in a machine name (not the AppleTalk, Sharing name). i almost always put in a name. that name (mbase), it is also my default web host; that name also shows up at my terminal prompt (instead of the usual localhost). if i look under Machines in NetInfoMgr., it will only show localhost, but fine, everything works fine. however, when i setup MySQL, if i select browse, using phpMyAdmin, on the mysql db, user table, (see link), i can see localhost and mbase once each for each instance. while i believe this isn't hurting anything, i'd like to understand it and i'd also like to know if some of them can be deleted (using the the 'delete' link shown)? that is, how they got created [why]? and are any redundant? you can see an image of what i refer to at: http://mbase.shacknet.nu the image is exactly as it was created by my system/mysql. thanks in advance, Ted p.s. i could (and have to some degree) read and read the documentation for MySQL and phpMyAdmin (and Apache) and it seems to be taking me YEARS to understand what many of you must realize as fairly simple (no offense ;) :( - 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
function as default value
Hi, Can anybody tell me is it possible in the my sql to set the function as default value, for example can i set the now() function for the date column field. Thanks in advance. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court DLF phase IV Gurgaon, India Ph# 91-124-6392896/7 (O) Mobile# 91-9811294209 - 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: A rookie question
--- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: Paul Romanic [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 03:53 To: [EMAIL PROTECTED] Subject: A rookie question Hello, and apologies for such a novice question... we were all there once :) I have a need to find a method to allow a user to update information on members of our organization. The typical number of students' info that needs updated is 50-75. The info to be updated is grade change, and year of Latin change for each student. My initial thought (if I transfer the database to MySQL from FileMaker) is to set up the database as a relational database with students in one table, the schools in a second and the school name being the link. The real question is...if I use PHP to access MySQL, can I allow the user to edit the records (or portion of them) from one Web page with ONE submit button? Is this even possible? I want know I could do this with a submit button for each member, but that would not be too end user friendly! yes my usual approach is to have the form fields labelled so they return an array. You then work through the array in the script that you post to, updating one record at a time. You may find examples out there, http://www.phpbuilder.com is good source. If you need any more information email me offlist and I will send some sample code. HTH Peter Thanks for putting up with a novice question, and any help you can offer! Paul J. Paul Romanic, R.A. State Chair Ohio Junior Classical League - 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: Question about HEAP tables
From: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 13:41:23 +0800 (WST) I've got a problem with HEAP tables (undoubtedly the way that I'm using them). I'm running MySQL v.3.23.51 under Debian Linux with a 2.4.17 kernel. If anyone can help clear some of the fog, I'd appreciate it !! I've just spent some time trying HEAP tables to see if they speed up my prime application. Surprisingly, they do not. While HEAP tables are in memory, the disk buffering for MyISAM tables in Linux 2.4 works so well that MyISAM consistantly was about 1.4 times faster. It may be an artifact of the table storage system here, I keep a big archive and pull blocks out. Those blocks are entered daily, so the archive tends to keep the block data together. Pulling out a block into a HEAP table isn't faster than reading the archive because the archive's block is in the linux disk buffer now. Pulling a block into a MyISAM table is faster that reading the archive. So if you've chosen HEAP tables because they might be faster, it may be worth it to check that belief. -- mysql, query - 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: How to file a bug: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command.
Hi, I have now been able to solve this problem. I used MySQL 3.23, but when I installed MySQL 4.0.3 it worked fine. Great Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] Hi How do I file a bug for mysql for Windows NT/2000/XP. Problem: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command. e.g. mysqld-nt --datadir=c:\Program Files\mysql\data Is not possible, nor is mysqld-nt --datadir=c:\Program Files\mysql\data Using the ~1 yielding c:\Progra~1\mysql\data is not an option, nor is using the my.ini file. The reason is that I am installing mysql db for my application only, and if there are other mysql db's installed then it will be ambiguos on how to use the my.ini file, as it is shared by all installations of mysql. I can not use the ~1, ~2 ... Cause I will not on before hand, at installation time, know which one to choose. Lets say there are two directories c:\Program Files Old\ and c:\Program Files\ then these would be translated into c:\Program~1 and c:\Program~2, how could an installer know which one to choose? It can't therefore this solution is not an option either. Please help me out here. Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 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: Is MySQL server running OK?
DeNewbie, Sunday, September 29, 2002, 12:46:29 AM, you wrote: D I am a newbie and I have just recently installed MySQL. I am somewhat confused as to why the tests that I am running from my command prompt are not showing any results yet I believe that my MySQL D server is running; D mike@cords-orj86jfje:~ cd /usr/bin D mike@cords-orj86jfje:/usr/bin su - D Password: D cords-orj86jfje:~ # safe_mysqld D [1] 1033 D cords-orj86jfje:~ # Starting mysqld daemon with databases from /var/lib/mysql D mysqladmin version D cords-orj86jfje:~ # mysqlshow D mysqlshow: Access denied for user: 'root@localhost' (Using password: NO) D cords-orj86jfje:~ # mysqladmin version D cords-orj86jfje:~ # mysqlshow D mysqlshow: Access denied for user: 'root@localhost' (Using password: NO) D cords-orj86jfje:~ # mysqlshow mysql D mysqlshow: Access denied for user: 'root@localhost' (Using password: NO) D cords-orj86jfje:~ # D What is exactly going on? It's described here: http://www.mysql.com/doc/en/Access_denied.html Did you have MySQL server installed before? Or did you set up password for user 'root'? If you forgot 'root' password, check the following link: http://www.mysql.com/doc/en/Resetting_permissions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 server won't keep running
David, Monday, September 30, 2002, 4:44:19 AM, you wrote: DG I am attempting to use mysql 3.23.52 on win2000pro. I have installed DG it and I believe everything went okay for that. At least I did get any DG errors. DG When I open services, mysql is set for automatic but it is not DG started. When I try to start it, I get an error 1067: the process terminated DG unexpectedly. I have tried the command line also. I CD to mysql\bin and run DG mysqld. I don't get any errors. Then I run mysql and get and error 2003: DG can't connect to mysql server on localhost (10061). David, start MySQL server from DOS prompt as mysqld --standalone --console It shows you error messages in console. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: function as default value
Daya, Friday, September 28, 2001, 10:36:30 AM, you wrote: DKD Can anybody tell me is it possible in the my sql to set the function as DKD default value, for example can i set the now() function for the date column DKD field. No, you can't: http://www.mysql.com/doc/en/CREATE_TABLE.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Mysqld always shuts down after running mysqld
mailto, Friday, September 27, 2002, 8:52:25 PM, you wrote: majdd i am a mysql newbie (my first time i install it) majdd i give up, i can't solve the problem without help. majdd all the time i try to start the mysqld, it ends up instantly with a shutdown majdd of mysqld, i cant run the prog: i edited the mysqld.log and tried to figure majdd out the problem, here it is: '/usr/local/mysql/data/kolumbus.pid' (Errcode: 13) 020927 18:39:01 /usr/local/mysql/bin/mysqld: Can't find file: majdd './mysql/host.frm' (errno: 13) 020927 18:39:01 /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mysql/data/kolumbus.pid' (Errcode: 13) 020927 18:39:01 mysqld ended majdd i looked for the files kolumbus.pid and didn't found one (find / -name majdd kolumbus.pid) majdd at the whole system. the host.frm is in the right pass. majdd in addition the message after runnung mysqld via config module: $ perror 13 Error code 13: Permission denied It means that mysql doesn't have permissions on the /usr/local/mysql/data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 a quotas?
Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You can do it using disk quotas. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Replication question
Alexander, Saturday, September 28, 2002, 12:47:19 PM, you wrote: AS Is it feasible to use replication to keep the database which powers my AS website up-to-date? The database itself is on the hosting companies server AS and contacted via dialup so the connection isn't there all of the time. AS Naturally I keep a copy of the database on my local machine too. If you use replication you don't need to be connected all the time: http://www.mysql.com/doc/en/Replication_FAQ.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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.sock mystery!
ÀÌö¿ì(õ¸®¾È), Saturday, September 28, 2002, 9:42:24 AM, you wrote: Àà I'm new to MySQL. Àà Anyway... Àà My O/S is FreeBSD 4.6. Àà In /etc/hosts there are only two line. Àà 127.0.0.1localhostlocalhost.paldal.com Àà 192.168.0.88unix.paldal.comunix Àà And in /etc/host.conf, Àà first seek : /etc/hosts Àà second seek : bind [skip] Àà Warning: Can't connect to local MySQL server through socket Àà '/usr/local/mysql/var/mysql.sock' (13) in /usr/home/lee/htdocs/index.php on line Àà 4 Àà Warning: MySQL Connection Failed: Can't connect to local MySQL server through Àà socket '/usr/local/mysql/var/mysql.sock' (13) in /usr/home/lee/htdocs/index.php Àà on line 4 Àà Couldn't connect to server. Error 13 means permission problems. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
[NEWBIE] Master Account
I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I can't find how I can login as a master to create users and give privileges ? Thanks. -- S.PINEL - 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 a quotas?
On Mon, 30 Sep 2002, Victoria Reznichenko wrote: Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You can do it using disk quotas. Just out of curiosity, how will the user know whether the disk was full (quota exceeded) or has other errors occurred when he/she, for example, inserts a row that doesn't fit into the quota? After reading the manual on full disk conditions, I got the picture that the inserting thread gets stuck, and checks for free space once in a minute. Does the user running the inserting thread get a specific error, others thatn a note in the error log? Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
cannot connect to local mysql server through socket
Hi, I am trying to set up a mail server using Postfix, Web-cyradm and mysql on SusE 8. I have followed all the steps in Luc de Louw's documentation so far and MySQL server is running. When I try to use the scripts that came with Web-Cyradm to create the databases and tables I get the folowing error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have checked that mysqld is running and I have moved the mysql.sock file from /tmp to /var/lib/mysql, checked ownership and permissions but still no luck. As you can probably tell, I am no database guy so please excuse if it is a real daft question. 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
re: DB Problems
Odhiambo, Saturday, September 28, 2002, 9:05:00 AM, you wrote: OW I have some problems with my database and not being quite profficient in SQL, OW I did myisamcheck and posted the data on the site below: OW http://ns2.wananchi.com/~wash/RT2/myisamcheck.txt OW I am wondering if someone can take a look and possibly tell me if they notice OW a problem and what I can do to fix that problem. Look at the manual: http://www.mysql.com/doc/en/Table-info.html You can find description of the output here. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: [NEWBIE] Master Account
Stéphane, Monday, September 30, 2002, 2:34:17 PM, you wrote: SP I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I SP can't find how I can login as a master to create users and give privileges ? It's not so difficult. You should connect to the MySQL server as root: http://www.mysql.com/doc/en/Connecting.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: cannot connect to local mysql server through socket
Lawrence, Monday, September 30, 2002, 2:47:44 PM, you wrote: LS I am trying to set up a mail server using Postfix, Web-cyradm and mysql LS on SusE 8. I have followed all the steps in Luc de Louw's documentation LS so far and MySQL server is running. When I try to use the scripts that LS came with Web-Cyradm to create the databases and tables I get the LS folowing error: LS ERROR 2002: Can't connect to local MySQL server through socket LS '/var/lib/mysql/mysql.sock' (2) LS I have checked that mysqld is running and I have moved the mysql.sock LS file from /tmp to /var/lib/mysql, checked ownership and permissions but LS still no luck. LS As you can probably tell, I am no database guy so please excuse if it is LS a real daft question. You shouldn't move mysql.sock file. You can just set up path to the socket file in the my.cnf or with --socket option of mysqld. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Japanese Charset
Joel Rees wrote: If I compile MySQL using --with-charset=sjis , how will it handle the Latin, Chinese, and Korean characters? Multiple databases on multiple servers? Try this one on for size: CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it can store them all in Customers? You use Unicode with a binary field and do post-processing work (like ORDER BY) yourself. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: [bug] koi8-r codepage bug
Victoria Reznichenko wrote: Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses latin1 character set and you have compiled only with koi8_ru. but if compile MySQL with ./configure --with-charset=koi8_ru --with-extra-charsets=all check (make; make check; make test) failed too! That's right? CZ But if I build mysql with CZ ./configure --with-extra-charsets=all CZ and then insert in /etc/my.cfg before mysqld start this strings: CZ ---cut--- CZ [mysqld] CZ character-sets-dir=/usr/share/mysql/charsets/ CZ default-character-set=koi8_ru CZ ---cut--- CZ then all OK and query INSERT INTO COUNTRIES VALUES ('éÓÌÁÎÄÉÑ') not fail! That's right. - 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: How to see warning messages for load data infile
David, Saturday, September 28, 2002, 2:37:00 AM, you wrote: DY Hi all. I'm trying to load a file into mysql using load data infile and DY got a ton of warnings. Is there any way to see what the warnings are? MySQL doesn't store warnings anywhere. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
FileMaker Pro Schema Export?
Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - 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: Replication question
That would be a great way to keep your website up to date. The slave can handle loss of connection (though some data may not make sense if part of it is missing), and resume where it has left of previously. Or you could also manually start and stop the slave process when you know there is a live connection. As long as you are not modifying the slave database, that could cause problems. Some people have successfully looped thier replication process (A-B, B-A), which I know nothing about. I am assuming you want to have the hosting companies server replicate from your local copy of the database? If that is the case, starting and stopping the slave process is not really an option (unless you have your own install of mysql). And of course if you do not have a static IP address it would be a real pain in the behind ( since your hosting company will probably be the one changing the slave access, unless of course you have your own install ) Good luck Luc -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 28, 2002 5:47 AM To: MySQL List Subject: Replication question Hi Is it feasible to use replication to keep the database which powers my website up-to-date? The database itself is on the hosting companies server and contacted via dialup so the connection isn't there all of the time. Naturally I keep a copy of the database on my local machine too. Alex Alexander Shaw Agricultural Stock and Assignment Photography www.Agri-Image.com sql query - 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: Re: [bug] koi8-r codepage bug
Cyril, Monday, September 30, 2002, 3:35:40 PM, you wrote: Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses latin1 character set and you have compiled only with koi8_ru. CZ but if compile MySQL with CZ ./configure --with-charset=koi8_ru --with-extra-charsets=all CZ check (make; make check; make test) failed too! CZ That's right? The short answer - nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Database Replication
-Original Message- From: Paul Darius [mailto:[EMAIL PROTECTED]] Subject: Database Replication 'lock database with read lock' command already done before the above replication started and followed by 'unlock all' when finished. Question, how to sync an unsync table or the whole database again ? I am not quite sure what your replication process entails, but I am not sure that its what I call replication. What you are describing just sounds not suite right to me. Check this link out. http://www.mysql.com/doc/search.php?q=replicationfrom=%2Fdoc%2Fen%2Findex.html - 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 : How to see warning messages for load data infile
Maybe try one line... I got this tons of warnings this morning making an import from Excel. But it was apparently successful...but all decimal value where store truncated like 128.00 , the reason is I'm in France and Excel exports decimal with coma 128,34 but MySQL expects 128.34 so I just replace all , with . in my CSV file with Ultraedit. Greetings, JM -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: re: How to see warning messages for load data infile David, Saturday, September 28, 2002, 2:37:00 AM, you wrote: DY Hi all. I'm trying to load a file into mysql using load data DY infile and got a ton of warnings. Is there any way to see what the DY warnings are? MySQL doesn't store warnings anywhere. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Setting Permission For Column Level Only
You know that process would be much easier if you used the GRANT syntax http://www.mysql.com/doc/search.php?q=GRANTfrom=%2Fdoc%2Fen%2Findex.html -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Subject: Setting Permission For Column Level Only Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered some rows in the Columns_Priv table. Now my question is - Do I have to enter records in db and tables_priv table with the user name and all privileges set to N or default to make the column privileges work or if I enter a row in the columns_priv table, that will do. Rgds Insane - 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: re: MySQL a quotas?
Iikka, Monday, September 30, 2002, 2:40:32 PM, you wrote: Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You can do it using disk quotas. IM Just out of curiosity, how will the user know whether the disk was full (quota IM exceeded) or has other errors occurred when he/she, for example, inserts a row IM that doesn't fit into the quota? After reading the manual on full disk IM conditions, I got the picture that the inserting thread gets stuck, and checks IM for free space once in a minute. Does the user running the inserting thread IM get a specific error, others thatn a note in the error log? User will get error 28: No space left on device. It's not a so good decision and not suitable if database contains InnoDB tables, but you can't limit database size only with MySQL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: A FAQ type question, but not in the FAQ - How to change my hostname,but not make replication puke
Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started 020927 10:15:59 Could not find target log during relay log initialization 020927 10:15:59 Warning: Can't create threads to handle slave /usr/local/mysql/libexec/mysqld: ready for connections 020927 10:16:15 Could not find target log during relay log initialization and I got a 'check permissions on master.info' sort of error when I tried to run 'slave start' I see that error was related to a bug from a long time ago, but I am running 4.0.2 so I doubt that it is a bug issue. Thanks, Eric Leading Edge Marketing Inc. 250-360-2992 - 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: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke
Hi, I didn't have a new mysql master, just the slave name was changed. Yes on the second question too. Thanks, Eric At 09:09 AM 9/30/02 -0500, gerald_clark wrote: Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started 020927 10:15:59 Could not find target log during relay log initialization 020927 10:15:59 Warning: Can't create threads to handle slave /usr/local/mysql/libexec/mysqld: ready for connections 020927 10:16:15 Could not find target log during relay log initialization and I got a 'check permissions on master.info' sort of error when I tried to run 'slave start' I see that error was related to a bug from a long time ago, but I am running 4.0.2 so I doubt that it is a bug issue. Thanks, Eric Leading Edge Marketing Inc. 250-360-2992 - 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 http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) Inquiry is fatal to certainty. -- Will Durant - 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: [bug] koi8-r codepage bug
Victoria Reznichenko wrote: Cyril, Monday, September 30, 2002, 3:35:40 PM, you wrote: Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses latin1 character set and you have compiled only with koi8_ru. CZ but if compile MySQL with CZ ./configure --with-charset=koi8_ru --with-extra-charsets=all CZ check (make; make check; make test) failed too! CZ That's right? The short answer - nope. this is bug or feature? ---cut--- # make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases 020930 17:18:52 ../sql/mysqld: Shutdown Complete Installing Slave Databases 020930 17:18:52 ../sql/mysqld: Shutdown Complete Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias 0.07 0.02 0.12 [ pass ] alter_table 0.00 0.02 0.07 [ pass ] analyse 0.01 0.02 0.03 [ pass ] auto_increment0.03 0.01 0.05 [ pass ] backup0.02 0.02 0.04 [ pass ] bdb-crash 0.02 0.01 0.03 [ pass ] bdb-deadlock [ skipped ] bdb [ skipped ] bench_count_distinct 0.03 0.00 0.06 [ pass ] bigint0.03 0.00 0.03 [ pass ] binary [ fail ] Error at line 34: Result length mismatch Below are the diffs between actual and expected results: --- *** r/binary.result Wed Aug 14 01:24:51 2002 --- r/binary.reject Mon Sep 30 17:18:55 2002 *** *** 1,13 name - å ä ö concat(*,name,*) - *å* *ä* *ö* min(name) min(concat(*,name,*)) max(name) max(concat(*,name,*)) ! å *å* ö *ö* name ä å --- 1,13 name ä + å ö concat(*,name,*) *ä* + *å* *ö* min(name) min(concat(*,name,*)) max(name) max(concat(*,name,*)) ! ä *ä* ö *ö* name ä å *** *** 20,25 --- 20,26 ä *ä* ö *ö* name ä + å ö name ä --- Please follow the instructions outlined at http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished make: *** [test] Error 1 ---cut-- - 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 a quotas?
on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED] wrote: It's not a so good decision and not suitable if database contains InnoDB tables, but you can't limit database size only with MySQL. Is this a planned feature anywhere on the MySQL roadmap for 4.x? A database size quota? Thanks for the info! -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 XrackHosting.com - Mac OS X hosting on Apple's Xserve! http://www.xrackhosting.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: Storing 100 million images in the database
Mmm.. filter goodness. Trying again with the required words: sql query ... along the lines of using the database as a pointer to the real file in a normal filesystem that others have suggested.. may I add the idea of using a 'hashed' directory structure such that you don't end up with an obviously messy (and *very* slow) directory of files... unless # of inodes becomes an issue... something like /imageroot/e/x/a/m/example.jpg you could base it off filename, or the index number, or something along those lines.. as long as it's sufficiently random or distributed... -=| Ben - 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: Re: Re: Replication
CP, Monday, September 30, 2002, 3:48:31 AM, you wrote: C The Master's server id is 1 while the slave's server id was set to 5. There C is no problem for the slave to establish connection to the master. However, C the slave complains that error reading packet from server, the reason is C misconfigured-master, server id was not set and this messages keep on C repeating. Did you set up server-id for master from the very outset or you set up the one after master has been started? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Unknown auto ROLLBACK
Because you did not set autocommit on? Noor Dawod wrote: Hi all, I found out today that MySQL is adding a 'ROLLBACK' command to each session connecting to it, without explicitly ordering this. This is new since we never had this behavior before. Why is this happening, and how can I revert to the old beahvior (each command sent is carried out and performed instantly, with no rollback option.) Please CC me in your replies. Thanks in advance. Noor - 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: granting FILE privileges
+-+ | Grants for [EMAIL PROTECTED] | | +-+ | GRANT SELECT, FILE ON *.* TO 'username'@'host-name.domain' IDENTIFIED BY PASSWORD |'cryptedfooey'| | GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'host-name.domain' | | +-+ I had added the select,file permissions by hand to user. -- Mark P. Hennessy [EMAIL PROTECTED] On Mon, 30 Sep 2002, Victoria Reznichenko wrote: Date: Mon, 30 Sep 2002 13:53:01 +0300 From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: re: granting FILE privileges Mark, Saturday, September 28, 2002, 12:16:31 AM, you wrote: MH I keep trying to grant file privileges to a user, but no matter what I do, MH it seems that the customer keeps getting access denied errors. MH They are trying to execute the following: MH select * into outfile '/tmp/list.txt' fields terminated by | lines terminated by \n from list; MH ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) MH I have tried using GRANT and REVOKE to recreate the user with the correct MH priveleges. MH I have even tried giving their user universal FILE and SELECT privileges MH by hand by inserting them into the user table, and of course, flushing MH privileges, and no luck. MH Any ideas as to what settings could need to be changed? Possibly a MH restriction set at compile-time on users? Mark, could you please provide output of SHOW GRANTS for your user? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke
You need to grant privileges on the master to the new slave machine. Eric Frazier wrote: Hi, I didn't have a new mysql master, just the slave name was changed. Yes on the second question too. Thanks, Eric At 09:09 AM 9/30/02 -0500, gerald_clark wrote: Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started 020927 10:15:59 Could not find target log during relay log initialization 020927 10:15:59 Warning: Can't create threads to handle slave /usr/local/mysql/libexec/mysqld: ready for connections 020927 10:16:15 Could not find target log during relay log initialization and I got a 'check permissions on master.info' sort of error when I tried to run 'slave start' I see that error was related to a bug from a long time ago, but I am running 4.0.2 so I doubt that it is a bug issue. Thanks, Eric Leading Edge Marketing Inc. 250-360-2992 - 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 http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) Inquiry is fatal to certainty. -- Will Durant - 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
IFNULL || NULLIF
Does MySQL 3.23.39(version) support IFNULL(NULL,0) || NULLIF(0,NULL) Thanks, Gramos - 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: IFNULL || NULLIF
http://www.mysql.com/doc/en/Control_flow_functions.html top of the page -Original Message- From: Gramos Brestovci [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:47 AM To: [EMAIL PROTECTED] Subject: IFNULL || NULLIF Does MySQL 3.23.39(version) support IFNULL(NULL,0) || NULLIF(0,NULL) Thanks, Gramos - 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: Urgent!!
On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Doesn't do to badly with .jsp either. ? How do you intend to run .ASP on linux? Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: Urgent!!
William R. Mussatto wrote: On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Doesn't do to badly with .jsp either. ? How do you intend to run .ASP on linux? You should technically be able to use chillisoft on lin/unix. But it is a piece of junk, it will probably save you many headaches to spend the small amount of time it will take you to learn php. Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: Urgent!!
[.snip.] ? How do you intend to run .ASP on linux? [.snip.] Its called Sun ONE from SUN. http://www.chilisoft.com/ Dan -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:29 AM To: Insanely Great Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED] Subject: Re: Urgent!! On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Doesn't do to badly with .jsp either. ? How do you intend to run .ASP on linux? Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: Urgent!!
There is a package called Chilisoft that will let you take your ASP pages and change them to PHP, I am not sure how well it works. I had a client that want to run ASP on linux and told I didn't think you could but PHP works and to me is better. But the price of Chilisoft was a little hight. I think a round $500. But hey that my 2 Cents. Chuck Payne Magi -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:29 PM To: Insanely Great Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED] Subject: Re: Urgent!! On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Doesn't do to badly with .jsp either. ? How do you intend to run .ASP on linux? Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: about hostnames after setup of MySQL
On 9/30/2002 12:14 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Mac OS XS 10.2 when you install the OS you have the oppt'y to put in a machine name (not the AppleTalk, Sharing name). i almost always put in a name. that name (mbase), it is also my default web host; that name also shows up at my terminal prompt (instead of the usual localhost). if i look under Machines in NetInfoMgr., it will only show localhost, but fine, everything works fine. This section of NetInfo Manager is like the hosts file found in many other Unix flavors. It is used by DNS to find the IP address of a given host. If you want to add mbase you can. You can add any entry that you would normally add to the /etc/hosts file. however, when i setup MySQL, if i select browse, using phpMyAdmin, on the mysql db, user table, (see link), i can see localhost and mbase once each for each instance. while i believe this isn't hurting anything, i'd like to understand it and i'd also like to know if some of them can be deleted (using the the 'delete' link shown)? that is, how they got created [why]? and are any redundant? I am guessing that when the database was setup the software uses the hostname command to find the name of your system and adds an entry for this, as well as localhost. From a terminal prompt you can use the hostname command to see what the hostname has been set to. The hostname for an OS X system is set in the file /etc/hostconfig. As to if you need both entries, this depends on how you connect to the database. If you are connecting from localhost (127.0.0.1) only then you do not need the other entries. If you are going to connect from the IP address your system has, then you will need the other entry. you can see an image of what i refer to at: http://mbase.shacknet.nu the image is exactly as it was created by my system/mysql. thanks in advance, Ted p.s. i could (and have to some degree) read and read the documentation for MySQL and phpMyAdmin (and Apache) and it seems to be taking me YEARS to understand what many of you must realize as fairly simple (no offense ;) :( -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - 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
ASP Chilisoft (OT)
Chuck Payne wrote: There is a package called Chilisoft that will let you take your ASP pages and change them to PHP, I am not sure how well it works. I had a client that want to run ASP on linux and told I didn't think you could but PHP works and to me is better. But the price of Chilisoft was a little hight. I think a round $500. Chilisoft ASP runs ASP natively on Linux; there is a PHP2ASP project that does translation (and is free) but requires more user-intervention on the programmer's part. ... notspamperhaps with _QUERIES_ or _SQL_ stuff/notspam ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
Please confirm (conf#92c92eb943e40c0d6fb2262ddcc31bdc)
IMPORTANT INFORMATION! This is an automated message. The message you sent (attached below) requires confirmation before it can be delivered. To confirm that you sent the message below, just hit the Reply button and send this message back (you don't need to edit anything). Once this is done, no more confirmations will ne necessary. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMACION IMPORTANTE Este es un mensaje automatico. El mensaje que usted ha enviado (mostrado mas abajo) necesita su confirmacion antes de ser entregado. Para confirmar que usted ha enviado el mensaje, solo presione el boton de Reply y envie éste mensaje (no es necesario editar el mensaje). Una vez realizado esto, no se necesitarán mas confirmaciones. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMAÇÃO IMPORTANTE Esta é uma mensagem automática A mensagem que você enviou (em anexo) requer confirmação antes de ser entregue. Para confirmar o envio basta pressionar o botão de Reply e enviar esta mensagem de volta (não é necessário editar). Uma vez que isto seja feito, novas confirmações não serão necessárias. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- WICHTIGE INFORMATION Dies ist eine automatisch generierte Antwort. Ihre Mail (unten angehaengt) muss vor der Zustellung an mich explizit bestaetigt werden. Um dies zu tun, beantworten Sie einfach diese Mail mit der Antworten oder Reply-Funktion Ihres Mailprogramms. Es sind keine Aenderungen am Text noetig. Dies ist die einzige Bestaetigung die Sie je an mich senden muessen; Ihre weiteren Nachrichten werden automatisch akzeptiert. Diese Massnahme dient der Bekaempfung von Spam. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMATION IMPORTANTE Ceci est un message automatique. Le message que vous avez envoye (dessous) demande confirmation avant qu'il puisse etre envoye Pour confirmer que vous avez bien envoye le message ci-dessous, simplement appuyez sur la touche Reply, et renvoyez ce message (Vous n'avez pas besoin d'editer quoique ce soit). Une fois que ceci est fait, vous n'avez pas besoin d'autre confirmations. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMAZIONE IMPORTATE! Questo è un messaggio automatico. Il messaggio che hai spedito (allegato sotto) richiede una conferma prima che sia consegnato. Per confermare che sei tu che hai spedito il messaggio, basta cliccare il tasto Reply e rispedirlo nuovamente (non hai bisogno di scrivere nessuna altra informazione aggiuntiva). Fatto questo, nessuna altra conferma è richiesta. --- Original Message Follows --- Date: Mon, 30 Sep 2002 21:19:45 +0200 From: [EMAIL PROTECTED] To: Chuck Payne [EMAIL PROTECTED] Subject: Re: RE: Urgent!! 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: What I read last year what it change pages, but it cool to know. I will let my client know. -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:14 PM To: Chuck Payne Cc: William R. Mussatto; Insanely Great; Ibrahim Al-Tawil; [EMAIL PROTECTED] Subject: Re: Urgent!! Chuck Payne wrote: There is a package called Chilisoft that will let you take your ASP pages and change them to PHP, I am not sure how well it works. I had a client that want to run ASP on linux and told I didn't think you could but PHP works and to me is better. But the price of Chilisoft was a little hight. I think a round $500. Chilisoft ASP runs ASP natively on Linux; there is a PHP2ASP project that does translation (and is free) but requires more user-intervention on the programmer's part. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock This email account is protected by: Active Spam Killer (ASK) V2.0.2 - (C) 2001-2002 by Marco Paganini For more information, visit http://www.paganini.net/ask - 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: Urgent!!
Chuck, ChiliSoft ASP is actually a Linux port of ASP 3 (I think). On the whole we've found it to run OK but there are a few features that are not included in the more recent Microsoft releases. While it makes it easy for IIS users to port their sites to a Linux server I personally wouldn't depend on it. They've done a good job but it's not as good as it needs to be. PHP seems to offer a far easier way of working with a whole community behind the development of the language so we're moving over to PHP ourselves. My two pence... Dan Donald Reach Multimedia - Original Message - From: Chuck Payne [EMAIL PROTECTED] To: William R. Mussatto [EMAIL PROTECTED]; Insanely Great [EMAIL PROTECTED] Cc: Ibrahim Al-Tawil [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 30, 2002 6:03 PM Subject: RE: Urgent!! There is a package called Chilisoft that will let you take your ASP pages and change them to PHP, I am not sure how well it works. I had a client that want to run ASP on linux and told I didn't think you could but PHP works and to me is better. But the price of Chilisoft was a little hight. I think a round $500. But hey that my 2 Cents. Chuck Payne Magi -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:29 PM To: Insanely Great Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED] Subject: Re: Urgent!! On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Doesn't do to badly with .jsp either. ? How do you intend to run .ASP on linux? Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: Urgent!!
Its called Sun ONE from SUN. http://www.chilisoft.com/ Don't most people who use ASP want to use Visual Basic? So the problem isn't really lack of ASP on Linux but lack of VB. Somehow I doubt that Microsoft (at least in its current incarnation) is going to come out with VB for Linux. [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - 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: Win32 zipped binary seems corrupted
Hi, I've just tried to download the Win32 binaries of the MySQLGUI tool. I recieved about 50kB. When I tried to unpack the archive, WinCommander told me, that the zip archive is corrupted. Hope it helps, thanx guys for wonderfull MySQL. Pavel __ Reklama: E-mail zdarma na cely zivot: http://email.seznam.cz - 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
Mixing Linux and Windows and paying for it
Hi, I have a grand total of two very important but possibly humiliatingly daft questions, that I hope some kind soul will patiently solve: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows computer? 2. The licensing info seems only relevant to people who develop applications. I just want to use it as a repository for data, and then query it myself through such decidedly closed-source bastards as Excel and Access, but I'm doing this for profit. If I use mySQL for such a purpose, and not as a part of an application, do I then need to sell my boss a license? The morally correct answer is obvious to me, but I'd like to know what the demands of the mySQL company are: do I have more than one morally correct option? Thanks in advance Ps. Does the list software have an issue with Lotus Notes? --- Halldór Bjarki Christensen [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: Mixing Linux and Windows and paying for it
On Mon, 30 Sep 2002, Drulli B wrote: Date: Mon, 30 Sep 2002 18:13:51 - From: Drulli B [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Mixing Linux and Windows and paying for it Hi, I have a grand total of two very important but possibly humiliatingly daft questions, that I hope some kind soul will patiently solve: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows computer? Why not query it directly on its std port? What language are you using? Perl (including ISAPI version .plx) can use DBI and connect directly. 2. The licensing info seems only relevant to people who develop applications. I just want to use it as a repository for data, and then query it myself through such decidedly closed-source bastards as Excel and Access, but I'm doing this for profit. If I use mySQL for such a purpose, and not as a part of an application, do I then need to sell my boss a license? The morally correct answer is obvious to me, but I'd like to know what the demands of the mySQL company are: do I have more than one morally correct option? Thanks in advance Ps. Does the list software have an issue with Lotus Notes? --- Halldór Bjarki Christensen [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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: ASP Chilisoft (OT)
Ryan Fox wrote: I think you mean asp2php. I don't know any reason that someone would want to convert from php to asp. :) Thanks for that; I'm sure the clarification would be obvious to anyone reading the thread; my mind must have been fried from so much MFC programming today ... notspaminstead of SQL Queries/notspam. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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] Master Account
On Monday, September 30, 2002, at 04:34 24h, Stéphane Pinel wrote: I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I can't find how I can login as a master to create users and give privileges ? Thanks. With the server running you first need to give root a password by typing: mysqladmin -u root password 'password' Including the single quotes. Then to log in as root: mysql -uroot -p -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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
Testing New Install
I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running mysql_install_db and afterwards running the commands; /usr/bin/mysqladmin -u root password 'new-password' mysqladmin -u pazin1 sqlpass and; /usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' mysqladmin -u pazin1 -h hostpass After inputting these passwords as I was told by mysql_install_db was this absolutely necessary or did I make my life more difficult as a newbie. Anyway after doing that I followed more instructions from p.115 of my MySQL Reference manual written by Mr.Widenius. From your advice I was able to get some results for the mysqlshow command; I don't know where the test database came from I did not see it from the result in my Reference Manual; cords-orj86jfje:/usr/bin # mysqlshow -u pazin1 +---+ | Databases | +---+ | mysql | | test | +---+ cords-orj86jfje:/usr/bin # mysqlshow -u sqlpass +---+ | Databases | +---+ | mysql | | test | +---+ cords-orj86jfje:/usr/bin # mysqlshow -u hostpass +---+ | Databases | +---+ | mysql | | test | +---+ then when I enter what one person told me to enter I get this; cords-orj86jfje:/usr/bin # mysqlshow -u pazin1 -p sqlpass Enter password: mysqlshow: Access denied for user: 'pazin1@localhost' (Using password: YES) cords-orj86jfje:/usr/bin # (regardless of what password I entered I was continously kicked out) I would also like use the mysqladmin version command to see what pops up but I simply get no results no matter what I type in; cords-orj86jfje:/usr/bin # mysqladmin version cords-orj86jfje:/usr/bin # mysqladmin version -u hostpass cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 cords-orj86jfje:/usr/bin # mysqladmin version -u sqlpass cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 -p sqlpass I would also like to know how to shut down the mysql server,how do i do this, it does not seem to want to shut down; cords-orj86jfje:/usr/bin # mysqladmin -u pazin1 shutdown cords-orj86jfje:/usr/bin # safe_mysqld [1] 1404 cords-orj86jfje:/usr/bin # A mysqld process already exists Thanks, DeNewbie P.S. I am using SuSe Linux 7.3 and I am using the latest MySQL binary rpm downloads ver 3.23 . - 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: FileMaker Pro Schema Export?
I never actually looked into it. There are so many work arounds I need to do in FileMaker that I just redesign the tables in MySQL. If there isn't a FileMaker converter, I'm sure there is a DBF converter. You can just save you FileMaker databases as DBF and then convert them. On Monday, September 30, 2002, at 09:14 AM, Jan Steinman wrote: Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - 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- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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: Mixing Linux and Windows and paying for it
JMichael William R. Mussatto [EMAIL PROTECTED] 09/30/2002 02:23 PM To: Drulli B [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:Re: Mixing Linux and Windows and paying for it On Mon, 30 Sep 2002, Drulli B wrote: Date: Mon, 30 Sep 2002 18:13:51 - From: Drulli B [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Mixing Linux and Windows and paying for it Hi, I have a grand total of two very important but possibly humiliatingly daft questions, that I hope some kind soul will patiently solve: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows computer? Why not query it directly on its std port? What language are you using? Perl (including ISAPI version .plx) can use DBI and connect directly. 2. The licensing info seems only relevant to people who develop applications. I just want to use it as a repository for data, and then query it myself through such decidedly closed-source bastards as Excel and Access, but I'm doing this for profit. If I use mySQL for such a purpose, and not as a part of an application, do I then need to sell my boss a license? The morally correct answer is obvious to me, but I'd like to know what the demands of the mySQL company are: do I have more than one morally correct option? Thanks in advance Ps. Does the list software have an issue with Lotus Notes? Only if you try and send HTML then it will send an attachment. This is sent using Lotus Notes and Plain Text only. --- Halldór Bjarki Christensen [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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: Japanese Charset
I welcome the pedantics! Multiple databases on multiple servers? That is what I thought...which I assume means multiple machines (not an option). And I'm glad you pointed it out that it still wouldn't solve the problem. Go re-read the section of the manual on string literals. Ask yourself what is going to happen when you try to insert the text Our network switches are 100% standard! or You should store your preferences at c:\WINNT\bloopers\prefs.txt in your database. How would you set up the database queries to store those strings? Prior to sending the string to the database, I would look for \ and replace it with \\. Its difficult for me to see the \ in Our network switches are 100% standard! because, like you said, the 0x5c may be only part of the entire hex value of the character (as Japanese characters are multibyte). I would need to first convert the Japanese character to hex, then look for the 0x5c, then replace it with 0x5c0x5c. Problem solved. Say, do you want a little utility program in Java or C that will print the hexadecimal values of the characters in a string? I avoiding the 0x5c byte *precisely* because I don't know how to convert my Japanese text (squiggly pictures I see in Notepad) into their hex values. I would LOVE such a utility! This issue is so baffling to me because 1. People on this list have said they have successfully stored multiple charsets, including Japanese, in the same database. 2. I store Korean and Chinese (simplified) in this same database with no errors. (Of course, I am dependent on the Korean and Chinese speaking colleagues of my client whom were tasked with proofreading.) 3. A fellow from MySQL with whom I was recently in contact with off-list said the following: Right now, MySQL does not enable you to store multiple charsets per database. (This same fellow said the 0x5c was probably causing my problem.) Thanks for all your help. I feel much less hopeless than I did several weeks ago. Dawn Friedland [EMAIL PROTECTED] -Original Message- From: Joel Rees [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 29, 2002 7:24 PM To: Dawn Friedland Cc: [EMAIL PROTECTED] Subject: Re: Japanese Charset Dawn, I'm going to give in to the temptation to be pedantic. Apologies in advance. Kirk Samuelson wrote: I've read lots of similar posts in the archives at http://lists.mysql.com/. Many suggestions to use a BLOB instead of a text field. But MySQL supports double-byte languages. Why not use an encoding it supports (SJIS or UJIS for Japanese) instead of this kludge? If I compile MySQL to support UJIS with --with-charset=sjis won't text fields then store ujis encoded text properly? I'd like to use Unicode too but if it's not supported yet... The idea is to be able to store Latin and Japanese in the same database (as well as Chinese Korean). Isn't that supported by MySQL? People on this list say they've done it successfully. If I compile MySQL using --with-charset=sjis , how will it handle the Latin, Chinese, and Korean characters? Multiple databases on multiple servers? But you still have the problem of needing to handle the escape characters correctly. (Sorry I wasn't able to get that page up over the weekend.) Go re-read the section of the manual on string literals. Ask yourself what is going to happen when you try to insert the text Our network switches are 100% standard! or You should store your preferences at c:\WINNT\bloopers\prefs.txt in your database. How would you set up the database queries to store those strings? Say, do you want a little utility program in Java or C that will print the hexadecimal values of the characters in a string? Basically, it would be a command-line utility, so you would copy the text and then paste it into the command line, after the name of the utility. You'd need a compiler, of course. -- Joel Rees [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: FileMaker Pro Schema Export?
Question are you want to take your data from Filemaker to Excel? Because what I had to do was re-create the tables in MySQL then out putting the data to cvs table. Making sure the data was divide by a command, then I use mysqladmin or you can use phpMyAdmin import it into you MySQL. If that what you are doing. I might be able to help a little. Chuck Payne Magi Design and Support Account Protect by ASK! -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 2:52 PM To: Jan Steinman Cc: [EMAIL PROTECTED] Subject: Re: FileMaker Pro Schema Export? I never actually looked into it. There are so many work arounds I need to do in FileMaker that I just redesign the tables in MySQL. If there isn't a FileMaker converter, I'm sure there is a DBF converter. You can just save you FileMaker databases as DBF and then convert them. On Monday, September 30, 2002, at 09:14 AM, Jan Steinman wrote: Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - 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- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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: Japanese Charset
CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it can store them all in Customers? You use Unicode with a binary field and do post-processing work (like ORDER BY) yourself. I have tried your suggestion. If I am using a binary field, wouldn't it look like this: CREATE TABLE Customers ( Name varchar(100) binary ); I have saved my notepad file as Unicode. I copy/paste to a web form and submit to a field of type varchar binary. (I also try with varchar, char, blob, mediumtext). The characters still break. I copy/paste directly to command prompt. Characters still break. Thanks for your input. I am welcome to hearing more ideas. Perhaps I am missing something (likely). Dawn -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 5:35 AM To: Joel Rees Cc: Dawn Friedland; [EMAIL PROTECTED] Subject: Re: Japanese Charset Joel Rees wrote: If I compile MySQL using --with-charset=sjis , how will it handle the Latin, Chinese, and Korean characters? Multiple databases on multiple servers? Try this one on for size: CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it can store them all in Customers? You use Unicode with a binary field and do post-processing work (like ORDER BY) yourself. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 - Which DB gives best sql performance?
Which DB type will provide the best performance? We're currently using MyISAM, but I'm curious if switching to InnoDB will provide any performance improvements. Regards, Brian Safford EDS Messaging Note: The following was added to get this posting through the spam filters: sql query - 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: Japanese Charset
Your webform application must call the appropriate mysql escape string function for the language in which it is written. Dawn Friedland wrote: CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it can store them all in Customers? You use Unicode with a binary field and do post-processing work (like ORDER BY) yourself. I have tried your suggestion. If I am using a binary field, wouldn't it look like this: CREATE TABLE Customers ( Name varchar(100) binary ); I have saved my notepad file as Unicode. I copy/paste to a web form and submit to a field of type varchar binary. (I also try with varchar, char, blob, mediumtext). The characters still break. I copy/paste directly to command prompt. Characters still break. Thanks for your input. I am welcome to hearing more ideas. Perhaps I am missing something (likely). Dawn -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 5:35 AM To: Joel Rees Cc: Dawn Friedland; [EMAIL PROTECTED] Subject: Re: Japanese Charset Joel Rees wrote: If I compile MySQL using --with-charset=sjis , how will it handle the Latin, Chinese, and Korean characters? Multiple databases on multiple servers? Try this one on for size: CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it can store them all in Customers? You use Unicode with a binary field and do post-processing work (like ORDER BY) yourself. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
Max number of merged tables?
Hello all, I am currently creating a table per hour for some data I have. Each table has 502 fields (yeah, I knownothing I can do about it, this is a very special situation) and about 100,000 records. A few hours worth of data creates a 2GB table, and I don't really want to increase the size of the tables and risk something happening to *all* the data if something becomes corrupt. I'm using the MERGE feature and all has worked well so far. I am using MySQL version 3.23.52. My question is, what is the maximium number of tables I can merge together? Like I said, I create one every hour. 24 a day, 168 a week and 672 a month. I would like to keep as much data available in the merged table. I'm using a merge table so that I can query one table rather than generating a transaction of queries. Any ideas? Thanks, Kevin [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
sub-select workaround
hi! The application is a password-username-location-type store. The types are web,mysql, and entries for different computers to I can see all usernames/passwords on certain computers I would like to make myIsam tables into innodb to provide foreign keys, but I have a 'missing link' I need to insert 'broken reference' items into another table, to complete the cycle/circle I need to move items from hash.lokation into location.location . mysql select hash.username as 'hash-username',hash.lokation as 'broken reference', location.location - as 'missing item' - from hash left join location on location.location=hash.lokation where location.location is null; +---+---+--+ | hash-username | broken reference | missing item | +---+---+--+ | joeofcle | staroffice| NULL | | eunjin| www | NULL | | joe | www2 | NULL | | root | www2 | NULL | | daz | pop | NULL | | joeofsa | www.vbulletin.com | NULL | | spiegel | directvinternet | NULL | | eunjin| lt.sirfsup| NULL | | root | rfi-mysql2| NULL | | david | sirfsup.com | NULL | | webuser | rfi-mysql2| NULL | . CREATE TABLE passwd ( id mediumint not null auto_increment primary key, FOREIGN KEY category_idx(type) REFERENCES category(type) ON DELETE SET NULL ) TYPE=INNODB select hash.username as uname, hash.password as pass, hash.lokation as location, location.location as type, hash.email from hash,location where hash.lokation = location.location; (the foreign key reference is on a third table, the category table, but I can only get there through the location table, the one with the nulls) it would seem to call for some kind of array/loop insert, how can I do that without using a sub-select? i can't do a insert into location (location) values ( select ... as above how can I do this so that the following create table statement will work? thanks, joe -- Joe Speigle | [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: RE: date column
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 6:21 PM To: Tewfic Kidess Subject: Re: RE: date column 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: Hello, I have a table that keeps track of people and their office visits. This table will have duplicates since people will visit the office more than once... How can I get a list of people and the most recent time they've visited the office? Currently, I use select * from table_name where date '2002-06-18'; but that gives me a list that includes duplicate people, if I use 'group by name' it give me the first listing of that person, which may not be the most recent... Your suggestions will be greatly appreciated. Thank you. - 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: Mixing Linux and Windows and paying for it
William R. Mussatto [EMAIL PROTECTED] On Mon, 30 Sep 2002, Drulli B wrote: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows computer? Why not query it directly on its std port? What language are you using? Perl (including ISAPI version .plx) can use DBI and connect directly. Fact is that I'm not using any particular language, but rather Other People's programs - statistical and data mining software that only supports ODBC. So what I'm wondering is: if I get the (not at all knowledgeable about mysql or any other database) computer department to install linux on a computer and install mysql on that computer, can I just enter its ip address in the myodbc dialog, and be amazed at how well it works? Bjarki - 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: Japanese Charset
I found a solution!!! ***Replace all backlashes with two backslashes.*** (The hex value of the backslash is 0x5c, see Joel Rees' previous emails for an explanation on how multibyte Japanese characters contain the hex value 0x5c and that MySQL uses that value as an escape character.) VBscript used prior to submitting data to database: szJapaneseText = replace(szJapaneseText, \,\\) Pulling from the database and displaying to a web page requires no additional processing. Simply display. Thank you so much for all your time and effort reading and responding to my emails. Joel Rees - You insisted it was 0x5c from the beginning. I was so slow to understand because of everyone's talk of UTF-8, was it Word, was it my content tool, is MySQL capable of storing multiple charsets per database, etc. Thank you immensely for your patience and all your help. Gerald Clark - It was your simple, brief message that made me think, Is it that simple? It is. Michael Babcock, Shashank Tripathi, Jon Frisby, Brian Duke, kayamboo, Kirk Samuelson - Thank you for just being there and responding with hope that there is a solution - without which I would not have persisted on. I know this is all so sappy, but this was the most lengthy, most frusterating, and hopeless problem solving event of my life. I am glad it is over (and now maybe I'll get paid). The most unsurprising thing is that it was so simple: one line of code. Sincerely, Dawn Friedland [EMAIL PROTECTED] -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:16 PM To: Dawn Friedland Cc: Michael T. Babcock; [EMAIL PROTECTED] Subject: Re: Japanese Charset Your webform application must call the appropriate mysql escape string function for the language in which it is written. Dawn Friedland wrote: CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it can store them all in Customers? You use Unicode with a binary field and do post-processing work (like ORDER BY) yourself. I have tried your suggestion. If I am using a binary field, wouldn't it look like this: CREATE TABLE Customers ( Name varchar(100) binary ); I have saved my notepad file as Unicode. I copy/paste to a web form and submit to a field of type varchar binary. (I also try with varchar, char, blob, mediumtext). The characters still break. I copy/paste directly to command prompt. Characters still break. Thanks for your input. I am welcome to hearing more ideas. Perhaps I am missing something (likely). Dawn -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 5:35 AM To: Joel Rees Cc: Dawn Friedland; [EMAIL PROTECTED] Subject: Re: Japanese Charset Joel Rees wrote: If I compile MySQL using --with-charset=sjis , how will it handle the Latin, Chinese, and Korean characters? Multiple databases on multiple servers? Try this one on for size: CREATE TABLE Customers ( Name VARCHAR(100) ); Now ... if your customers have names in Japanese, Russian and German, how do you compile MySQL so it can store them all in Customers? You use Unicode with a binary field and do post-processing work (like ORDER BY) yourself. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 - Which DB gives best sql performance?
Brian Safford wrote: Which DB type will provide the best performance? We're currently using MyISAM, but I'm curious if switching to InnoDB will provide any performance improvements. Regards, Brian Safford EDS Messaging Note: The following was added to get this posting through the spam filters: sql query - 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 Hello Brian, I would only use innodb if you must have transaction support or row level locking. It seems to me to be just as fast, or maybe a little slower due to log file writes, as the myisam tables. There is one important thing I do not like about Innodb tables. .If you add or drop and index, it rebuilds the entire table (possibly tablespace, I'm not sure). During testing, I've found that its faster to drop a table, recreate it with the new index, and reimport the data. From what I understand, it's because the indexes are kept along with the data unlike myisam where the indexes are seperate files. Hope this helps! walt - 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 BLOB Visual Basic
Greetings. I try to save 7MB large binary string to mysql blob field in the latest mysql server. I use innodb tables. Error I receive from myodbc driver says: Memory allocation error. Here is my.ini extract: set-variable=max_allowed_packet=30M set-variable=wait_timeout=10 set-variable = innodb_buffer_pool_size=30M set-variable = innodb_additional_mem_pool_size=15M Everything should work just fine but I do not know what's wrong. Does anyone have an idea? If this is not solvable, how can I expect mysql to receive large amounts of data? Thank You for your patience Bruno - 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 - Which DB gives best sql performance?
On Mon, Sep 30, 2002 at 03:45:20PM -0400, Brian Safford wrote: Which DB type will provide the best performance? We're currently using MyISAM, but I'm curious if switching to InnoDB will provide any performance improvements. It depends. There are cases when MyISAM is the clear winner and cases when InnoDB is. Can you benchmark your application with both? That's the *best* way to answer the question. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 55 days, processed 1,155,987,364 queries (240/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
Setting the password for root user in mysql
Hi everyone, I am just starting to work with MySql on MAC OS X.When i installed mysql i got the following message : PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/bin/mysqladmin -u root -p password 'new-password' /usr/local/bin/mysqladmin -u root -h localhost -p password 'new-password' However, when I try the first command, it gives me the error: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) although the mysqld dameon is running. When i try to execute the 'mysql' client it connects properly with the server but i am unable to execute any command from the client since I dont have a valid user id and password combination. So please let me know , how to set up a working root account for mysql. Regards Palash Kasodhan - 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 server won't keep running - SOLVED..... NEXT!
Thanks to all who responded. It seems that my problem was two fold. 1) I needed the my.cnf file in the root on C:/ for one. 2) I had install it the first time to my D drive. When I couldn't get it to work I uninstalled and reinstalled it to the C: drive. For some reason, the services command to start mysql retained the d: drive location so when attempting to start it. It was looking on the wrong drive. Again, Thanks for the assistance from all. Now, if someone can tell me why I can't connect from my basic perl script (straight out of Teach Yourself MySQL) I would be truly in your debt. David Gerler Gerler Enterprises PO Box 16357 Chesapeake VA 23328 (757) 410-0738 http://www.GerlerEnterprises.com/ Nationwide Dial-up from $12.45 /mo. http://www.EasySitesForLess.com/ -Original Message- From: oceanare pte ltd [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:22 AM To: [EMAIL PROTECTED] Subject: RE: mysql server won't keep running Hi, have you copied a my.ini with the configuration information in it into to your Windows system directory? There is a sample ini file with MySQL. Rename it and use it for the start. Erich -- From: David Gerler Sent: Montag, 30. September 2002 09:39 To: [EMAIL PROTECTED] Subject:mysql server won't keep running Hi, I am attempting to use mysql 3.23.52 on win2000pro. I have installed it and I believe everything went okay for that. At least I did get any errors. When I open services, mysql is set for automatic but it is not started. When I try to start it, I get an error 1067: the process terminated unexpectedly. I have tried the command line also. I CD to mysql\bin and run mysqld. I don't get any errors. Then I run mysql and get and error 2003: can't connect to mysql server on localhost (10061). Can anyone shed some light on my problem? David Gerler Gerler Enterprises PO Box 16357 Chesapeake VA 23328 (757) 410-0738 http://www.GerlerEnterprises.com/ Nationwide Dial-up from $12.45 /mo. http://www.EasySitesForLess.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. - 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: Setting the password for root user in mysql
On Monday, September 30, 2002, at 03:03 24h, Palash Mohanlal Kasodhan wrote: Hi everyone, I am just starting to work with MySql on MAC OS X.When i installed mysql i got the following message : PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/bin/mysqladmin -u root -p password 'new-password' /usr/local/bin/mysqladmin -u root -h localhost -p password 'new-password' try: /usr/local/bin/mysqladmin -u root password 'new-password' with the single quotes. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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: Setting the password for root user in mysql
Is MySQL running? Use Process Viewer to see if there is an entry for mysqld. If not, I would ask if you issued the install_db command and then started mysql. Ted On Monday, September 30, 2002, at 06:03 PM, Palash Mohanlal Kasodhan wrote: Hi everyone, I am just starting to work with MySql on MAC OS X.When i installed mysql i got the following message : PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/bin/mysqladmin -u root -p password 'new-password' /usr/local/bin/mysqladmin -u root -h localhost -p password 'new-password' However, when I try the first command, it gives me the error: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) although the mysqld dameon is running. When i try to execute the 'mysql' client it connects properly with the server but i am unable to execute any command from the client since I dont have a valid user id and password combination. So please let me know , how to set up a working root account for mysql. - 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 BLOB Visual Basic
What does your VB code look like? Mike Hillyer -Original Message- From: Bruno Batarelo [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 3:42 PM To: [EMAIL PROTECTED] Subject: MySQL BLOB Visual Basic Greetings. I try to save 7MB large binary string to mysql blob field in the latest mysql server. I use innodb tables. Error I receive from myodbc driver says: Memory allocation error. Here is my.ini extract: set-variable=max_allowed_packet=30M set-variable=wait_timeout=10 set-variable = innodb_buffer_pool_size=30M set-variable = innodb_additional_mem_pool_size=15M Everything should work just fine but I do not know what's wrong. Does anyone have an idea? If this is not solvable, how can I expect mysql to receive large amounts of data? Thank You for your patience Bruno - 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: Mixing Linux and Windows and paying for it
On Monday 30 September 2002 10:13, Drulli B wrote: Hi, I have a grand total of two very important but possibly humiliatingly daft questions, that I hope some kind soul will patiently solve: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows computer? Yes. But, as another poster pointed out, there are native ways of querying MySQL as well. I believe every major programming language has (at least) one MySQL library. 2. The licensing info seems only relevant to people who develop applications. I just want to use it as a repository for data, and then query it myself through such decidedly closed-source bastards as Excel and Access, but I'm doing this for profit. If I use mySQL for such a purpose, and not as a part of an application, do I then need to sell my boss a license? The morally correct answer is obvious to me, but I'd like to know what the demands of the mySQL company are: do I have more than one morally correct option? MySQL is GPL now. Buying a license would be nice to help support MySQL, but IIRC, you don't HAVE to buy a license. j- k- -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - 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/droping database using mySQL JDBC driver
On Monday, September 30, 2002, at 03:53 24h, Slava Imeshev wrote: Hello All, Could anyone help me with this issue? Is it possible to create/drop database using mySQL JDBC driver? Yes. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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: Japanese Charset
Multiple databases on multiple servers? That is what I thought...which I assume means multiple machines (not an option). For future reference, MySQL can actually run multiple servers with different configurations on a single machine in Linux. (*BSD and Mac OS X, too, I think.) They are working on methods for doing this in MSWindows, but the different user model in MSWindows requires a different approach than they are using for *NIX. -- Joel Rees [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: Japanese Charset
I found a solution!!! Hooray! ***Replace all backlashes with two backslashes.*** You probably want to consider whether you want to replace all quotes with backslash-quote, as well. Backslashes in the English text would only show up for something like file paths on MS OSses, but your customer might want to put single or double quotes around something on a page, and the way it is right now MySQL should be throwing syntax errors when it gets embedded quotes. (The hex value of the backslash is 0x5c, see Joel Rees' previous emails for an explanation on how multibyte Japanese characters contain the hex value 0x5c and that MySQL uses that value as an escape character.) VBscript used prior to submitting data to database: szJapaneseText = replace(szJapaneseText, \,\\) Sorry about talking first about regular expressions. I'm thinking VB ought to have full RE by now, but maybe it's still only got the text replacement function. Pulling from the database and displaying to a web page requires no additional processing. Simply display. You might want to turn off the post-processing for all non-English pages. Even though the Chinese seems to work, I suspect there will be some characters that you just haven't seen yet which get morphed by this little trick. I think I'd warn the customer, though, and explain that it will cost them extra to have it in foreign language pages. Case munging is just one example of post-processing that only makes sense in certain contexts. The time to _research_ which kinds of post-processing make sense in which languages, ethnic groups, etc., is not trivial. Could be worth doing if they have the money and the need. But there aren't really any packaged solutions for those problems yet. If they really think they want post-processing, you definitely want to make sure the text is converted to Unicode by the time it hits post-processing. Gerald Clark - It was your simple, brief message that made me think, Is it that simple? It is. :) (Thanks, Gerald.) -- Joel Rees [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: Mixing Linux and Windows and paying for it
the answer to your question is yes. however, what you're considering is a complex technical exercise while it's being set up. after you get it going, it'll work like a charm, but your technical people will need to know what they are doing. corereader is a ms. windows app and one of its purposes is to reduce some of the pain involved in experimenting with data connections and queries. it will query any data source on any platform with simple point and click queries, but making the connection is difficult. if you want it, it's free from its own site, http://www.CoreReader.com/ the documentation on the site will give you some idea of a few of the problems involved. it's easy to operate, but the concepts involved are complex, so please read the documentation. William R. Mussatto [EMAIL PROTECTED] On Mon, 30 Sep 2002, Drulli B wrote: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows computer? Why not query it directly on its std port? What language are you using? Perl (including ISAPI version .plx) can use DBI and connect directly. Fact is that I'm not using any particular language, but rather Other People's programs - statistical and data mining software that only supports ODBC. So what I'm wondering is: if I get the (not at all knowledgeable about mysql or any other database) computer department to install linux on a computer and install mysql on that computer, can I just enter its ip address in the myodbc dialog, and be amazed at how well it works? Bjarki -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.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
select problem with not equal syntax
I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL) TYPE=INNODB There are few data stored in both tables. Now I will select new messages from hl7incom, where hl7incom.id is not equal pid_segment.id and store this id, msg in pid_segment. With query... SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.id != hl7incom.id GROUP BY hl7incom.id; ...I get also the id's which are allready in table pid_segment. I tried different querys, also with LeftJoins but couldn't fix the problem. Anybody some idea? - 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: select problem with not equal syntax
On Mon, 2002-09-30 at 23:44, Gebhardt, Karsten wrote: I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL) TYPE=INNODB There are few data stored in both tables. Now I will select new messages from hl7incom, where hl7incom.id is not equal pid_segment.id and store this id, msg in pid_segment. With query... SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.id != hl7incom.id GROUP BY hl7incom.id; Try SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.idhl7incom.id GROUP BY hl7incom.id; John Coder - 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: select problem with not equal syntax
No way, I've already tried this. I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL) TYPE=INNODB There are few data stored in both tables. Now I will select new messages from hl7incom, where hl7incom.id is not equal pid_segment.id and store this id, msg in pid_segment. With query... SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.id != hl7incom.id GROUP BY hl7incom.id; Try SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.idhl7incom.id GROUP BY hl7incom.id; John Coder - 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: select problem with not equal syntax
Just a suggestion: SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND not(pid_segment.id = hl7incom.id) GROUP BY hl7incom.id; Otherwise my only other suggestion would involve using the 'NOT IN' logic, but I think that might be too convoluted for your needs. -Original Message- From: Gebhardt, Karsten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:07 AM To: '[EMAIL PROTECTED]' Subject: RE: select problem with not equal syntax No way, I've already tried this. I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL) TYPE=INNODB There are few data stored in both tables. Now I will select new messages from hl7incom, where hl7incom.id is not equal pid_segment.id and store this id, msg in pid_segment. With query... SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.id != hl7incom.id GROUP BY hl7incom.id; Try SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.idhl7incom.id GROUP BY hl7incom.id; John Coder - 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: select problem with not equal syntax
Same result, also if I do not define unique index. Just a suggestion: SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND not(pid_segment.id = hl7incom.id) GROUP BY hl7incom.id; Otherwise my only other suggestion would involve using the 'NOT IN' logic, but I think that might be too convoluted for your needs. No way, I've already tried this. I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL) TYPE=INNODB There are few data stored in both tables. Now I will select new messages from hl7incom, where hl7incom.id is not equal pid_segment.id and store this id, msg in pid_segment. With query... SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.id != hl7incom.id GROUP BY hl7incom.id; Try SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.idhl7incom.id GROUP BY hl7incom.id; John Coder - 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: Win32 zipped binary seems corrupted
Greetings.. Even the MySQLGui does not work for me. It is not getting downloaded. What should I do ? Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative GUI for MySQL - Original Message - From: Pavel Hlouek [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 11:34 PM Subject: MySQLGUI: Win32 zipped binary seems corrupted Hi, I've just tried to download the Win32 binaries of the MySQLGUI tool. I recieved about 50kB. When I tried to unpack the archive, WinCommander told me, that the zip archive is corrupted. Hope it helps, thanx guys for wonderfull MySQL. Pavel __ Reklama: E-mail zdarma na cely zivot: http://email.seznam.cz - 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