Re: Delphi MySQL Access Components
Hi, You can have a look at the Delphi 56/Kylix 12 single source components from SciBit at www.scibit.com/mysqlcomponents. Kind Regards SciBit MySQL Team -Original Message- From: Pierre du Parte [EMAIL PROTECTED] To: Daniel Kiss [EMAIL PROTECTED] CC: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Delphi MySQL Access Components Sent: Thu, 25 Jul 2002 00:39:12 GMT Received: Thu, 25 Jul 2002 03:02:11 GMT Read: Sat, 30 Dec 1899 00:00:00 GMT Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 type of datetime timestamp same??
Hi Jenny, The formatting are the same -MM-DD HH: - The timestamp field is set automatic by the system when updating a record. The date/time fields are for Your control and usage. Take a look in the manual 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types Best regards Peter - Original Message - From: Jenny Christy [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 6:22 AM Subject: Is type of datetime timestamp same?? Hello All, I m using mysql 3.23.42 and myodbc 3.51 on linux7.2. I use SQLDescribeCol API to get type of column(field). When i call above functuon it returns type of datetime and timestamp is 93 for both. but the format of inserting datetime value uses ( )and timesstamp value is different. I m having a problem how can I distinguish them so that I can insert the data in correct format.or is there any bug in myodbc driver. Thanx in advance for ur kind help. Rgds, Jenny __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Facing some problem in installation
I am trying to install the mySQL on our remote server thr putty (SSH). Following are the set of commands given by me, I have downloaded mysql-3.23 for BSDi. 1)put into /usr/home/mysql-src directory and given following 2 commands going into shellcd /usr/home/mysql-src shellgunzip mysql-.tar.gz shelltar xvf mysql-.tar This is creating the directory mysql- 2)Config - shellcd /usr/home/mysql-src/mysql- shell./configure -basedir=/usr/home/mysql -with-low-memory This command is giving me problem - saying - at the end shellStarting mysqld daemon with database from /usr/home/mysql-src/mysql-/data rm /tmp/mysql.sock - Operation not permitted mysqld end Can anybody help me in this matter - What is the meaning of it ? Thanks and regards Manisha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 loses databases
Hello, Earlier i posted my message here, but haven't got any real solution. So now I'll try to post with some more details. I have a FreeBSD 4.6 box, dual cpu, runing MySQL. It runs with linuxthreads enabled and it is under heavy load all the time. Few weeks ago it started to work a little strange. MySQL runs ok for some period of time, and then it disallows connections from users, saying 'access not allowed for user@localhost'. Root can connect without problems. The strange thing is, that MySQL somehow 'loses' it's databases. When I connect as root, 'show databases' output gives me one database... vi.recover. So I suppose, that MySQL drops it's path somewhere, but I'm not sure why. The only workaround I have for now is run database check every minute, and restart MySQL if needed. After restart everything looks OK for some time ( one - two days)... This problem was with 3.23.49, and now I saw this with 3.23.51 too. Any ideas what could be wrong? Simas Cepaitis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error in mysql - help!!!
I have tried to install mysql, but there is something wrong... When I start up my computer I get this error-message in a pop-up with a 'winmysqladmin.exe'-header: Error reading Memo2 - Lines.Strings: The parameter is incorrect. Does anybody know what this means, and what I can do to make mysql work? Php and Apache seems to be up and running. I'm using win98. I'm new to this game, so ALL help is apreciated!! jan henrik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SUMMARY: how to update time field with current time?
Thanx to all those how answered: hcir walt William Mussatto David Yahoo The answer was now() or update tab_name set fd_name = (now()) where_expr; I had tried this but was missing a pair of brackets (honest..) MYSQL dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 loses databases
Pada Thu, 25 Jul 2002 09:28:45 +0200 Simas Cepaitis [EMAIL PROTECTED] menulis : Hello, Earlier i posted my message here, but haven't got any real solution. So now I'll try to post with some more details. I have a FreeBSD 4.6 box, dual cpu, runing MySQL. It runs with linuxthreads enabled and it is under heavy load all the time. Few weeks ago it started to work a little strange. MySQL runs ok for some period of time, and then it disallows connections from users, saying 'access not allowed for user@localhost'. Root can connect without problems. The strange thing is, that MySQL somehow 'loses' it's databases. When I connect as root, 'show databases' output gives me one database... vi.recover. So I suppose, that MySQL drops it's path somewhere, but I'm not sure why. The only workaround I have for now is run database check every minute, and restart MySQL if needed. After restart everything looks OK for some time ( one - two days)... This problem was with 3.23.49, and now I saw this with 3.23.51 too. Any ideas what could be wrong? vi.recover isn't it from VI application ??? Maybe someone is trying to do something inside your mysql data directory ... and somehow he damage your DB Try to investigate it from FILE side ;-) From my experiences, mysql never lost the databases ... because it's based on directory structure on your filesystem OS. eventhough it's mysql bug and your db corrupt, the directory should be still exist and you can see from show databases. -- printk(??? No FDIV bug? Lucky you...\n); 2.2.16 /usr/src/linux/include/asm-i386/bugs.h MySQL 3.23.51 : up 34 days, Queries : 354.952 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.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: Facing some problem in installation
If you are NOT installing as root, you are trying to create mysql.sock in an area where you don't have write permission. what is the --prefix you supplied to ./configure ? -Original Message- From: Manisha [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:18 PM To: [EMAIL PROTECTED] Subject: Facing some problem in installation I am trying to install the mySQL on our remote server thr putty (SSH). Following are the set of commands given by me, I have downloaded mysql-3.23 for BSDi. 1)put into /usr/home/mysql-src directory and given following 2 commands going into shellcd /usr/home/mysql-src shellgunzip mysql-.tar.gz shelltar xvf mysql-.tar This is creating the directory mysql- 2)Config - shellcd /usr/home/mysql-src/mysql- shell./configure -basedir=/usr/home/mysql -with-low-memory This command is giving me problem - saying - at the end shellStarting mysqld daemon with database from /usr/home/mysql-src/mysql-/data rm /tmp/mysql.sock - Operation not permitted mysqld end Can anybody help me in this matter - What is the meaning of it ? Thanks and regards Manisha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: compiling mysql 3.23.37
SandraR, Tuesday, July 23, 2002, 6:04:42 PM, you wrote: S I need re-compiling mysql 3.23.37 in linux, how can I do this. S In the maestrosdelweb link said how is the compilation, the problem is that S these commands (./config and make) are not available from my install S folders. I have not a directory where I can found. S I have in: S /var/lib/mysql/ - the data bases S and in S /usr/bin/ - the commands. S The question is ¿how can I re-compile mysql 3.23.37?? Check docs: http://www.mysql.com/doc/Q/u/Quick_install.html shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make -- 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 3.23 to version 4 upgrade
chuck, Wednesday, July 24, 2002, 11:33:21 AM, you wrote: ca Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any ca issues that should be addressed ie uninstall v3 prior to installing v4 ca or can i just install over v3. ca Any suggested sites' ,FAQ regarding my question. Some notes about upgrading from 3.23 to 4.0 you can find in the MySQL manual: http://www.mysql.com/doc/U/p/Upgrading-from-3.23.html As to your question you can uninstall 3.23 first and then install 4.0, you can have both version on your box, you can upgrade over 3.23. To be sure you can backup your databases. -- 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: RE: Problem downloading MySQL4.0.2a for windows
Tam, Tuesday, July 23, 2002, 9:38:17 PM, you wrote: T Hi Victoria, TDo you know when the 4.0.2a-MAX would be available for download then? T Thank you. Use mysql-win-4.0.2-alpha.zip instead. It the same as with -max. -- 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: Alter table and sort_buffer_size is to small
Martin, Tuesday, July 23, 2002, 10:29:13 AM, you wrote: MP I'm running a MySQL server v 3.23.39 on Linux Debian. The server has 500 MP MB RAM. I have a table called sender with 18 columns (only integers MP and varchars, no blobs) and with 3 indexes. The table has about 15000 MP records. Now I need to add one more column to the table with alter table MP command. MP But when I do it I get: MP ERROR 1034: sort_buffer_size is to small MP Currently the size of the sort buffer is 2MB, but even when I increased MP it to 400MB I got same error. I tried to drop some of the indexes, which MP helped last time, but when I try to drop some index now, I got same 1034 MP error. MP Only workaround for this I know is to dump the table, add the column MP manualy in the dump file, drop the table and recreate the table from the MP dump. It's nasty procedure and I will have to take the server down for MP some time, so I hesitate to do it. MP I myisamchecked the table (and even optimized) and it's fine. MP I hope there must be something to help me. Hm.. Error 1034 means: Incorrect key file for table ... not a sort_buffer_size is to small How did you installed the server? -- 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: re[2]: MySQL Errors -
Richard, Tuesday, July 23, 2002, 3:56:36 PM, you wrote: RM What instances can cause a Table to crash? RM Is this caused by a bug in itself, a power failure, or something else? It may be a bug in MySQL, hardware errors, abnormal shutdown, running myisamchk, when mysqld is running ... Some of possible causes are described in the manual: http://www.mysql.com/doc/C/r/Crashing.html http://www.mysql.com/doc/C/o/Corrupted_MyISAM_tables.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: TZ time zone variable
Renato, Tuesday, July 23, 2002, 9:40:35 PM, you wrote: RL I have several mysql servers installed, all without TZ variable, one of RL them, insists in set the select now() to 4 hours ahead of my internal RL clock, first I touch that I should set TZ to my time time zone in RL /etc/init.d/mysql, but when I do that, the select now() advances 4 RL more hours. RL Below is the information about my system. now the --timezone option in RL /etc/init.d/mysql nor in /usr/bin/safe_mysql is not set. [skip] RL # date ; echo -e select now();\nshow variables;\n|mysql -u root RL -pfdrops500 RL Tue Jul 23 14:25:39 AMT 2002 RL now() RL 2002-07-23 18:25:39 Seems, NOW() returns values in GMT. RL timezoneAmerica/Manaus How did you set up timezone? -- 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:RE: Query Optimization
Dave Dutcher [EMAIL PROTECTED] wrote on 24.07.2002 21:35:03: Hi, I did some more research on my problem. (Sorry for not doing it before I posted the other message), and I think perhaps my question could be summarized into the following. Can I use an index to speed up a select max() or select min()? I read what the manual has to say about a query like this: SELECT MIN(key_part2),MAX(key_part2) FROM table_name where key_part1=10 However I want to do this: SELECT MAX(key_part1) FROM table_name where key_part1 10 also what I want to do is basically equivalent to this: SELECT key_part1 FROM table_name WHERE key_part1 10 ORDER BY key_part1 DESC LIMIT 1 In testing the second statement seems slower than the max() for some reason though. Is there anyway to get close to a O(logN) search time on these queries? Thanks again, Dave -Original Message- From: Dave Dutcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:04 PM To: [EMAIL PROTECTED] Subject: Query Optimization I was wondering if somebody could give me any suggestions on how to optimize a query I am working on. This is my table: CREATE TABLE testdata ( Begin char(9) NOT NULL default '', End char(9) NOT NULL default '', UNIQUE KEY BeginEndIndex (Begin,End) ) TYPE=MyISAM; It is a table of ranges. i.e. 1-5, 7-11, 2-24000. None of the ranges overlap, and I'm trying to write a query to find a range that contains a specific number such as 500,000. So this is what I've written for a query: select Begin, End from testdata where begin = '00500' and end = '00500' On a table with 100,000 records the explain command tells me it is using the BeginEndIndex, it says the key length is 9, and that it has to look through about 27,000 records. I would like to be able to configure the query or indexes , so it will only have to look through a couple records if possible. MySQL is super fast at a query like this: select Begin from testdata where Begin = '00500'; So I had the idea of trying this: select max(Begin) from testdata where Begin = '00500'; I was hoping that it would do the same as the simple select, and then because it has a sorted index it wouldn't have to search the previous records to find the max, but explain still puts this at about 27,000 records. Has anyone else tried writing a query similar to this? Does anybody have any suggestions? Thanks in advance, Dave Hi Dave, IMHO you can speed up your queries if you convert your columns to (unsigned) int if possible. It should be much faster to compare two integers (4 bytes,2 assembler instructions) than comparing two strings (9 bytes,10 assembler instructions). Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Joins, ANSI 92 or the old way
Benjamin Pflugmann wrote: Hi. On Wed 2002-07-24 at 09:46:03 +0100, [EMAIL PROTECTED] wrote: As I understand it an ANSI92 join is written as; SELECT b.columnA FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id Ah. Okay. Was not aware that this was new in ANSI92. Whereas the 'old' style would be; SELECT b.columnA FROM tableB AS b, tableC AS c WHERE b.id = c.id Personally I find the former much easier to read though not sure about the practical differences between them when the statements are executed. AFAICT, there should be no differences on execution speed. We tested a lot with JOINS and found out, that the more expressions in the WHERE clause the slower it gets, this is very obvious of course, but it is surprisingly true for JOINS too. We tried to join about 10-15 tables together with LEFT JOIN and the old ','. The processing time differed drastically. We tested this about 6 months ago with 3.23.36, so this may have be untrue now. BTW the processing time was about 1 second for the new syntax and up to 30 seconds for the old method. (Tables had about 300.000 - 1.000.000 rows) Greetings Ralf sql sql sql sql sql sql sql sql sql sql sql sql sql query query query query query query query query query query query P.S.: Damn filter! -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question about varchars
Hello! Desmond Lee wrote: Hello there Mysql documentation says the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there be anything wrong with making all my varchar's up to 255. That is defining most of my fields to be varchar(255) even when i know they may only go 100? There's nothing wrong with it for storage reasons only, but many database developers use lengths to restrict the size of the entries. For example storing the zipcodes from more than one country might need at max 15 characters, so why allowing 255, preventing MySQL to raise an error, if the ZIP is 100 chars long. Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Splitting textarea values to put into a database
Emma Grant wrote: Hi, Does anyone know how to separate values in a text area field, to enter the separated values into a database? For instance if enter these values into a text area field Dogs Cats Fish I want to be able to take Dogs, Cats and Fish and put them in different rows in a database. I guess the biggest problem I have is splitting the values in the text area field that is separated by a carriage return. Once I have that, and I know how to separate the values, then I can easily put them into a database. BTW I am using CGI/PERL to enter the values into a MySql database. #!/usr/bin/perl -w # # filename: test.pl # my $rowcnt = 0; my $q; $q = INSERT INTO tab VALUES ( while () { chomp(); $q .= '.$_.',; } chop($q); $q .= ) print $q.\n; ## sh -c test.pl - Dogs Cats Fish ^D This would print something like: INSERT INTO tab VALUES ('Dogs','Cats','Fish') Greetings Ralf sql, query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Performance Problem - LEFT JOIN
Guilherme wrote: I have 3 tables tableA, tableB and tableC and the fields tableA.id, tableB.idA and tableC.idA. I'm using this query (bellow) to call information from the database that has in tableA but tableA.id is not found on tableB.idA and tableC.idA. SELECT tableA.* FROM tableA LEFT JOIN tableB ON (tableB.idA = tableA.id) LEFT JOIN tableC ON (tableC.idA = tableA.id) WHERE tableB.idA IS NULL AND tableC.idA IS NULL; With a low ammount of data (30 records) I receive the data really fast. However with a greater ammount of data (1800 records) it takes 26 seconds to return data and it consumes 100% of processor. This situation happens when I have all tableA.id registered on tableB.ida or tableC.ida. Any ideas? Of course you have indexes on all of the id, idA, idB columns? Greetings Ralf sql, query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Facing some problem in installation
Hello! Barnali wrote: If you are NOT installing as root, you are trying to create mysql.sock in an area where you don't have write permission. what is the --prefix you supplied to ./configure ? I'd say install as root, change owner and group of the mysql directories, remove /tmp/mysql.sock and start mysql as user mysql. It is ALWAYS a bad idea to start databases as root user. Greetings Ralf -Original Message- From: Manisha [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:18 PM To: [EMAIL PROTECTED] Subject: Facing some problem in installation I am trying to install the mySQL on our remote server thr putty (SSH). Following are the set of commands given by me, I have downloaded mysql-3.23 for BSDi. 1)put into /usr/home/mysql-src directory and given following 2 commands going into shellcd /usr/home/mysql-src shellgunzip mysql-.tar.gz shelltar xvf mysql-.tar This is creating the directory mysql- 2)Config - shellcd /usr/home/mysql-src/mysql- shell./configure -basedir=/usr/home/mysql -with-low-memory This command is giving me problem - saying - at the end shellStarting mysqld daemon with database from /usr/home/mysql-src/mysql-/data rm /tmp/mysql.sock - Operation not permitted mysqld end Can anybody help me in this matter - What is the meaning of it ? Thanks and regards Manisha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hebrew/arabic language
Hytham Shehab wrote: hi guys, am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show characters of language such as hebrew/arabic? thanks for help sql -- Hytham Shehab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Hi, nothing it is capable Regards -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Selecting from one table to UPDATE another.
What I am trying to do in MySQL. Table1 UserID ProductID Old_UserID 1 2 4 2 3 5 Table2 UserID ProductID 4 Null 5 Null Table1 has new correct data. Table2 has old incorrect data. The link is Table2.UserID and Old_UserID What I need to do is update Table 2 with the new data from Table 1, But I can not get this to work..e.g. UPDATE Table2.ProductID SET Table2.ProductID = Table1.ProductID WHERE Table1.Old_UserID = Table2.UserID REPLACE will not work as these are not KEY fields. Once I have done the ProductID I should then be able to do the UserID using the ProductID (as all values in one table are unique). Help Simon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Syntax (May be OT)
If this question is off topic, please let me know. I have a description field with a set of keywords. I need to update some data based on a keyword, which is randomly placed in the field. Can someone please help with a SQL syntax to find the word within the field. Thanks in anticipation. -David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hebrew/arabic language
Hytham, Thursday, July 25, 2002, 12:54:22 AM, you wrote: HS am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show HS characters of language such as hebrew/arabic? MySQL returns char strings as they were inserted. For correct sorting you can set up hebrew character set starting mysqld with --default-character-set=hebrew MySQL doesn't have arabic character set. As a quick solution for correcting sorting is storage your data as binary in BLOB or VARCHAR BINARY columns. You can also add arabic support by yourself. How to do so read in the MySQL manual, section '4.6.3 Adding a New Character Set': http://www.mysql.com/doc/A/d/Adding_character_set.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: Performance Problem - LEFT JOIN
Guilherme, Thursday, July 25, 2002, 4:18:13 AM, you wrote: G I have 3 tables tableA, tableB and tableC and the fields tableA.id, G tableB.idA and tableC.idA. G I'm using this query (bellow) to call information from the database that has G in tableA but tableA.id is not found on tableB.idA and tableC.idA. G SELECT tableA.* GFROM tableA GLEFT JOIN tableB ON (tableB.idA = tableA.id) GLEFT JOIN tableC ON (tableC.idA = tableA.id) GWHERE tableB.idA IS NULL AND tableC.idA IS NULL; G With a low ammount of data (30 records) I receive the data really fast. G However with a greater ammount of data (1800 records) it takes 26 seconds to G return data and it consumes 100% of processor. This situation happens when I G have all tableA.id registered on tableB.ida or tableC.ida. G Any ideas? You gave incomplete info. What is the structure of your tables? Show the output of EXPLAIN SELECT: http://www.mysql.com/doc/E/X/EXPLAIN.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: question about varchars
Desmond, Thursday, July 25, 2002, 2:42:31 AM, you wrote: DL Mysql documentation says the following: DL values are stored using only as many characters as are needed, plus one DL byte to record the length. Values are not padded; instead, trailing spaces DL are removed when values are stored. DL So, then would there be anything wrong with making all my varchar's up to DL 255. That is defining most of my fields to be varchar(255) even when i know DL they may only go 100? If you have indexes on your whole columns, index on varchar(255) is bigger, than on varchar(100). -- 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: Performance Problem - LEFT JOIN
Try SELECT tableA.* FROM tableA WHERE NOT EXISTS (select * from tableA, tableB, tableC where tableA.id tableB.idA and tableA.id tableC.idA) -Original Message- From: Ralf Narozny [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 2:46 PM To: Guilherme Cc: [EMAIL PROTECTED] Subject: Re: Performance Problem - LEFT JOIN Guilherme wrote: I have 3 tables tableA, tableB and tableC and the fields tableA.id, tableB.idA and tableC.idA. I'm using this query (bellow) to call information from the database that has in tableA but tableA.id is not found on tableB.idA and tableC.idA. SELECT tableA.* FROM tableA LEFT JOIN tableB ON (tableB.idA = tableA.id) LEFT JOIN tableC ON (tableC.idA = tableA.id) WHERE tableB.idA IS NULL AND tableC.idA IS NULL; With a low ammount of data (30 records) I receive the data really fast. However with a greater ammount of data (1800 records) it takes 26 seconds to return data and it consumes 100% of processor. This situation happens when I have all tableA.id registered on tableB.ida or tableC.ida. Any ideas? Of course you have indexes on all of the id, idA, idB columns? Greetings Ralf sql, query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: TZ time zone variable
in the redhat instalation procedure. And I did that for all servers, but only this one has this behaviour. Egor Egorov wrote: Renato, Tuesday, July 23, 2002, 9:40:35 PM, you wrote: RL I have several mysql servers installed, all without TZ variable, one of RL them, insists in set the select now() to 4 hours ahead of my internal RL clock, first I touch that I should set TZ to my time time zone in RL /etc/init.d/mysql, but when I do that, the select now() advances 4 RL more hours. RL Below is the information about my system. now the --timezone option in RL /etc/init.d/mysql nor in /usr/bin/safe_mysql is not set. [skip] RL # date ; echo -e select now();\nshow variables;\n|mysql -u root RL -pfdrops500 RL Tue Jul 23 14:25:39 AMT 2002 RL now() RL 2002-07-23 18:25:39 Seems, NOW() returns values in GMT. RL timezoneAmerica/Manaus How did you set up timezone? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: compiling mysql 3.23.37
ok but I haven't a install folder as MySQLversion because the version that I have instaled is binary and the software are by all sides (/usr/bin and /var/lib) and in this folder I haven't a configure file. ¿what can I do? I don´t want install another version if it was possible. thanks. sandraR - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 5:07 AM Subject: Re: compiling mysql 3.23.37 SandraR, Tuesday, July 23, 2002, 6:04:42 PM, you wrote: S I need re-compiling mysql 3.23.37 in linux, how can I do this. S In the maestrosdelweb link said how is the compilation, the problem is that S these commands (./config and make) are not available from my install S folders. I have not a directory where I can found. S I have in: S /var/lib/mysql/ - the data bases S and in S /usr/bin/ - the commands. S The question is ¿how can I re-compile mysql 3.23.37?? Check docs: http://www.mysql.com/doc/Q/u/Quick_install.html shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make -- 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: SQL Syntax (May be OT)
Hello! David Durham wrote: If this question is off topic, please let me know. I have a description field with a set of keywords. I need to update some data based on a keyword, which is randomly placed in the field. Can someone please help with a SQL syntax to find the word within the field. WHERE field LIKE '%keyword%' maybe WHERE upper(field) LIKE upper('%keyword%') Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Syntax (May be OT)
Use LIKE '%KEYWORD%' At least this works for Oracle -Original Message- From: David Durham [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 3:39 PM To: [EMAIL PROTECTED] Subject: SQL Syntax (May be OT) If this question is off topic, please let me know. I have a description field with a set of keywords. I need to update some data based on a keyword, which is randomly placed in the field. Can someone please help with a SQL syntax to find the word within the field. Thanks in anticipation. -David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
groupadd
Hello I am trying to install mysql on macosx and in the INSTALL-BINARY file it says shell groupadd mysql shell useradd -g mysql mysql These commands are not available under MacOS X Regards -- Dave Houghton [EMAIL PROTECTED] System Manager http://finn.dlg.dmu.ac.uk/~djh Faculty of HumanitiesWork Tel. No. 0116 2506125 Clephan Building, Room 0.35 De Montfort University Leicester LE1 9BH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Alter table and sort_buffer_size is to small
Hi, MP But when I do it I get: MP ERROR 1034: sort_buffer_size is to small Hm.. Error 1034 means: Incorrect key file for table ... not a sort_buffer_size is to small How did you installed the server? I compiled it from the source files. sql -- Martin Pavlas Pwrgeneration.net ICC s.r.o. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Which binary version for which platform?
I have a product for which I would like to use mySql to hold information used in a product demonstration. The product runs on Windows, HP, Solaris and AIX. The demonstration (and the mySql database) will be distributed with the product. I am trying to determine the correct binary distribution of mySql to distribute to end users. I would like to use stable releases only, in binary format. For Windows, the correct release is pretty clear. However, say a customer has HP 11.x. The current stable release on mysql.org is for hp 10.20 (mysql-3.23.51-hp-hpux10.20-hppa1); there is a release on sourceforge for hp 11.0 (mysql-hpux-11.0-hppa2), but is that considered stable? If not, can they use the binary for 10.20 instead? What if the customer later upgrades to a newer version of HP - must they then use a different version of the binary? Similar question pertain to Solaris (currently 2.8) and AIX (currently 4.3). Thanks for any pointers. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: compiling mysql 3.23.37
How about downloading the source of a newer version??? If you are too lazy to search for the URL: http://www.mysql.com/downloads/index.html SandraR wrote: ok but I haven't a install folder as MySQLversion because the version that I have instaled is binary and the software are by all sides (/usr/bin and /var/lib) and in this folder I haven't a configure file. ¿what can I do? I don´t want install another version if it was possible. thanks. sandraR - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 5:07 AM Subject: Re: compiling mysql 3.23.37 SandraR, Tuesday, July 23, 2002, 6:04:42 PM, you wrote: S I need re-compiling mysql 3.23.37 in linux, how can I do this. S In the maestrosdelweb link said how is the compilation, the problem is that S these commands (./config and make) are not available from my install S folders. I have not a directory where I can found. S I have in: S /var/lib/mysql/ - the data bases S and in S /usr/bin/ - the commands. S The question is ¿how can I re-compile mysql 3.23.37?? Check docs: http://www.mysql.com/doc/Q/u/Quick_install.html shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make -- 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 -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Czech complex character set
Hi, I would like to get the Chech complex character set. Where can I find it? Thanks, Daniel SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hebrew/arabic language
hi guys, am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show characters of language such as hebrew/arabic? thanks for help sql -- Hytham Shehab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Concat() Syntax..
Ashwin, Wednesday, July 24, 2002, 3:15:25 PM, you wrote: AK I have a table with a field full of urls.. what I need to do is to append AK to those urls with a new url, so for example, if the field had AK http://www.yahoo.com i want to make it AK http://www.myserver.com/login?url=http://www.yahoo.com .. AK I have tried the following which I thought should work:- AK update table set field = concat(http://www.myserver.com/login?url=;, AK field) where restriction=D and location=local; AK It goes all fine, however when I do a search I have records that now show AK the url as http://www.myserver.com/login?url=http: and it chops off the AK rest.. I have checked the size of the field itself and it was a AK varchar(255).. I thought maybe it was the restriction, which it was for AK about 51 of them cause they showed up as warnings when I ran the update AK command, so I changed the varchar to a blob to see the difference and no AK longer are there any warnings, but it still chops off everything after AK http: Do you update from mysql command-line client? I would work ... mysql insert into chartest values - ('http://www.yahoo.com'), - ('http://www.mysql.com'), - ('http://www.php.net'); Query OK, 3 rows affected (0.01 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql update chartest set - name=concat(http://www.myserver.com/login?url=,name); Query OK, 3 rows affected (0.01 sec) Rows matched: 3 Changed: 3 Warnings: 0 mysql select * from chartest; ++ | name | ++ | http://www.myserver.com/login?url=http://www.yahoo.com | | http://www.myserver.com/login?url=http://www.mysql.com | | http://www.myserver.com/login?url=http://www.php.net | ++ 3 rows in set (0.00 sec) -- 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: Re: Re: Alter table and sort_buffer_size is to small
Hello Martin, Thursday, July 25, 2002, 4:48:03 PM, you wrote: Please, send your questions/answers to the mailing list, not to me. MP But when I do it I get: MP ERROR 1034: sort_buffer_size is to small Hm.. Error 1034 means: Incorrect key file for table ... not a sort_buffer_size is to small How did you installed the server? MP I compiled it from source files. Something is very wrong with your installation. Can you install MySQL from binary distribution from www.mysql.com and check if error occurs again? -- 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: Re: compiling mysql 3.23.37
SandraR, Thursday, July 25, 2002, 2:54:39 PM, you wrote: S ok but I haven't a install folder as MySQLversion because the version that I S have instaled is binary and the software are by all sides (/usr/bin and S /var/lib) and in this folder I haven't a configure file. S ¿what can I do? I dont want install another version if it was possible. You should download source package from http://www.mysql.com/downloads/index.html Read docs how to install MySQL from source distribution: http://www.mysql.com/doc/I/n/Installing_source.html and then install. -- 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: Re: TZ time zone variable
Renato, Thursday, July 25, 2002, 2:35:56 PM, you wrote: RL in the redhat instalation procedure. And I did that for all servers, but RL only this one has this behaviour. Run safe_mysqld --timezone=America/Manaus and show me the output of SHOW VARIABLES LIKE 'timezone' RL Egor Egorov wrote: Renato, Tuesday, July 23, 2002, 9:40:35 PM, you wrote: RL I have several mysql servers installed, all without TZ variable, one of RL them, insists in set the select now() to 4 hours ahead of my internal RL clock, first I touch that I should set TZ to my time time zone in RL /etc/init.d/mysql, but when I do that, the select now() advances 4 RL more hours. RL Below is the information about my system. now the --timezone option in RL /etc/init.d/mysql nor in /usr/bin/safe_mysql is not set. [skip] RL # date ; echo -e select now();\nshow variables;\n|mysql -u root RL -pfdrops500 RL Tue Jul 23 14:25:39 AMT 2002 RL now() RL 2002-07-23 18:25:39 Seems, NOW() returns values in GMT. RL timezoneAmerica/Manaus How did you set up timezone? -- 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
generic sample data script
I'm looking for a script that will fill mysql tables with sample data so we can see how our web pages look with data in them. Does anyone know of any? I've written one in perl but I would like to see how someone else did it. thanks, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 varchars
Hello, What you say below is of great interest to me. Currently I have been writing front end code to handle the size issue but I would like to be open to other possibilities. So my question about your answer below is: Just how does the developer obtain the error condition from Mysql when an insert or update sends data that is too long to a field with a restricted size? Thanks -Original Message- From: Ralf Narozny [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:59 AM To: Desmond Lee Cc: [EMAIL PROTECTED] Subject: Re: question about varchars Hello! Desmond Lee wrote: Hello there Mysql documentation says the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there be anything wrong with making all my varchar's up to 255. That is defining most of my fields to be varchar(255) even when i know they may only go 100? There's nothing wrong with it for storage reasons only, but many database developers use lengths to restrict the size of the entries. For example storing the zipcodes from more than one country might need at max 15 characters, so why allowing 255, preventing MySQL to raise an error, if the ZIP is 100 chars long. Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Data Entry for a Newbie
At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html file to communicate with the server on my own computer? Any help is appreciated, Bill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and Filesystems
Hello everybody, someone can tell me the best FS to run MyISAM along with InnoDB tables ? SQL - For you-know-who -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [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: Joins, ANSI 92 or the old way
Hi. On Thu 2002-07-25 at 10:41:54 +0200, [EMAIL PROTECTED] wrote: [...] Personally I find the former much easier to read though not sure about the practical differences between them when the statements are executed. AFAICT, there should be no differences on execution speed. We tested a lot with JOINS and found out, that the more expressions in the WHERE clause the slower it gets, this is very obvious of course, but it is surprisingly true for JOINS too. If you mean writing JOIN with ON clause instead of , with WHERE clause, yes, that's because - AFAIK - both are converted to the same internal representation. That's why I said, there should be no difference. We tried to join about 10-15 tables together with LEFT JOIN and the old ','. The processing time differed drastically. Of course, LEFT JOIN and , (or INNER JOIN) are not the same thing. LEFT JOIN has to do more work, depending on the table content. On the other hand, LEFT JOIN fixes the join order, which can give a speed benefit, if the optimizer chooses the wrong join order. You would have to compare with STRAIGHT_JOIN set to exclude this. We tested this about 6 months ago with 3.23.36, so this may have be untrue now. BTW the processing time was about 1 second for the new syntax and up to 30 seconds for the old method. Do you really mean , with old syntax and inner join with new syntax? I have a hard time believing this, as my experience is differs. Greetings, Benjamin. -- [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
Storing Records Alphabetically
Hi I am storing a list of titles on a mysql db. Some of the records start with 'The','A' or 'An'. I would like to be able to enter the title in the form 'The Count .' instead of 'Count ..., The' and have the record stored as 'Count ' but displayed as 'The Count ...' when I display it. Is there any easy way to do this when doing the INSERT or SELECT statements? Any ideas would be gratefully received. Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 loses databases
I had this problem. For some reason MySQL has decided to look at your tmp directory (which contains vi.recover) instead of your data directory. Compiling with -DHAVE_BROKEN_REALPATH fixed it for me, on FreeBSD 4.6, linuxthreads and dual CPU. --Mike - Original Message - From: Dicky Wahyu Purnomo [EMAIL PROTECTED] To: Simas Cepaitis [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 9:04 AM Subject: Re: MySQL loses databases Pada Thu, 25 Jul 2002 09:28:45 +0200 Simas Cepaitis [EMAIL PROTECTED] menulis : Hello, Earlier i posted my message here, but haven't got any real solution. So now I'll try to post with some more details. I have a FreeBSD 4.6 box, dual cpu, runing MySQL. It runs with linuxthreads enabled and it is under heavy load all the time. Few weeks ago it started to work a little strange. MySQL runs ok for some period of time, and then it disallows connections from users, saying 'access not allowed for user@localhost'. Root can connect without problems. The strange thing is, that MySQL somehow 'loses' it's databases. When I connect as root, 'show databases' output gives me one database... vi.recover. So I suppose, that MySQL drops it's path somewhere, but I'm not sure why. The only workaround I have for now is run database check every minute, and restart MySQL if needed. After restart everything looks OK for some time ( one - two days)... This problem was with 3.23.49, and now I saw this with 3.23.51 too. Any ideas what could be wrong? vi.recover isn't it from VI application ??? Maybe someone is trying to do something inside your mysql data directory ... and somehow he damage your DB Try to investigate it from FILE side ;-) From my experiences, mysql never lost the databases ... because it's based on directory structure on your filesystem OS. eventhough it's mysql bug and your db corrupt, the directory should be still exist and you can see from show databases. -- printk(??? No FDIV bug? Lucky you...\n); 2.2.16 /usr/src/linux/include/asm-i386/bugs.h MySQL 3.23.51 : up 34 days, Queries : 354.952 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.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
how to retrieve data from two table?
Hi I have be scratching my head with this for a few days. I want to select data from 2 tables conditionally. 1 table has users, the other times relating to the users. I want to create a query that will select the user from the users table and if they have any time data against them (for that day) return that also. If there is not data for that day only the user data should be returned. If I do: SELECT u.id,u.surname,t.* FROM users u LEFT OUTER JOIN times t ON (u.id =t.id) WHERE u.id = 22; I get: 22|Price|NULL|NULL| NULL| NULL| NULL| NULL| NULL| NULL Which I could work with but once I add AND t.date = (current_date) I get 0 records returned and I need the users.id an users.surname. Can anyone think of a way round this? Thanx. Dp. sql,mysql,query. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with win98
Mysql engine is running under win98, then at the prompt I type mysql mysql then press enter and I have control. I can delete users (root included), whatever I want, so How can I make Mysql always require a username and a password to connect to it? Alex __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.
Francisco, Thursday, July 25, 2002, 2:46:39 AM, you wrote: FR When I try to execute scripts/mysql_install_db, I get FR some errors about some libraries missing: FR exec(): 0509-036 Cannot load program FR ./bin/my_print_defaults because of the following FR errors: FR 0509-150 Dependent module libz.a(shr.o) could not be FR loaded. FR 0509-022 Cannot load module libz.a(shr.o). FR 0509-026 System error: A file or directory in the path FR name does not exist. FR How can I get those libraries and what should I do FR once I get them? What version did you install? This problem was in 3.23.49, 3.23.50, 3.23.51 for AIX because of wrong build. MySQL developers are still working on a new build. -- 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
FIND_IN_SET index problem
Hi, I have a problem where the index for a SET column does not get used once I link in another table. The output to explain: mysql explain select count(*) from NS_articles where find_in_set('approved', artFlags) 0; +-+---+---+--+-+--+--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+--+-+--+--+-+ | NS_articles | index | NULL | artFlags | 2 | NULL | 560 | where used; Using index | +-+---+---+--+-+--+--+-+ This is good, the index on artFlags is being used. Now I link in another table: mysql explain select count(*) searchTotal from NS_articles nsa, NS_editors nse where find_in_set('approved', nsa.artFlags) 0 and nsa.artEditor = nse.id; +---+---+---+---+-++--+-+ | table | type | possible_keys | key | key_len | ref| rows | Extra | +---+---+---+---+-++--+-+ | nse | index | PRIMARY | PRIMARY | 32 | NULL | 21 | Using index | | nsa | ref | artEditor | artEditor | 32 | nse.id | 19 | where used | +---+---+---+---+-++--+-+ What happened to the index on artFlags? The table link uses indexes which is good, but now artFlags is doing a raw table scan. TIA Monte - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Selecting from one table to UPDATE another.
Hello! Simon Green wrote: What I am trying to do in MySQL. Table1 UserID ProductID Old_UserID 1 2 4 2 3 5 Table2 UserID ProductID 4 Null 5 Null Table1 has new correct data. Table2 has old incorrect data. The link is Table2.UserID and Old_UserID What I need to do is update Table 2 with the new data from Table 1, But I can not get this to work..e.g. UPDATE Table2.ProductID SET Table2.ProductID = Table1.ProductID WHERE Table1.Old_UserID = Table2.UserID REPLACE will not work as these are not KEY fields. Once I have done the ProductID I should then be able to do the UserID using the ProductID (as all values in one table are unique). SELECT concat('UPDATE Table2 SET ProductID = ', t1.ProductID, ' WHERE UserID = ', t1.UserID, ';' ) INTO OUTFILE '/tmp/update.sql' FROM Table1 t1 LEFT JOIN Table2 t2 ON (t1.Old_UserID = t2.UserID) WHERE t2.UserID IS NOT NULL ; \. /tmp/update.sql This might help...but better take a look at /tmp/update.sql, before executing it!!! Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error in solaris 8
Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.51 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: SunOS nehuen 5.8 Generic_108528-15 sun4u sparc SUNW,UltraAX-i2 Architecture: sun4 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.1/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls Thread model: posix gcc version 3.1 Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-co nstructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1764484 Jun 14 17:10 /lib/libc.a lrwxrwxrwx 1 root root 11 Jul 11 16:43 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146204 Jun 14 17:10 /lib/libc.so.1 -rw-r--r-- 1 root bin 1764484 Jun 14 17:10 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jul 11 16:43 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146204 Jun 14 17:10 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared CC=gcc 'CFLAGS=- O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc Perl: This is perl, version 5.005_03 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
strange backquote problem
Hi, On my application's setup.php I have quite simple MySQL queries like DROP TABLE IF EXISTS `ee_test` Now, some users (perhaps 5 out of 1000) complain that they get an SQL error on the first query with backquotes, and when I provided them with a setup file without any backquotes (luckily all my table and row names are very simple) like... DROP TABLE IF EXISTS ee_test ...and they reported that it worked just fine. Some users had an older MySQL, but this has been reported happen also in e.g. 3.23.39. PHP used is always 4.0.6 or newer. Any ideas why some MySQL's give error with standard backquotes and how to fix this??? I'd really like to know what is going on there. http://www.mysql.com/doc/L/e/Legal_names.html tells backquotes really must be there. Thanks, Pekka Saarinen http://photography-on-the.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: compiling mysql 3.23.37
because I have a cobalt server and the only version that they suggest are the 3.23.36 an 37, this is the reason about I don't wish re-install another version if I can. anyway thanks for its aid. sandra - Original Message - From: Ralf Narozny [EMAIL PROTECTED] To: SandraR [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Egor Egorov [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:22 AM Subject: Re: compiling mysql 3.23.37 How about downloading the source of a newer version??? If you are too lazy to search for the URL: http://www.mysql.com/downloads/index.html SandraR wrote: ok but I haven't a install folder as MySQLversion because the version that I have instaled is binary and the software are by all sides (/usr/bin and /var/lib) and in this folder I haven't a configure file. ¿what can I do? I don´t want install another version if it was possible. thanks. sandraR - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 5:07 AM Subject: Re: compiling mysql 3.23.37 SandraR, Tuesday, July 23, 2002, 6:04:42 PM, you wrote: S I need re-compiling mysql 3.23.37 in linux, how can I do this. S In the maestrosdelweb link said how is the compilation, the problem is that S these commands (./config and make) are not available from my install S folders. I have not a directory where I can found. S I have in: S /var/lib/mysql/ - the data bases S and in S /usr/bin/ - the commands. S The question is ¿how can I re-compile mysql 3.23.37?? Check docs: http://www.mysql.com/doc/Q/u/Quick_install.html shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make -- 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 -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Change string quote char
Hi, is it possible to change the default string quoting chars (')? I'm using MySQL with an older shop solution. The data to write has both: ' and chararcters. It isn't possible to escape those chars. Therefor I have to change the quoting char to a char that isn't used i.e #. Is it possible? Regards Lothar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Which binary fro which platforms?
I have a product for which I would like to use mySql to hold information used in a product demonstration. The product runs on Windows, HP, Solaris and AIX. The demonstration (and the mySql database) will be distributed with the product. I am trying to determine the correct binary distribution of mySql to distribute to end users. I would like to use stable releases only, in binary format. For Windows, the correct release is pretty clear. However, say a customer has HP 11.x. The current stable release on mysql.org is for hp 10.20 (mysql-3.23.51-hp-hpux10.20-hppa1); there is a release on sourceforge for hp 11.0 (mysql-hpux-11.0-hppa2), but is that considered stable? If not, can they use the binary for 10.20 instead? What if the customer later upgrades to a newer version of HP - must they then use a different version of the binary? Similar question pertain to Solaris (currently 2.8) and AIX (currently 4.3). Thanks for any pointers. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Do you run multiple servers on WIndows?
It's not uncommon to run multiple MySQL servers on a given Unix system. I'm wondering: Does anyone do this on Windows, and if so, what particular configuration issues did you have to solve to keep them from interfering with each other? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
*FREE* slides of an upcoming web presendation : MVC+ STANDARD tags
Subject: *FREE* slides of an upcoming web presendation : MVC+ STANDARD tags From: Vic C. [EMAIL PROTECTED] === Open source SQL web app: In order to facilitate discussion of the live web presentation (coming up in less than 24 hours) you can download the slides before the presentation; I have uploaded to basicportal.sourceforge.net. (Why attend the web presentation?: I have done more pubic and private hands on lab Struts training than all others combined When: tmrw at 8:30 am, it is only 20 minutes for those who know MVC already; register at www.proJ.com/webEx.jsp) You can post comments before or after to mvc-programmers mail group ( [EMAIL PROTECTED] is one place to join ) on basicPortal (aka: MVC+ STANDARD tags Vertical webApps good practices) Review the slides and ... download the application source code and maybe even deploy it. In case you do not know already, basicportal.sourceforge.net also has an open source download of sample web app using Struts + JSTL with DB CRUD (DB Insert, update, etc.) Also, *coming to a your city * -NYC 8/2 (Registration will close today) -Chicago 8/9 (Registration closes in a few days) -Atlanta 8/16 see www.basebeans.com/syllabus.jsp Also... web registration will close at 6PM Pacific time (today!) (like how I use the word FREE?, it's a big marketing word) Enjoy, Vic C. [EMAIL PROTECTED] - Phone 866-800-4503 Struts Mentor An engineer can show you how to do it faster and cheaper ps1: Web Open Standards news groups at http://news.netbean.net/cgi-bin/webnews.cgi ps2: Point you news reader, such as Outlook to news.baseBeans.com for Tomcat, Struts, JSTL, PostgreSQL, MySQL, Jakarta, etc. ps3: *FREE* Daily java news at http://www.baseBeans.com/dailyJava.jsp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting on Windows 2000 Server
Hi, I just downloaded the binaries. I have followed the installation instructions. Have run the command mysqld-max-nt --install-manual and checked the service panel and MySql is installed as a service. However when I either try to start the service in the service panel or issue the command net start mysql I get the following error message Could not start the MySQL service in local computer. Error 3 The System cannot find the path specified. Per the documentation my.ini file is in the WINNT directory and reads: [mysqld] # set basedir to installation path, e.g., c:/mysql basedir=the_install_path # set datadir to location of data directory, # e.g., c:/mysql/data or d:/mydata/data datadir=the_data_path Thanks for any help. Andrew Wheeler Phone 415-627-2054 email [EMAIL PROTECTED] _ IMPORTANT NOTICES: This message is intended only for the addressee. Please notify the sender by e-mail if you are not the intended recipient. If you are not the intended recipient, you may not copy, disclose, or distribute this message or its contents to any other person and any such actions may be unlawful. Banc of America Securities LLC(BAS) does not accept time sensitive, action-oriented messages or transaction orders, including orders to purchase or sell securities, via e-mail. BAS reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the BAS e-mail system. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_connections recovery
I've been running MySQL for 2 years with no problems. Yesterday, I increased the max_connections because I was getting too many connections error. This morning, the server again reached its limit but it never seemed to recover from it and constantly gave the too many connections error. I was forced to kill restart the server. does this sound familiar? this is version 3.23.44, btw. 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
Help me with my mysql...errormessage!
Mysql is not working. I get an error pop up which says: Winmysqladmin 1.3. : Error reading Memo2 - Lines.Strings: The parameter is incorrect. I get this message at startup and when I try to open winmysqladmin.exe. Before I restarted the computer everything was fine. Help anyone??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: hebrew/arabic language
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show characters of language such as hebrew/arabic? My best suggestion would be to store all your test in Unicode UTF-8 format and use the type BLOB in the table in order to store it. We do this and can quite happily mix english, japanese, russian and whatever else we like in the database (in the same sentance even). -pcf. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 update time field with current time?
William R. Mussatto wrote: On Wed, 24 Jul 2002, Dermot Paikkos wrote: Date: Wed, 24 Jul 2002 17:46:00 +0100 From: Dermot Paikkos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: how to update time field with current time? Hi Probably a silly question but how can I set a time field to the current time with update in mysql? I have 4 time fields per record. Should I have used set them up as timestamp? the function NOW(). Note you can have only one TimeStamp field in a table (i.e., one which will be automatically updated). The other ones should be datetime fields to avoid confusion. You can have more than one timestamp. They are all updated on an insert, but only the first will be updated with an update Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Data Entry for a Newbie
MySql Front, http://www.anse.de/mysqlfront/, is a win32 GUI for admin and data entry. Yes, you can use html and some web programming to communicate with MySQL. -Original Message- From: William Bradley [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 8:13 AM To: Mysql Subject: Data Entry for a Newbie At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html file to communicate with the server on my own computer? Any help is appreciated, Bill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Re: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.
Victoria, I am using mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar.gz, which is the latest version posted on your site. Also, when I try to compile mysql-3.23.51.tar.gz, I get the following error executing the make command: my_gethostbyname.c, line 81.5: 1506-068 (S) Operation between types struct hostent* and int is not allowed. make: 1254-004 The error code from the last command is 1. I am using GNU Make 3.79.1 Thanks in advance. Francisco, Thursday, July 25, 2002, 2:46:39 AM, you wrote: FR When I try to execute scripts/mysql_install_db, I get FR some errors about some libraries missing: FR exec(): 0509-036 Cannot load program FR ./bin/my_print_defaults because of the following FR errors: FR 0509-150 Dependent module libz.a(shr.o) could not be FR loaded. FR 0509-022 Cannot load module libz.a(shr.o). FR 0509-026 System error: A file or directory in the path FR name does not exist. FR How can I get those libraries and what should I do FR once I get them? What version did you install? This problem was in 3.23.49, 3.23.50, 3.23.51 for AIX because of wrong build. MySQL developers are still working on a new build. -- 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 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data Entry for a Newbie
phpMyAdmin if you have a webserver with php you can use. or you can use MyODBC and us MS Access to make a front end for data entry. -- Forwarded Message -- Subject: Data Entry for a Newbie Date: 25 Jul 2002 11:12:35 -0400 From: William Bradley [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html file to communicate with the server on my own computer? Any help is appreciated, Bill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- -- I have seen the future and it is just like the present, only longer. -- Kehlog Albran, The Profit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Data Entry for a Newbie
I would buy a book called PHP Essentials. www.thickbook.com I used it to learn how to write an html/php interface to my databases and i use it all the time now. It takes a bit of work to get the interfaces built but the book is really easy to follow and understand. seth -Original Message- From: William Bradley [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 9:13 AM To: Mysql Subject: Data Entry for a Newbie At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html file to communicate with the server on my own computer? Any help is appreciated, Bill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Data Entry for a Newbie
On 2002-07-25 07:12, William Bradley [EMAIL PROTECTED] wrote: At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html file to communicate with the server on my own computer? There are a number of GUI apps built for mySQL. You could also build a CGI form for data entry. I use Perl and there are many others that will also work, ie. PHP -- hcir [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
4.0.2 libmysqlclient.so.10 not found
I am in the process of testing out the 4.0 series of MySQL and am having some problems when I try to install the php-mysql RPM. The machine is a RedHat 7.2 i386 box with all current patches. I pulled down the source RPM for 4.0.2-2 and rebuilt the RPM's with debug enabled then installed all the necessary RPM's. Everything seems to be working ok on the MySQL side except that php is asking for libmysqlclient.so.10 and the only library installed with MySQL-shared is libmysqlclient.so.11. I tried a manual symlink from libmysqlclient.so.10 to libmysqlclient.so.11 and the php-mysql still complains that the library isn't present. I installed the php-mysql RPM with --nodeps just to test it out and sure enough I get 'Call to undefined function: mysql_pconnect' which is the same message you receive if you don't install the MySQL-shared RPM in the 3.0 series. I tried adding /usr/lib /usr/lib/mysql /etc/ld.so.conf and ran ldconfig which yielded the same results. Any thoughts on how I could get this library in place with 4.0.2? Thanks, Darren Young [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: question about varchars
Your application uses the field size and type to validate the data BEFORE sending it to MySQL. Norris, Joseph wrote: Hello, What you say below is of great interest to me. Currently I have been writing front end code to handle the size issue but I would like to be open to other possibilities. So my question about your answer below is: Just how does the developer obtain the error condition from Mysql when an insert or update sends data that is too long to a field with a restricted size? Thanks -Original Message- From: Ralf Narozny [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:59 AM To: Desmond Lee Cc: [EMAIL PROTECTED] Subject: Re: question about varchars Hello! Desmond Lee wrote: Hello there Mysql documentation says the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there be anything wrong with making all my varchar's up to 255. That is defining most of my fields to be varchar(255) even when i know they may only go 100? There's nothing wrong with it for storage reasons only, but many database developers use lengths to restrict the size of the entries. For example storing the zipcodes from more than one country might need at max 15 characters, so why allowing 255, preventing MySQL to raise an error, if the ZIP is 100 chars long. Greetings Ralf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Records Alphabetically
Hi. On Thu 2002-07-25 at 11:24:36 -0400, [EMAIL PROTECTED] wrote: Hi I am storing a list of titles on a mysql db. Some of the records start with 'The','A' or 'An'. I would like to be able to enter the title in the form 'The Count .' instead of 'Count ..., The' and have the record stored as 'Count ' but displayed as 'The Count ...' when I display it. Is there any easy way to do this when doing the INSERT or SELECT statements? Any ideas would be gratefully received. IMHO, the usual solution to this is to have a seperate column (e.g. sort) for sorting, i.e. a column containing only count ... which will be used in the ORDER BY clause: SELECT title FROM whatever WHERE [...] ORDER BY sort I do not think that there is an easy way, because there is no easy way to know what is special (in my experience there is more than A, An and The to be considered). Greetings, Benjamin. -- [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: how to retrieve data from two table?
Hi. On Thu 2002-07-25 at 16:44:19 +0100, [EMAIL PROTECTED] wrote: [...] I want to create a query that will select the user from the users table and if they have any time data against them (for that day) return that also. If there is not data for that day only the user data should be returned. SELECT u.id,u.surname,t.* FROM users u LEFT OUTER JOIN times t ON (u.id =t.id) WHERE u.id = 22; I get: 22|Price|NULL|NULL| NULL| NULL| NULL| NULL| NULL| NULL Which I could work with but once I add AND t.date = (current_date) I get 0 records returned and I need the users.id an users.surname. Can anyone think of a way round this? Unfortunately you did not provide your change in a full example, therefore I have to guess. I guess you put the additional condition in the WHERE clause. Because it relates to the times table and you want to see the users regardless, you have to put it in the ON clause, too: SELECT u.id, u.surname, t.* FROM users u LEFT OUTER JOIN times t ON u.id = t.id AND t.date = [current_date] WHERE u.id = 22 In other words, whenever you can say I want to see the content of the left table (here: user) even if there is no match in the right one (here: times), you have to put the condition in question into the ON clause of the LEFT JOIN instead of the WHERE clause (which would restrict the end result). Greetings, Benjamin. -- [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: problem with win98
Hi. On Thu 2002-07-25 at 11:44:26 -0400, [EMAIL PROTECTED] wrote: Mysql engine is running under win98, then at the prompt I type mysql mysql then press enter and I have control. I can delete users (root included), whatever I want, so How can I make Mysql always require a username and a password to connect to it? Please read the manual, section post-installation. You have to set a password for the root user. (a message after installation should have told you so) MySQL comes with permissive default privileges (without password) for localhost to ease first usuage. Greetings, Benjamin. -- [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
TRUNCATE TABLE
Hello mysql, Why after TRUNCATE TABLE data file with indexes not freed ? and TRUNCATE TABLE is very slow ... MySQL 3.23.51+InnoDB OS: Linux 2.4.18/ReiserFS Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Data Entry for a Newbie
Hello! two ways: Fun way: Get Perl and write some cgi using html/javascript front end Another way (maybe not as fun - but gets the job done): Enter data in Excel spreadsheet and export to comma delimited file. Then go and read the docs on mysqlimport command. Cheers! -Original Message- From: William Bradley [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 8:13 AM To: Mysql Subject: Data Entry for a Newbie At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html file to communicate with the server on my own computer? Any help is appreciated, Bill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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