Doubt regarding MySQL
As i am using MySQL in my project and i need and command which is equivakent to (TABLOCKX HOLDLOCKX) in SQLServer to lock a table while opening itself in MySQL using Visual C++. Please respond me soon as it is very urgent for me Regards Phani Kiran.A = Bye bye Phani Kiran.A __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.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
Bug in * ?
Hello all please respond to my address to, I`m not in the list! Look at this simple code: SELECT FLOOR(5000 * 0.112) AS A, FLOOR(5000 * 11.2 / 100) AS B /* why MySQL returns A = 560 and B = 559 ? */ I`ve tested either: SELECT FLOOR(5000 * 0.112) AS A, FLOOR(5000 * 11.2 * 0.01) AS B /* why MySQL returns A = 560 and B = 559 ? */ Is this a bug? Regards Lukas Zapletal [[EMAIL PROTECTED]] web programmer Bach systems Ltd., Czech Republic --- PGP FINGERPRINT 4BA4ECA3EDE9608558646ABBA14259E3459FA0B4 --- COOKIE - want embed Perl into HTML? http://perl.apache.org/embperl/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Issues
Luc, Luc Foisy wrote: MySQL version 3.23.32 (please don't ask me to upgrade to the newest version of mysql as an answer) I'm very sorry but an upgrade seems to be necessary: if I recall this correctly we had to upgrade to 3.23.33 a year ago or so because the changelog pointed towards a replication bug introduced in 3.23.32! --cut Regards, Frank. -- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with replication
Description: Hi! My name is Ales Perme. A college of mine Samo Login gave me this adress, which was given to him by Monty, to report MySQL bugs to. The first bug report today from me is connected with replication. Our production comprizes of Windows and Linux machines. MySQL verson we are using on production is 3.23.36-log and on our development setting 3.23.49-nt-log. On both of these versions we experiance the same bug. We experiance replication problems in the following configurations: 1. Windows NT 4 (master) - Windows NT 4 (slave) 2. Windows NT 4 (master) - Linux (slave) Linux to Linux and Linux to Windows works okay. The problem is as follows: Suppose we have a database called Trident3-P-0, with exactly that case! We replicate that database to the secondary with another name, with replication parameter replicate-rewrite-db. This is a part of my.cnf file with these settings on the slave machine: replicate-rewrite-db=Trident3-P-0-Trident3-S-0 replicate-rewrite-db=Trident3-P-1-Trident3-S-1 replicate-rewrite-db=Trident3-P-2-Trident3-S-2 I usualy connect to MySQL server running Windows NT 4.0 with mysql -h master.hostname.domain -u user -ppassword and with a USE statement change the active database to Trident3-P-0. Whatever I do on that databese on master now DOES NOT replicate to slave. I trided to use all kinds of cases when changing the database on master - no change of replication behaviour! Fix: Now, I found out that if instead of using USE I use \r command then the replication magicaly starts to work. So if I type \r Trident3-P-0 instead of USE Trident3-P-0 then the replication to Trident3-S-0 on the slave machine starts to work. Replication also works if I connect to the database at the time of establishing connection with the server. So if I connect to the master server using mysql -h master.hostname.domain -u user -p password Trident3-P-0 then replication also works. The problem applyes to configurations when we replicate from windows master to windows slave or windows master to linux slave. Obviously there is a problem with the windows version of mysql. With best regards, Ales Perme IT Manager Novifroum Ltd. Stegne 31 Ljubljana S L O V E N I A Submitter-Id: submitter ID Originator:Ales Perme Organization: Noviforum Ltd. MySQL support: none Synopsis: Replication problems Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.42 (Official MySQL binary) Server: /export/software/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.42-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 7 days 10 min 2 sec Threads: 12 Questions: 133693547 Slow queries: 1244 Opens: 366 Flush tables: 13 Open tables: 90 Queries per second avg: 220.834 Environment: System: Linux majstr1 2.4.18 #1 SMP tor mar 19 19:43:16 CET 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 sep 21 2001 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 4783716 maj 26 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 24721042 maj 26 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 maj 26 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table crash!
Description: Hi! My name is Ales Perme. A college of mine Samo Login gave me this adress, which was given to him by Monty, to report MySQL bugs to. Production configurations: 1. Windows NT 4.0, Service pack 6a, MySQL 3.23.36 2. Slackware Linux, kernel version: SMP 2.4.18, MySQL 3.23.42-log The structure of the table we are experianceing problems with is: CREATE TABLE `repository` ( `DIGEST` varchar(32) NOT NULL default '', `CONTENT` longblob NOT NULL, `CONTENT_TYPE` varchar(60) NOT NULL default '', `CONTENT_LENGTH` int(11) NOT NULL default '-1', `CONTENT_LANGUAGE` tinyblob, `LAST_MODIFIED` datetime default NULL, `LAST_ACCESSED` datetime NOT NULL default '-00-00 00:00:00', `CONTENT_TIMESTAMP` datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`DIGEST`), KEY `REPOSITORY_LAST_ACCESSED` (`LAST_ACCESSED`) ) TYPE=MyISAM MAX_ROWS=4 The table has mysql select count(*) from repository; +--+ | count(*) | +--+ | 5673838 | +--+ records inside. 1. I get table a table crashed whenever I try to fix it or check it with MYISAMCHK using -r, -o or -f parameters. And the table is then no longer usable. 2. BACKUP TABLE repository to ... gives a response code OK. Successfull! But when I try to restore it with RESTORE TABLE repository FROM ..., the restore fails and tryes to restore the table without quicksort. MySQL server on Windows NT 4.0, Service Pach 6a crashes with drwatson. 3. If I check the table with SQL statement CHECK TABLE repository then I get an OK! result code. What can I do? What seems to be the problem. If you need any aditional info please contact me. The table itself is 13.1 GB in size and index is 430 MB. With best regards, Ales Perme IT Manager Novifroum Ltd. Stegne 31 Ljubljana S L O V E N I A How-To-Repeat: 1. I get table a table crashed whenever I try to fix it or check it with MYISAMCHK using -r, -o or -f parameters. And the table is then no longer usable. 2. BACKUP TABLE repository to ... gives a response code OK. Successfull! But when I try to restore it with RESTORE TABLE repository FROM ..., the restore fails and tryes to restore the table without quicksort. MySQL server on Windows NT 4.0, Service Pach 6a crashes with drwatson. Fix: None available! Submitter-Id: submitter ID Originator:Ales Perme Organization: Noviforum Ltd. MySQL support: none Synopsis: Table crash! Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.36 (Official MySQL binary) Server:3.23.36 for Windows NT Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36-log Environment: System: Windows NT Server v4.0 , Service pack 6a Architecture: i686 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance of ORDER BY on an indexed column
I'm a little bit confused about what EXPLAIN is saying about a query I'm doing with an ORDER BY clause. I've read and re-read the parts of the manual about how ORDER BY is optimized, but it won't sink in to my thick skull for some reason. I've got an index on a column called price, which is an INT: mysql show columns from homes like 'price' \G *** 1. row *** Field: price Type: int(11) Null: YES Key: MUL Default: NULL Extra: 1 row in set (0.00 sec) which I frequently sort by. EXPLAIN says that a filesort is necessary to do this: mysql explain select * from homes order by price \G *** 1. row *** table: homes type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 3628 Extra: Using filesort 1 row in set (0.00 sec) even when I do an ALTER TABLE homes ORDER BY price. Why is a filesort required to sort these rows? Is this something I should worry about as this system goes from 1500 queries/day to 15000 queries/day to 15 queries/day? Is there something I can do that is faster? Sorry if this is a stupid question; this is the first database I've designed where I've had to put much thought into performance. Thanks for any info or pointers to documentation, -ScottG. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Joining Multiple Listings
Greetings, I'm having a real problem with this one, so I hoped I could seek some guidance from the guru's inhabiting the mailing list, and then hopefully in the future I can offer some assistance myself... (Skip down four paragraphs if in a hurry!) My wife, who always wanted her own bookshop, decided to try selling online instead, right now through the services of half.com - so far she's doing well. However, she's making enough sales where it'll soon be time to have her own site instead. To accomplish this, I figured it would be easier, rather than scanning the UPC in from each book and starting from scratch again, to grab information from half.com's current list, then we expand ourselves from there. We also have the services of a wonderful program called ReaderWare, available at www.readerware.com - I don't normally plug peoples' products, believe me, but this has been invaluable. Regardless, I've ended up with two tables - one containing the information I got from half.com (ISBN, UPC, price, condition, name, author), and one from Readerware (ISBN, name, author, subject, etc). Now joining those two tables together to end up with the perfect listing - which would contain the ReaderWare complete details coupled with the half.com price and condition - wouldn't be too difficult at all. I'm having trouble because both tables contain multiple listings of some books (with different prices and conditions), with the only field related between them being the ISBN, the other fields are not guaranteed to match every time. So, before I bore you all to death, rather than write a long complicated PHP script to figure this all out, I figured that MySQL would have no problem joining these two tables together and producing the perfect output table for my needs. It's 3:30am, and my contacts are blurring up on me I'm stumped! Unfortunately, joins aren't my strongest point. I've tried a variety of different SELECT statements, and usually end up with multiple listings as they are supposed to be, but all with the same price, for example. Help! I would include a few of my failed SQL statements, but I don't want to get laughed at. :) To conclude... two tables (books and half), both contain an ISBN field (books_isbn and half_isbn), the first table will comprise the name (books_name), author (books_author), and description (books_description), the second table will comprise the price (half_price) and condition (half_condition), and the books table will contain multiple entries with the exact same information - apart from the id number, of course, while the half table contains multiple entries with the same ISBN, but different conditions and prices. Sorry for the long version, but I figured a detailed explanation would probably help. missysbooks.com may get there someday! Thanks for your time, and I'd appreciate a CC to my own email address ([EMAIL PROTECTED]) as well as to the mailing list. Have fun, Rob Beckett. www.subwolf.org www.blueprinthosting.com www.opticblue.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
- Error 127
Hello mysql, Hello What is .. the Got error 127 from table handwler Pl send me error table ... My english is very bad sory -- Best regards, maxim mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [sql_yacc.o] Error 1
root, Thursday, April 4, 2002, 9:07:43 PM, you wrote: r When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error: r sql_yacco.yy:719: Parse error before '}' r sql_yacco.yy:1462: Parse error before '}' r sql_yacco.yy:1689: Parse error before '}' r sql_yacco.yy:1723: Parse error before '}' r sql_yacco.yy:1746: Parse error before '}' r sql_yacco.yy:1801: Parse error before '}' r sql_yacco.yy:2269: Parse error before '}' r sql_yacco.yy:2437: Parse error before '}' r make[3]: *** [sql_yacc.o] Error 1 r make[2[: *** [all-recursive] Error 1 r Probably this may happen because of a wrong parser. Try to use bison. r Cj B -- For technical support contracts, goto https://order.mysql.com/ 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: Authentication messed up?
Dan, Friday, April 05, 2002, 3:21:46 AM, you wrote: DE I tried to add a user to my mysql system for the MTA (exim) but am having a DE hard time making it work. DE I used grant to give exim permissions: DE grant ALL PRIVILEGES on exim.* to exim@localhost IDENTIFIED BY PASSWORD DE exim pw; DE and the exim database does exist, BUT. DE [root@shortcircuit root]# mysql exim -u exim -p DE Enter password: exim pw DE ERROR 1045: Access denied for user: 'exim@localhost' (Using password: YES) DE [root@shortcircuit root]# DE Any ideas? Why can user exim not access the exim database? You have used wrong GRANT syntax. I have tested you example, look at the row from user table: | Host | User | Password | Select_priv | [skip] | localhost | exim | exim pw| N | N [skip] ^^ Your password is not encrypted. You should use: GRANT ALL PRIVILEGES ON exim.* TO 'exim'@'localhost' IDENTIFIED BY 'exim pw'; DE Thanks! -- For technical support contracts, goto https://order.mysql.com/ 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: - Error 127
maxim, Friday, April 05, 2002, 2:35:01 PM, you wrote: m What is .. the Got error 127 from table handwler m Pl send me error table ... $ perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed You can try to repair your table using myisamchk or REPAIR TABLE statement. Read info about myisamchk at: http://www.mysql.com/doc/T/a/Table_maintenance.html and about REPAIR TABLE at: http://www.mysql.com/doc/R/E/REPAIR_TABLE.html -- For technical support contracts, goto https://order.mysql.com/ 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: mysql users
Marnix, Friday, April 05, 2002, 10:15:56 AM, you wrote: MV I am setting up a mysql database and have a questions about users. MV I would like everybody to have the possibility to consult the database MV without having to introduce a user and /or password (even not showing the MV screen for user and password). MV Only a few people will have to possibility to insert or modify data. Those MV people would have to introduce a user and a password. MV Is this possible and how should I do this. You can set up basic privileges (f.e. SELECT privileges) for default user '' and more privileges to your certain users. Look at: http://www.mysql.com/doc/G/R/GRANT.html MV Thank you very much in advance for your help. MV Marnix -- For technical support contracts, goto https://order.mysql.com/ 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: help me
prajak, Friday, April 05, 2002, 7:50:44 AM, you wrote: pp mysql select distinct(nexthop) ip from NameRoute pp where OwnerIP='10.0.1.1' and pp nexthop not in (select ip from NameIP where pp OwnerIP='10.0.1.1'); pp ERROR 1064: You have an error in your SQL syntax near pp 'select ip from NameIP whe pp re OwnerIP='10.0.1.1')' at line 1 Sub-selects is not currently supported in MySQL. How you can re-write your query, read at: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html http://www.mysql.com/doc/J/O/JOIN.html -- For technical support contracts, goto https://order.mysql.com/ 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: mysql
Syamala, Friday, April 05, 2002, 7:30:47 AM, you wrote: SS 1. Is authentication check based on user table in mysql database. user, db and host tables are used for access control. SS 2. If there is a unix user, then only giving password through grant SS command will suffice ..How the entry of that user got created in the SS user table. Unix user accounts and MySQL user accounts are completely different and has nothing to do with each other. The information on how to add new user is in the manual on: http://www.mysql.com/doc/A/d/Adding_users.html http://www.mysql.com/doc/G/R/GRANT.html SS regards SS Syamala -- For technical support contracts, goto https://order.mysql.com/ 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: Problem with starting safe_mysqld
Satyanarayana, Thursday, April 4, 2002, 9:53:53 PM, you wrote: SVR I have installed the source code of version 3.23.47, the most stable version. The most stable version is 3.23.49, not .47. SVR I am working on Redhat linux 7.0 version. SVR I have complied it, made some changes (have put some printf's), SVR recompiled and it works fine. So it works fine or it catches SIG11 ? SVR mysqld got signal 11; Usually this happens if MySQL is compiled using wrong libraries and compilers (the case when you do compile MySQL or a raw Red Hat). Compiling MySQL by yourself is tricky. As for other details, developers will answer. SVR Satya -- For technical support contracts, goto https://order.mysql.com/ 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: Finding missing items in a series
Paul DuBois wrote: You need to create another table that has a row for each date in the range, then use that table in a LEFT JOIN to your original table to find rows in the date table that are not represented by your original table. Thank you Paul, your sql table building script and your query worked like a charm. George - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Privileges for backups
I have got a backup script that locks the MySQL tables then use cp(unix) to copy the tables. It then tar, then zips them up. So my queston is what is the minimum privileges that this MySQL back user needs just to lock tables? Thanks Simon Green -- Live Life in Broadband www.telewest.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
microsoft uses MySQL too?
Anyone seen this yet http://www.theregister.co.uk/content/53/24714.html good advert for MySQL if it's true!? (if you want a commercial grade, fully cross platform database, then get MySQL) Bob Cross. Spam filter bypass: mysql database table query Disclaimer: my opinion and no one elses. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: microsoft uses MySQL too?
Cute story...but I have to agree with the Register when they state also in the article, For the record, can we just add that few subjects are as tedious or overrated as ideological purity? -Original Message- From: Robert Cross [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:09 AM To: [EMAIL PROTECTED] Subject: microsoft uses MySQL too? Anyone seen this yet http://www.theregister.co.uk/content/53/24714.html good advert for MySQL if it's true!? (if you want a commercial grade, fully cross platform database, then get MySQL) Bob Cross. Spam filter bypass: mysql database table query Disclaimer: my opinion and no one elses. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Power ?
From: Richard Spangenberg [EMAIL PROTECTED] Can mySQL handle... ...as well as Oracle. MySQL is different than the big databases like Oracle, Informix, etc. MySQL is comparatively small and fast, also cheap. As such, it doesn't come with all of the bells and whistles that others might. You may not need built-in tools like clustering when you see the relative cost. For instance, if you have to pay $50,000 to get an Oracle solution to a problem, or could use MySQL and spend $10,000 on in-house programming for that solution, which is better? --- Rodney Broom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Power ?
[EMAIL PROTECTED] wrote: I don't mean to start an opinion war, but ... Can mySQL handle many processors, many servers (clustering), load ballancing, etc as well as Oracle. Or should one use Oracle (some other database) for large volume high response requirements. Is mySQL too basic for these capabilities? Pros and Cons, please. This should help settle an internal debate that is raging! Something from the MySQL front page: http://www.eweek.com/article/0,3658,s=708a=23115,00.asp -- John Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School | Nihil Interit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me
hello, mysql doesn't support sub-select yet...maybe in 4.1 ;) mysql select distinct(nexthop) ip from NameRoute where OwnerIP='10.0.1.1' and nexthop not in (select ip from NameIP where OwnerIP='10.0.1.1'); ERROR 1064: You have an error in your SQL syntax near 'select ip from NameIP whe re OwnerIP='10.0.1.1')' at line 1 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query's Speed
hi, in perl: [very simple code] my $stime = time; prepare(); execute(); fetchall_array_ref(); my $etime = time; my $ftime = $etime - $stime; print Your query took $ftime seconds\n; stupid filter: sql, query, mysql, db, table, select, insert, update, delete, join, create, left join, optimize, describe, show, status, grant cheers, lms Hi there, Lets say i do the following query: mysql select something from some_table; Then i will get the results , how many rows and how much time it took to perform the query. My question is how can i get the time it took for perform the query. I want that cuz i would like to put in a web page something like Your query took 0.04 seconds. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Power ?
I don't mean to start an opinion war, but ... Can MySQL handle many processors, many servers (clustering), load ballancing, etc as well as Oracle. Or should one use Oracle (some other database) for large volume high response requirements. Is mySQL too basic for these capabilities? Pros and Cons, please. This should help settle an internal debate that is raging! I will look forward to hearing the response of the well-informed to this. However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). (Or have I just fallen for Oracle propaganda?) Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: MySQL Power ?
Thanks to all the reponders. Just what I needed! sql, query = filter pass - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Escaped by 2 things?
Since you are writing out the file, you must select which character to ESCAPE with. How would you expect mysql to choose? -Original Message- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 11:46 PM To: [EMAIL PROTECTED] Subject: Escaped by 2 things? Short and simple, is it possible to escape by two different parameters? This used to work: SELECT * from allusa WHERE (updated_by='I' or updated_by='A' or updated_by='L') AND (id9) AND last_updated '2002020100' ORDER BY last_updated INTO OUTFILE '/home/www/site/admin/admin/dbdump/bb200202010700.txt' FIELDS TERMINATED BY ' ' ENCLOSED BY '' ESCAPED BY ('' '\n'); but now it gives the error: ERROR 1064: You have an error in your SQL syntax near ' ' '' at line 1 anyone know if this is possible? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Power ?
Actually, according to the objective eWeek test results at the link provided in another reply, the gap between Oracle 9i and MySQL 4.x is rather slim... I will look forward to hearing the response of the well-informed to this. However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). (Or have I just fallen for Oracle propaganda?) Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Power ?
For what a newbies opinion may matter, I breifly worked with Oracle, and am working with MySQL. Fact, as it may be, I will never look for or take a job where they are using the P.O.S. Oracle. Oracle is not stable enough, it bombs if you make one misleading query. MySQL just says eh, try again. Heaven forbid you want to call a memory stack in Oracle and puipe the results to the db, and if you do, you had better have all of your ducks squared away, you can ever so easily corrupt the database if you don't. Oracle doesn't have enough intuition either. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:16 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL Power ? I don't mean to start an opinion war, but ... Can MySQL handle many processors, many servers (clustering), load ballancing, etc as well as Oracle. Or should one use Oracle (some other database) for large volume high response requirements. Is mySQL too basic for these capabilities? Pros and Cons, please. This should help settle an internal debate that is raging! I will look forward to hearing the response of the well-informed to this. However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). (Or have I just fallen for Oracle propaganda?) Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Problems with UPDATE in v3.23.49 (is this a bug)
I have a table whose schema contains: id INTEGER AUTO_INCREMENT, gen_time TIMESTAMP, rec_time TIMESTAMP, repeats INTEGER DEFAULT 0, PRIMARY KEY (id), INDEX (rec_time)) When I do an: UPDATE table SET repeats=repeats+1 gen_time gets updated as well: mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020404164500 | 20020405111308 | 0 | ++++-+ 1 row in set (0.01 sec) mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020405112158 | 20020405111308 | 3 | ++++-+ 1 row in set (0.02 sec) Is this a bug or am I forgetting something? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Power ?
I'm currently running MySQL for a big, fast app without problems. BUT: I'm in the middle of specifying a new application with a high load, and I'm consideing looking for alternatives to MySQL because without InnoDB, it gets really slow on tables with frequent updates and reads (no row locking). We have, for example, a session table that records all the incoming requests for holding state. Since it's constantly being updated and read, it is frequently locked, and there are often instances where 50 reads will stack up while a lock is held. This slows down the whole database. With InnoDB, I'm sure this problem goes away, but as soon as we go to InnoDB, we have to pay for backups and support, which means we start looking around at 'pay' solutions. Is there something I'm missing? Steve However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Command Line Tool
I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt binary version to accept The Command - Line Tool to run a script to create a table. My operating system is Windows 2000 Professional. I can connect with MyODBC-3.51.02.exe without any problem and run successful queries. I am using the model example from chapter 4.8.2 The Command-line Tool. I am trying to create a table in the test database example in MySQL I am logged in correctly and using the test database that is created when MySQL is installed as best as I can tell by reviewing the command line mysql status. I am issuing the command line statement at the mysql prompt: mysql test create.sql; I get the following mysql error: ERROR 1064 You have an error in your SQL near 'mysql test create1.sql' at line 1 Basically, I have a script named create1.sql with the following syntax: CREATE TABLE Names ( NameID int(11) NOT NULL auto_increment, FirstName varchar(30) NOT NULL default '', LastName varchar(30) NOT NULL default '', PRIMARY KEY (NameID), KEY idx_Names_LastFirst (LastName,FirstName) ) TYPE=MyISAM; INSERT INTO Names VALUES (1,'Morton','Salter'); INSERT INTO Names VALUES (2,'Jimi','Filmore'); INSERT INTO Names VALUES (3,'Eustace','Shoe'); INSERT INTO Names VALUES (4,'Archy','Roche'); INSERT INTO Names VALUES (5,'Catherine','LaGrande'); Anyone got any suggestions? Thanks In Advance Lenny R. Sorey FatDot.com [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: Escaped by 2 things?
At 21:45 -0800 4/4/02, Cliff wrote: Short and simple, is it possible to escape by two different parameters? This used to work: I think you are mistaken. I just checked the grammar files for 90 versions of MySQL, and that syntax isn't legal in any of them. I don't see how it could be legal, either. Should MySQL have to escape a character, which escape character would it use? SELECT * from allusa WHERE (updated_by='I' or updated_by='A' or updated_by='L') AND (id9) AND last_updated '2002020100' ORDER BY last_updated INTO OUTFILE '/home/www/site/admin/admin/dbdump/bb200202010700.txt' FIELDS TERMINATED BY ' ' ENCLOSED BY '' ESCAPED BY ('' '\n'); but now it gives the error: ERROR 1064: You have an error in your SQL syntax near ' ' '' at line 1 anyone know if this is possible? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Power ?
just wanted to add another category of comparison: mysql is fast, reliable and scalable. that's a fact! we don't need to discuss this anymore. BUT: the sql-set is too limited for most of the real use cases out there. just think of the missing sub-selects or multitable-updates/deletes or stored procedures. i worked with m$ sqlserver and oracle for years and i really miss these features in mysql. i am looking forward to see version 4.x having these things. mysql rocks and oracle is really expensive :) so i continue using mysql for almost all projects. cheers, pero -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 6:25 PM To: MySQL Lists Subject: RE: MySQL Power ? For what a newbies opinion may matter, I breifly worked with Oracle, and am working with MySQL. Fact, as it may be, I will never look for or take a job where they are using the P.O.S. Oracle. Oracle is not stable enough, it bombs if you make one misleading query. MySQL just says eh, try again. Heaven forbid you want to call a memory stack in Oracle and puipe the results to the db, and if you do, you had better have all of your ducks squared away, you can ever so easily corrupt the database if you don't. Oracle doesn't have enough intuition either. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:16 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL Power ? I don't mean to start an opinion war, but ... Can MySQL handle many processors, many servers (clustering), load ballancing, etc as well as Oracle. Or should one use Oracle (some other database) for large volume high response requirements. Is mySQL too basic for these capabilities? Pros and Cons, please. This should help settle an internal debate that is raging! I will look forward to hearing the response of the well-informed to this. However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). (Or have I just fallen for Oracle propaganda?) Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problems with UPDATE in v3.23.49 (is this a bug)
No, this is NOT a bug. According to the manual (you read it, right?), TIMESTAMP is created so that when a record is UPDATEd or INSERTed, the time of the change is entered into the record. If you want a date that does not changem use the DATE fiel -Original Message- From: Hihn Jason [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:33 AM To: '[EMAIL PROTECTED]' Subject: Problems with UPDATE in v3.23.49 (is this a bug) I have a table whose schema contains: id INTEGER AUTO_INCREMENT, gen_time TIMESTAMP, rec_time TIMESTAMP, repeats INTEGER DEFAULT 0, PRIMARY KEY (id), INDEX (rec_time)) When I do an: UPDATE table SET repeats=repeats+1 gen_time gets updated as well: mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020404164500 | 20020405111308 | 0 | ++++-+ 1 row in set (0.01 sec) mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020405112158 | 20020405111308 | 3 | ++++-+ 1 row in set (0.02 sec) Is this a bug or am I forgetting something? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problems with UPDATE in v3.23.49 (is this a bug)
At 18:33 +0200 4/5/02, Hihn Jason wrote: I have a table whose schema contains: id INTEGER AUTO_INCREMENT, gen_time TIMESTAMP, rec_time TIMESTAMP, repeats INTEGER DEFAULT 0, PRIMARY KEY (id), INDEX (rec_time)) When I do an: UPDATE table SET repeats=repeats+1 gen_time gets updated as well: Of course. That's how TIMESTAMP works. The manual is your friend: http://www.mysql.com/doc/D/A/DATETIME.html mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020404164500 | 20020405111308 | 0 | ++++-+ 1 row in set (0.01 sec) mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020405112158 | 20020405111308 | 3 | ++++-+ 1 row in set (0.02 sec) Is this a bug or am I forgetting something? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with UPDATE in v3.23.49 (is this a bug)
From: Hihn Jason [EMAIL PROTECTED] I have a table whose schema contains: id INTEGER AUTO_INCREMENT, gen_time TIMESTAMP, rec_time TIMESTAMP, repeats INTEGER DEFAULT 0, PRIMARY KEY (id), INDEX (rec_time)) When I do an: UPDATE table SET repeats=repeats+1 gen_time gets updated as well: mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020404164500 | 20020405111308 | 0 | ++++-+ 1 row in set (0.01 sec) This is a MySQL feature -- the first TIMESTAMP type column in a row will be updated automatically when anything else in that row is updated. -- denonymous www.coldcircuit.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: Command Line Tool
At 10:29 -0600 4/5/02, Lenny Sorey wrote: I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt binary version to accept The Command - Line Tool to run a script to create a table. My operating system is Windows 2000 Professional. I can connect with MyODBC-3.51.02.exe without any problem and run successful queries. I am using the model example from chapter 4.8.2 The Command-line Tool. I am trying to create a table in the test database example in MySQL I am logged in correctly and using the test database that is created when MySQL is installed as best as I can tell by reviewing the command line mysql status. I am issuing the command line statement at the mysql prompt: mysql test create.sql; That's your problem. Issue that command from the DOS prompt. I get the following mysql error: ERROR 1064 You have an error in your SQL near 'mysql test create1.sql' at line 1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problems with UPDATE in v3.23.49 (is this a bug)
Yes I did, but it is very long, and it was very long ago. Could someone please explain to me why this was done? It seems more confusing to do this than to not do this. Why when you can just say SET field=NOW() in the update statement would anyone build this auto update of timestamps in? (the kicker is you HAVE to do it for all timestamps in a schema past the first) Additionally, what if I wanted the time stamp format (without formatting (spaces, colons, and dashes)) (which I do) A very illogical feature I must say... Anyone agree with me? (Forgive me Rick, I didn't hit reply to all) -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 11:34 AM To: Hihn Jason; '[EMAIL PROTECTED]' Subject: RE: Problems with UPDATE in v3.23.49 (is this a bug) No, this is NOT a bug. According to the manual (you read it, right?), TIMESTAMP is created so that when a record is UPDATEd or INSERTed, the time of the change is entered into the record. If you want a date that does not changem use the DATE fiel -Original Message- From: Hihn Jason [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:33 AM To: '[EMAIL PROTECTED]' Subject: Problems with UPDATE in v3.23.49 (is this a bug) I have a table whose schema contains: id INTEGER AUTO_INCREMENT, gen_time TIMESTAMP, rec_time TIMESTAMP, repeats INTEGER DEFAULT 0, PRIMARY KEY (id), INDEX (rec_time)) When I do an: UPDATE table SET repeats=repeats+1 gen_time gets updated as well: mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020404164500 | 20020405111308 | 0 | ++++-+ 1 row in set (0.01 sec) mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020405112158 | 20020405111308 | 3 | ++++-+ 1 row in set (0.02 sec) Is this a bug or am I forgetting something? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problems with UPDATE in v3.23.49 (is this a bug)
According to the manual, the DATETIME field can be stored As a string with no delimiters in either 'MMDDHHMMSS' or 'YYMMDDHHMMSS' format, provided that the string makes sense as a date. So this should provide you with the format you require. TIMESTAMP was created so that we would NOT have to make an extra call to NOW() when doing INSERTs Finally, you replied directly to me, instead of the list, but I'll forward to list here... As for my 2 cents, I prefer TIMESTAMP to do as it does -Original Message- From: Hihn Jason [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:48 AM To: 'Rick Emery' Subject: RE: Problems with UPDATE in v3.23.49 (is this a bug) Yes I did, but it is very long, and it was very long ago. Could someone please explain to me why this was done? It seems more confusing to do this than to not do this. Why when you can just say SET field=NOW() would anyone build this auto update of timestamps in? (the kicker is you HAVE to do it for all timestamps in a schema past the first) Additionally, what if I wanted the time stamp format (without formatting (spaces, colons, and dashes)) (which I do) A very illogical feature I must say... Anyone agree with me? -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 11:34 AM To: Hihn Jason; '[EMAIL PROTECTED]' Subject: RE: Problems with UPDATE in v3.23.49 (is this a bug) No, this is NOT a bug. According to the manual (you read it, right?), TIMESTAMP is created so that when a record is UPDATEd or INSERTed, the time of the change is entered into the record. If you want a date that does not changem use the DATE fiel -Original Message- From: Hihn Jason [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:33 AM To: '[EMAIL PROTECTED]' Subject: Problems with UPDATE in v3.23.49 (is this a bug) I have a table whose schema contains: id INTEGER AUTO_INCREMENT, gen_time TIMESTAMP, rec_time TIMESTAMP, repeats INTEGER DEFAULT 0, PRIMARY KEY (id), INDEX (rec_time)) When I do an: UPDATE table SET repeats=repeats+1 gen_time gets updated as well: mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020404164500 | 20020405111308 | 0 | ++++-+ 1 row in set (0.01 sec) mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql update table set repeats=repeats+1 where id='1'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select id, gen_time, rec_time, repeats from table; ++++-+ | id | gen_time | rec_time | repeats | ++++-+ | 1 | 20020405112158 | 20020405111308 | 3 | ++++-+ 1 row in set (0.02 sec) Is this a bug or am I forgetting something? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Power ?
Agreed. As soon as subselects and the Stored Procedure support is complete I can almost ditch MSSQL entirely... BUT: the sql-set is too limited for most of the real use cases out there. just think of the missing sub-selects or multitable-updates/deletes or stored procedures. i worked with m$ sqlserver and oracle for years and i really miss these features in mysql. i am looking forward to see version 4.x having these things. mysql rocks and oracle is really expensive :) so i continue using mysql for almost all projects. cheers, pero -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 6:25 PM To: MySQL Lists Subject: RE: MySQL Power ? For what a newbies opinion may matter, I breifly worked with Oracle, and am working with MySQL. Fact, as it may be, I will never look for or take a job where they are using the P.O.S. Oracle. Oracle is not stable enough, it bombs if you make one misleading query. MySQL just says eh, try again. Heaven forbid you want to call a memory stack in Oracle and puipe the results to the db, and if you do, you had better have all of your ducks squared away, you can ever so easily corrupt the database if you don't. Oracle doesn't have enough intuition either. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:16 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL Power ? I don't mean to start an opinion war, but ... Can MySQL handle many processors, many servers (clustering), load ballancing, etc as well as Oracle. Or should one use Oracle (some other database) for large volume high response requirements. Is mySQL too basic for these capabilities? Pros and Cons, please. This should help settle an internal debate that is raging! I will look forward to hearing the response of the well-informed to this. However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). (Or have I just fallen for Oracle propaganda?) Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[O/T] problem with the list and Eudora/attachments
I've been having an off-list discussion with gordon52 at slingshot dot co dot nz, who is having a problem posting anything to the list. Apparently when he sends something, the list manager thinks it's got attachments and bounces it. Now when he sends me a message - no attachments. Can anyone out there in MySQL-land help, since I'm using Lotus Notes, and not Eudora? At this 16:45 5/04/02 +0200 told us all something interesting :- Your message cannot be postsed to mysql@ because it contained an attachment. If you need to make a file publically available you should upload it to some public URL, and then paste the URL into your message instead of trying to send it to everyone on the list. Disallowing attachments protects our list from being used to spread a virus. If you do not remember sending a message to the this list, it is possible that your computer has been infected by a virus which tried to spread itself using our list. It is also possible that some spammer used your e-mail address to hide his identity. Some mail clients default to sending messages in HTML or multipart format. In this case, your message will also appear as if it has an attachment. Such message formats increase the volume of traffic, and cause readability problems in some mail programs without providing any extra value. Such formats are also frequently used by spammers. For these reasons we disallow such messages. You should disable them in your mail program to be able to post. We have tried to look up the information on how to turn off HTML/multipart in your e-mail program, but our bot unfortunately does not know how to do it for QUALCOMM Windows Eudora Version 5.1, which is what you appear to be using. Please consult the manual of your e-mail program on how to send messages in plain text. Regards Bob Cross filter bypass: mysql database table sql query * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
authentication problem
Hey guys, We're having a weird authentication problem. We have a .jsp (on box1) that tries to connect to a MySQL database (on box2). The privileges have been set to give insert, update, delete to the user. GRANT select, insert, update on d_name.* to d_user IDENTIFIED by d_user; It works fine one day and then the next morning it doesn't work. To hack around, we changed the .jsp to use the root user login (only in our development environment to find the error) and it worked, only to have it broken again the next morning! The only thing that runs overnight is a mysqldump script, which calls this command: mysqldump -u$USERNAME -p$PASSWORD --all-databases It seems like the privileges get messed up by mysqldump? We've also been doing a flush privileges after any change to the grant tables (db, user, host). to isolate the problem, we've removed all related d_user entries. The way it looks now is that the db table is empty, the host table has an entry so that box1 has access to the databases on box2, and user has an entry for root coming from localhost, box1, box2, and to be safe, '%'. does mysql get confused when there's an '%', and then also other entries in the host column of the user table for the same user? Any help would be great...it's been really frustrating. thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Command Line Tool
At 10:43 -0600 4/5/02, Paul DuBois wrote: At 10:29 -0600 4/5/02, Lenny Sorey wrote: I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt binary version to accept The Command - Line Tool to run a script to create a table. My operating system is Windows 2000 Professional. I can connect with MyODBC-3.51.02.exe without any problem and run successful queries. I am using the model example from chapter 4.8.2 The Command-line Tool. I am trying to create a table in the test database example in MySQL I am logged in correctly and using the test database that is created when MySQL is installed as best as I can tell by reviewing the command line mysql status. I am issuing the command line statement at the mysql prompt: mysql test create.sql; That's your problem. Issue that command from the DOS prompt. Having just been castigated in private mail for being snippy in my response, I'll amend that to: That's the problem. Issue that command from the DOS prompt. I get the following mysql error: ERROR 1064 You have an error in your SQL near 'mysql test create1.sql' at line 1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query's Speed
in perl: [very simple code] my $stime = time; prepare(); execute(); fetchall_array_ref(); my $etime = time; my $ftime = $etime - $stime; print Your query took $ftime seconds\n; stupid filter: sql, query, mysql, db, table, select, insert, update, delete, join, create, left join, optimize, describe, show, status, grant cheers, lms Hi there, Lets say i do the following query: mysql select something from some_table; Then i will get the results , how many rows and how much time it took to perform the query. My question is how can i get the time it took for perform the query. I want that cuz i would like to put in a web page something like Your query took 0.04 seconds. His question seemed to indicate the time was in sub seconds (as most queries are). If so then (and you are indeed using perl) then use Time::HiRes which is a higher resolution timer. -Lance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
console app
Hello- Is there a console app that exists for windows 2000 pro such that i can access mysql server(at home on windows 2000 pro machine) with it from work? Can i use the one that is ported with the server? The server is not running on port 3306. Thanks for the help. Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert ?'s
then you need to fix your filters -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:55 AM To: john Subject: Re: Insert ?'s Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID = 1; that is the command that I am attempting to issue, but states the where... is wrong. What's wrong with that? 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
MySQL Book
We are writing a book about MySQL. There will be emphasis on using MySQL with perl/php, .net java. The publisher needs lots of emphasis on SPs and nested subqueries. We need to be able to write about implementing biz rules using table constraints, which means FKs. Your site says 4.1 is to have support for nested subQs, SPs and FKs with an alpha in early 2002, which is now but 4.0 is still alpha! 1. When can we have a 4.1 supporting nested subqueries, SPs FKs? 2. What would be a good way for us to be in your devel/test loop? Peter Brawley Arthur Fuller - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Command Line Tool
No problem Paul, I understood what you meant. Lenny Sorey - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Lenny Sorey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, April 05, 2002 11:17 AM Subject: Re: Command Line Tool At 10:43 -0600 4/5/02, Paul DuBois wrote: At 10:29 -0600 4/5/02, Lenny Sorey wrote: I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt binary version to accept The Command - Line Tool to run a script to create a table. My operating system is Windows 2000 Professional. I can connect with MyODBC-3.51.02.exe without any problem and run successful queries. I am using the model example from chapter 4.8.2 The Command-line Tool. I am trying to create a table in the test database example in MySQL I am logged in correctly and using the test database that is created when MySQL is installed as best as I can tell by reviewing the command line mysql status. I am issuing the command line statement at the mysql prompt: mysql test create.sql; That's your problem. Issue that command from the DOS prompt. Having just been castigated in private mail for being snippy in my response, I'll amend that to: That's the problem. Issue that command from the DOS prompt. I get the following mysql error: ERROR 1064 You have an error in your SQL near 'mysql test create1.sql' at line 1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Attachments Variables....
5:40 a.m. MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL (is that enough, to get past the filter ?) (sent this via the website, got a reply re the filter...) Original #2 message :- 1) PROBLEM :- Ive sent this message several times, from my 'Eudora' Email programme to the group a message was received advising my message was rejected because i had an ATTACHMENT. i'm NOT using/sending any attachments... Robert Cross, on this list has been helping me off-list - advised of some filter system on this group. can someone advise the specifcs of the filter system ? as the message advises I keep sending an Attachment (im not).. I'm writing this on the web site at slingshot.co.nz (too slow for my liking.. - i like Eudora..) 2) - Copy of my original message :- - Hi.. Ive just experimented, - sometimes when using the 'echo' tag.. I see examples which you need to close off the quotes use a . (dot) then enter a varianble.. EG :- echo(pShowing all the tables within database : B.$database./B/p); However, both these commands :- show the same thing... echo(pShowing all the tables within database : B$database/B/p); echo(pShowing all the tables within database : B.$database./B/p); Are there any reasons / Rules in which you can put a variable name within the double-quotes, instead of closing the quotes putting the variable after/before a full-stop. Just curious - No worries. G. 1) PROBLEM :- Ive sent this message several times, from my 'Eudora' Email programme to the group a message was received advising my message was rejected because i had an ATTACHMENT. i'm NOT using/sending any attachments... Robert Cross, on this list has been helping me off-list - advised of some filter system on this group. can someone advise the specifcs of the filter system ? as the message advises I keep sending an Attachment (im not).. I'm writing this on the web site at slingshot.co.nz (too slow for my liking.. - i like Eudora..) 2) - Copy of my original message :- - Hi.. Ive just experimented, - sometimes when using the 'echo' tag.. I see examples which you need to close off the quotes use a . (dot) then enter a varianble.. EG :- echo(pShowing all the tables within database : B.$database./B/p); However, both these commands :- show the same thing... echo(pShowing all the tables within database : B$database/B/p); echo(pShowing all the tables within database : B.$database./B/p); Are there any reasons / Rules in which you can put a variable name within the double-quotes, instead of closing the quotes putting the variable after/before a full-stop. Just curious - No worries. G. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert ?'s
On Friday 05 April 2002 10:16 am, john wrote: Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID = 1; that is the command that I am attempting to issue, but states the where... is wrong. What's wrong with that? It isn't valid SQL. You are, I think, trying to do an update rather than an insert, though I'm not sure. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: console app
At 11:17 -0600 4/5/02, Henning, Brian wrote: Hello- Is there a console app that exists for windows 2000 pro such that i can access mysql server(at home on windows 2000 pro machine) with it from work? Can i use the one that is ported with the server? The server is not running on port 3306. Thanks for the help. Brian The mysql client supports -h hostname or --host=hostname options that let you tell it the server host to connect to. But if your server isn't listening on port 3306 (or at least on *some* port), that's not going to do you much good. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert ?'s
no, you need to follow the list rules when posting. That's why you see a lot of posts that have a line at the end that just says mysql,sql,query or something similar. And to answer your question, it appears that you are actually attempting an UPDATE, not an INSERT? i.e. UPDATE Sellers SET Logo = 'images/helilogo.jpg' WHERE seller_id = 1 -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:17 PM To: [EMAIL PROTECTED] Subject: RE: Insert ?'s then you need to fix your filters -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:55 AM To: john Subject: Re: Insert ?'s Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID = 1; that is the command that I am attempting to issue, but states the where... is wrong. What's wrong with that? 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: MySQL Book
On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote: We are writing a book about MySQL. There will be emphasis on using MySQL with perl/php, .net java. The publisher needs lots of emphasis on SPs and nested subqueries. We need to be able to write about implementing biz rules using table constraints, which means FKs. Your site says 4.1 is to have I must say, I think this is rather short-sighted of your publisher. I obviously do not speak for the MySQL folks but I don't think you should write a book on product features which do not exist yet. That said, it is often a better idea to move business logic out of the database and into another layer instead. At my previous job, we had to do this with MS SQL Server 2000 because the built-in triggers and foreign keys and the like were simply too slow so we did it programatically instead. Of course, we still used tranactions to ensure things were either all committed or all rolled back. In my opinion, this is the right approach to take with MySQL. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Insert ?'s
Then you need to fix your messages so that it will pass thru the filter. That statement is wrong because INSERT INTO statement inserts a new record to the table so you can't have a where restriction. If you wanna change the logo value where seller_ID=1 then use UPDATE TABLE syntax. See: http://www.mysql.com/doc/U/P/UPDATE.html Gurhan -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:17 PM To: [EMAIL PROTECTED] Subject: RE: Insert ?'s then you need to fix your filters -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:55 AM To: john Subject: Re: Insert ?'s Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID = 1; that is the command that I am attempting to issue, but states the where... is wrong. What's wrong with that? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Attachments Variables....
Hi, 5:40 a.m. MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL (is that enough, to get past the filter ?) (sent this via the website, got a reply re the filter...) Perhaps because it's not MySQL, but PHP related... Original #2 message :- 1) PROBLEM :- Ive sent this message several times, from my 'Eudora' Email programme to the group a message was received advising my message was rejected because i had an ATTACHMENT. i'm NOT using/sending any attachments... Perhaps you try to send the mail in HTML format instead of PLAIN TEXT ? EG :- echo(pShowing all the tables within database : B.$database./B/p); However, both these commands :- show the same thing... echo(pShowing all the tables within database : B$database/B/p); echo(pShowing all the tables within database : B.$database./B/p); Are there any reasons / Rules in which you can put a variable name within the double-quotes, instead of closing the quotes putting the variable after/before a full-stop. Just curious - No worries. G. A small example : You have a variable $database and you want to print $database followed by some letters ('forumtest' for exemple)... In this case you have to use echo blabla.$database.forumtest; Regards, Jocelyn Fournier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: console app
Do not send me any more mail , please. --- Paul DuBois [EMAIL PROTECTED] a écrit : At 11:17 -0600 4/5/02, Henning, Brian wrote: Hello- Is there a console app that exists for windows 2000 pro such that i can access mysql server(at home on windows 2000 pro machine) with it from work? Can i use the one that is ported with the server? The server is not running on port 3306. Thanks for the help. Brian The mysql client supports -h hostname or --host=hostname options that let you tell it the server host to connect to. But if your server isn't listening on port 3306 (or at least on *some* port), that's not going to do you much good. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.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: Insert ?'s
do not send me mail I am not your friend. Thank you --- Gregory Junker [EMAIL PROTECTED] a écrit : no, you need to follow the list rules when posting. That's why you see a lot of posts that have a line at the end that just says mysql,sql,query or something similar. And to answer your question, it appears that you are actually attempting an UPDATE, not an INSERT? i.e. UPDATE Sellers SET Logo = 'images/helilogo.jpg' WHERE seller_id = 1 -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:17 PM To: [EMAIL PROTECTED] Subject: RE: Insert ?'s then you need to fix your filters -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:55 AM To: john Subject: Re: Insert ?'s Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID = 1; that is the command that I am attempting to issue, but states the where... is wrong. What's wrong with that? 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 Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.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: MySQL Power ?
why do you have to pay? I was under the impression innodb was free as well... -Original Message- From: Steve Rapaport [mailto:[EMAIL PROTECTED]] Sent: 05 April 2002 08:33 To: [EMAIL PROTECTED] Subject: Re: MySQL Power ? I'm currently running MySQL for a big, fast app without problems. BUT: I'm in the middle of specifying a new application with a high load, and I'm consideing looking for alternatives to MySQL because without InnoDB, it gets really slow on tables with frequent updates and reads (no row locking). We have, for example, a session table that records all the incoming requests for holding state. Since it's constantly being updated and read, it is frequently locked, and there are often instances where 50 reads will stack up while a lock is held. This slows down the whole database. With InnoDB, I'm sure this problem goes away, but as soon as we go to InnoDB, we have to pay for backups and support, which means we start looking around at 'pay' solutions. Is there something I'm missing? Steve However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Help! Error in editing or creating columns...
I am using MySQL Manager to manage a database created with the tool a week or so ago. Worked on the database last night and all was fine. Opened up mySQL Manager today and any change to the tables (add or edit of columns) gives the error below: Error on rename of: '.\dbname\tablename.MYI' to '.\dbname\#SQL2-a60-4f.MYI'(Errcode 13) The same operation worked fine in mySQL Monitorhas anyone had experience with this error? is it caused by the GUI or is it DB based? Help! Thanks, James - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Book
I agree with Chris... Writing a book on features that do not exist yet is asking for trouble. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL Book On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote: We are writing a book about MySQL. There will be emphasis on using MySQL with perl/php, .net java. The publisher needs lots of emphasis on SPs and nested subqueries. We need to be able to write about implementing biz rules using table constraints, which means FKs. Your site says 4.1 is to have I must say, I think this is rather short-sighted of your publisher. I obviously do not speak for the MySQL folks but I don't think you should write a book on product features which do not exist yet. That said, it is often a better idea to move business logic out of the database and into another layer instead. At my previous job, we had to do this with MS SQL Server 2000 because the built-in triggers and foreign keys and the like were simply too slow so we did it programatically instead. Of course, we still used tranactions to ensure things were either all committed or all rolled back. In my opinion, this is the right approach to take with MySQL. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Updated file - Speed ?
6:35 a.m. (writing this on the web)MYSQL :-) Hi - in my first PHP file, :- - earlier this week, Ive posted a few messages about my PHP webpage which Roger Baklund was able to help me start off.. Anyway, - Ive been to some MySql Help sites found some useful commands, which ive been able to use sucessfully... Ive uploaded a text version of my latest PHP script :- http://homepages.slingshot.co.nz/~gordon52/4.txt (view source, to view the PHP code).. Basically, it finds out what databases youve got on your system, you select one of your choice. it then lists all the tables for that database. Ive now expanded it, to show you all the field names/columns included in the table view the values of each table/row/column. The code for this last bit, is near the top of the script.. $action =='tables' Question :- 1) when i go to the 'user' tabvle in the mysql database.. it says there are 4 (FOUR) rows of information. It sucessfully lists the 1st row - Names of each column.. - Then it proceeds to loop through all (4) rows of data, Listing each row.. However, This last bit (looping) is REALLY slow, compared to the first part. my screen says there are 4 rows of data, But it only displays 1 row, then stops.. Does anyone know a) Why it doesnt loop through all 4 lines of my database ? b) Why it is a LOT slower, doing the 2nd loop. (a loop within a loop) PS, I realise other people see what i'm trying to do.. have made / or aquired better scripts than this.. but ive only been dealing with PHP/Mysql for a week or so this is my 1st big script. PPS - I'm more concverned at getting it going - rather than looks.. G. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert ?'s
um, I don't know you, I have no idea why you would take such an attitude, and if you'll look closely, as a rule I send email to the list, not to individuals. If you don't want emails from me filter me out or unsubscribe from the list. -Original Message- From: de Chateau Thierry Axel [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 1:15 PM To: Gregory Junker; [EMAIL PROTECTED] Subject: RE: Insert ?'s do not send me mail I am not your friend. Thank you --- Gregory Junker [EMAIL PROTECTED] a écrit : no, you need to follow the list rules when posting. That's why you see a lot of posts that have a line at the end that just says mysql,sql,query or something similar. And to answer your question, it appears that you are actually attempting an UPDATE, not an INSERT? i.e. UPDATE Sellers SET Logo = 'images/helilogo.jpg' WHERE seller_id = 1 -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:17 PM To: [EMAIL PROTECTED] Subject: RE: Insert ?'s then you need to fix your filters -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:55 AM To: john Subject: Re: Insert ?'s Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID = 1; that is the command that I am attempting to issue, but states the where... is wrong. What's wrong with that? 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 Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Book
Hi! - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, April 05, 2002 8:51 PM Subject: MySQL Book We are writing a book about MySQL. There will be emphasis on using MySQL with perl/php, .net java. The publisher needs lots of emphasis on SPs and nested subqueries. We need to be able to write about implementing biz rules using table constraints, which means FKs. Your site says 4.1 is to have support for nested subQs, SPs and FKs with an alpha in early 2002, which is now but 4.0 is still alpha! 1. When can we have a 4.1 supporting nested subqueries, SPs FKs? InnoDB type tables support foreign keys already in MySQL-3.23. See http://www.innodb.com/ibman.html#InnoDB_foreign_keys and http://www.innodb.com/todo.html. The current source tree of 4.1 already does some SQL subqueries. An inofficial timetable for stored procedures is 1 year. 2. What would be a good way for us to be in your devel/test loop? Simply download new versions from www.mysql.com, and test the features mentioned in the changelog in the manuals at http://www.mysql.com/doc/N/e/News-4.0.x.html and http://www.innodb.com/ibman.html#InnoDB_history. Peter Brawley Arthur Fuller Best regards, Heikki Tuuri Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Power ?
Steve, With InnoDB, I'm sure this problem goes away, but as soon as we go to InnoDB, we have to pay for backups and support, which means we start looking around at 'pay' solutions. I must correct that MySQL technical support is not free, whether you use InnoDB or not. Note also that mysqldump and other GPL tools work also with InnoDB tables. Is there something I'm missing? Steve Regards, Heikki Tuuri Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB
Hi! - Original Message - From: Rodrigo Gonzalez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, April 05, 2002 8:59 PM Subject: InnoDB First of all excuse my english...I hope someone can understand me I am thinking in converting from MyIsam to InnoDb tables. I have this table: du -sm table* 323 table.MYD 276 table.MYI 0 table.frm How much tablespace I need to convert it to InnoDb, I found that I need a lot more space for this table type, but I could not find how to calculate this space... The auto-extending data file of InnoDB-3.23.50 will solve your problem. No need to preallocate tablespace any more. I think the following formula usually gives a rough estimate of the needed size: 1.5 x size of the .MYD file + 5 x size of .MYI file. Regards, Rodrigo Gonzalez. sql,query Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB
How can I download this version? Regards - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 05, 2002 4:07 PM Subject: Re: InnoDB Hi! - Original Message - From: Rodrigo Gonzalez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, April 05, 2002 8:59 PM Subject: InnoDB First of all excuse my english...I hope someone can understand me I am thinking in converting from MyIsam to InnoDb tables. I have this table: du -sm table* 323 table.MYD 276 table.MYI 0 table.frm How much tablespace I need to convert it to InnoDb, I found that I need a lot more space for this table type, but I could not find how to calculate this space... The auto-extending data file of InnoDB-3.23.50 will solve your problem. No need to preallocate tablespace any more. I think the following formula usually gives a rough estimate of the needed size: 1.5 x size of the .MYD file + 5 x size of .MYI file. Regards, Rodrigo Gonzalez. sql,query Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Cross-database joins
Can you please tell me, is it possible to do queries that join MySql tables that are in different databases? I have a couple of Delphi database programs that use Paradox tables. I'd like to move them over to something else that is faster. These programs are set up so that they have a shared database on our server, and then a local database on each machine. I have queries that have to be able to join tables in the local and the server db's. I tried this with Interbase, and it doesn't support cross-database joins. I'm wondering if MySql can do this? If so, how would you modify the below query to show the different databases? Specifically, how would you specify the database that the table is in? SELECT D.BkID, D.Chap, D.Vrs, D.RTypID FROM :OntData:ScrpUF.DB D INNER JOIN :OntLclData:LclSrchBkParam.DB d1 ON (d1.BkID = D.BkID) WHERE D.ScrpUF LIKE %search text% *** If this is not possible, can this be accomplished with a UNION by selecting all the records in the local table, and joining the result set with the shared table? If so, how? Any help will be *greatly, greatly* appreciated. In Christ, Peter, hierodeacon Dormition Skete A Monastery of the Russian Orthodox Autonomous Church http://www.BuenaVistaCO.com/GOC http://www.RussianOrthodoxAutonomousChurchInAmerica.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
InnoDB is better than MyISAM ?
I have seen many people saying that InnoDB is a great deal, that InnoDB rocks, etc. and I am concerced about how much better InnoDB is compared to MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB have foreign keys support, but I deal very well without then since now. My interests are justified becaus eI got out of a very old struct ( DBM + Text Files ) and jumped head first into MySQL - MyISAM tables, but my site has a good deal of visitors ( about 30.000 unique visitors by day ) and speed and reliability are my primary concerns. I plan to use replication in MySQL, and I would like to know if InnoDB is better than MyISAM for this. Best regards, -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard [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: - Error 127
Hi, actually I know about current problem in 3.23.49a on linux at least - there's something weird with the cache I think. I've posted some reports with my ideas to the bugs list already. For you: I can get rid of such problems whenever they appear by doing : mysqladmin flush-tables They disappear after some time period possibly because the contents of the cache were flushed as the cache got full or whatever force pushed the data out from cache or whatever condition forced mysqld to reread status of teh table from disk again. Maybe this problem also shows only if the database on which you operate is accessible via some softlink from your datadir - i.e. if you can access your problematic table under two different databasenames. I might not be right, but this is our case at least. Further, when this error show up, do in this order: cd /usr/local/mysql/var/$dbname ls -la $table.* myisamchk -f -d -v $table.MYI mysqladmin flush-tables ls -la $table.* myisamchk -f -d -v $table.MYI mysql $dbname -e 'select count(*) from $table;' mysql $dbname -e 'check table $table;' mysql $dbname -e 'check table $table;' mysql $dbname -e 'check table $table;' I think the SELECT will already work. Compare if the output if both myisamchk commands were same. I guess if you omit the `mysqladmin flush-tables` command, the SELECT or maybe even first CHECK TABLE will fail, but then the next commands wil work fine. This is still not confirmed by the developers, but I know they have now quite a hard time to get through my mails. ;) Hope this helps Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Group commit in innodb?
Hi, Does InnoDB use some form of group commit like BerkeleyDB and Postgresql? In Postgresql you can specify a COMMIT_DELAY to force a wait before the commit returns. Disk IO to the log files can be reduced quite alot if you tweak this setting, and it can be very useful when tuning batch-like systems where the clients that issues the commits can wait for a period of time. -- Magnus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Tricky Query...
here's the scoop: Basically I'm listing pieces of information from a two-key table and I am not getting the information I want. BACKGROUND Consider this sample table (which although goofy, does illustrate what I'm attempting to do) SELECT clientid, revision, name, address FROM clients; +--+--++---+ | clientid | revision | name | address | +--+--++---+ |1 |0 | Fred Flintstone| 55 Bedrock Way| - Fred |2 |0 | Barney Rubble | 57 Bedrock Way| - Barney |3 |0 | Pebbles Flintstone | 55 Bedrock Way| - Pebbles lives with Fred |4 |0 | Bam Bam Rubble | 57 Bedrock Way| - Bam Bam lives with Barney |1 |1 | Fred Flintstone| 145 Stonewall Terrace | - Fred Moves |3 |1 | Pebbles Flintstone | 145 Stonewall Terrace | - Pebbles Moves with him |4 |1 | Bam Bam Rubble | 25 Mammoth Road | - Bam-Bam Moves out |3 |2 | Pebbles Rubble | 25 Mammoth Road | - Pebbles changes name; moves in with BamBam +--+--++---+ By using the clientid and revision keys, you can create a 'snapshot' of client data. For example, if you made an invoice out to Fred, when his address was 55 Bedrock Way, the invoices table, would record clientid and revision id. That invoice record will always pull up the contact information Fred had at the time the invoice was printed. PROBLEM I want to construct a single query that will list the latest record for each unique person. In the above query, we are listing all of the clientids, and all of the revisions. If we group by client, we get: +--+--+++ | clientid | revision | name | address| +--+--+++ |1 |0 | Fred Flintstone| 55 Bedrock Way | |2 |0 | Barney Rubble | 57 Bedrock Way | |3 |0 | Pebbles Flintstone | 55 Bedrock Way | |4 |0 | Bam Bam Rubble | 57 Bedrock Way | +--+--+++ This provides me with one piece of information I require, which is the unique number of clients, but the revision listed is the lowest, and I want the highest. SELECT clientid, max(revision), name, address FROM clients GROUP BY clientid; +--+---+++ | clientid | max(revision) | name | address| +--+---+++ |1 | 1 | Fred Flintstone| 55 Bedrock Way | |2 | 0 | Barney Rubble | 57 Bedrock Way | |3 | 2 | Pebbles Flintstone | 55 Bedrock Way | |4 | 1 | Bam Bam Rubble | 57 Bedrock Way | +--+---+++ This gives me the highest revision number as well, but the name and address do not correspond to the clientid and revision listed. Here is a FABRICATED table I have TYPED OUT to demonstrate the information that I'm looking for. I'm looking for a single query that can produce: +--+--++---+ | clientid | revision | name | address | +--+--++---+ |1 |1 | Fred Flintstone| 145 Stonewall Terrace | |2 |0 | Barney Rubble | 57 Bedrock Way| |3 |2 | Pebbles Flintstone | 25 Mammoth Road | |4 |1 | Bam Bam Rubble | 25 Mammoth Road | +--+--++---+ if it were legal and it worked, I could do a SELECT clientid, revision, name, address FROM foobar WHERE revision = max(revision) GROUP BY clientid; I dunno - I'm thinking I have to do something with the indexes that I'm missing. Any help would be appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Use JDBC on Redhat, localhost.localdomain?
Hi, all: I am trying to use JDBC to connect MySQL, and use JDBC to config the MySQL. As default root@default has the privilege to do everything. So I use JDBC to connect with root. I got error. [EMAIL PROTECTED] failed. I read a note said that this only happen to Redhat. Any suggestion how to do this? I am try to not use any thing with COMMAND LINE if possible. Thanks! Zengfa __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.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: Tricky Query...
[EMAIL PROTECTED] wrote: Here is a FABRICATED table I have TYPED OUT to demonstrate the information that I'm looking for. I'm looking for a single query that can produce: +--+--++---+ | clientid | revision | name | address | +--+--++---+ |1 |1 | Fred Flintstone| 145 Stonewall Terrace | |2 |0 | Barney Rubble | 57 Bedrock Way| |3 |2 | Pebbles Flintstone | 25 Mammoth Road | |4 |1 | Bam Bam Rubble | 25 Mammoth Road | +--+--++---+ if it were legal and it worked, I could do a SELECT clientid, revision, name, address FROM foobar WHERE revision = max(revision) GROUP BY clientid; I dunno - I'm thinking I have to do something with the indexes that I'm missing. Any help would be appreciated. Just thinking through this... One possibility would be to run multiple selects. You could do the SELECT max(revision), clientid FROM foobar GROUP BY clientid first, then programmatically either cycle through all of them doing mini-selects or glop together a giant or statement (probably that will fail when you have large numbers of clients). You could create a temporary table, use an INSERT ... SELECT statement to populate it with the above data, then join that table with your original table. You could programmatically maintain a 'most recent' flag which would be update whenever a new record was inserted. I'm going to set up a fake DB like yours and experiment with it. ... ... Here we go, this seems to work: SELECT t1.clientid, max(t1.revision) as maxrev, t2.revision, t2.name, t2.address FROM foobar t1, foobar t2 WHERE t1.clientid=t2.clientid GROUP BY clientid, revision HAVING maxrev=revision; See if that helps any. -- John Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School | Nihil Interit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table crash!
The table has mysql select count(*) from repository; +--+ | count(*) | +--+ | 5673838 | +--+ records inside. 1. I get table a table crashed whenever I try to fix it or check it with MYISAMCHK using -r, -o or -f parameters. And the table is then no longer usable. Don't do this when the table is in the cache! The correct way (open two xterms and do commands in this order): mysql flush tables; mysql lock table repository write; $ myisamchk -f -d -v repository.MYI # this will tell you the status of the table based on the index file If the output says the table is broken, then myisamchk -r $table myisamchk -f -d -v $table mysql unlock tables; mysql flush tables; mysql check table $table; If it it looks fine (see the line Status), then mysql unlock tables; mysql flush tables; mysql check table $table; if the check table complains about bad number of rows present versus expect, like below: ++---+--+---+ + | Table | Op| Msg_type | Msg_text | ++---+--+---+ + | $db.$table | check | warning | Size of datafile is: 679740 Should be: 0| | $db.$table | check | error| Record-count is not ok; is 501 Should be: 0 | | $db.$table | check | warning | Found 501 partsShould be: 0 parts | | $db.$table | check | error| Corrupt | ++---+--+---+ + then do mysql flush tables; mysql lock table $table write; $ myisamchk -rq $table.MYI # fix the index while NOT modifying the .MYD file with data $ myisamchk -f -d -v $table # check the result mysql unlock tables; mysql flush tables; mysql check table $table; In any case, you should have working table. I believe this is your current problem. But you should upgrade to 3.23.49a at least as there're some bugfixes in previous versions. There're probably still some (I've reported some ;) ), so you should look for 3.23.51 to get more fixes. I've learned a lot from this thread: http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:msn:11533:nkocbgofapjhfkjheipi To quote the summarized secret from that thread: - You must do FLUSH TABLES before you manipulate the .MYI or .MYD files outside of mysqld. - You can't just replace a .MYD file with another; You have to always use the .MYD and .MYI files together. (Actually, if you want to save backup space, you can go away from this restrictions by just copying the first 8K from the .MYI file; This should contain all the meta-information that myisamchk / REPAIR TABLE needs to reconstruct the rest of this file. Regards, Monty The only way to fix this is to generate a new empty .MYI file with the correct header information (Just run 'truncate table ..' on it) and then copy the old .MYD file over the empty one. Is this nice explanation of truncate table mentioned somewhere in the myisamchk section in manual? I was missing this very serious information - that I cannot re-create .MYI via myisamchk but have to use some `truncate table`, which really doesn't sound to be the command I need when repairing table. ;) [...] If you delete the .MYI table you have to generate it from the .frm file with 'truncate table'. Perfect explanation what to do in such case. I just missed this idea from you example -- me You can't just replace a compressed .MYD file with a not compressed. The .MYI and .MYD files must always be kept together. This is because all meta information (like the record type) is stored in the .MYI file. mmokrejs OK, I thought the index can be re-created safely from .MYD and .frm. mmokrejs With your explanation somewhere below that .MYI I can recreate with mmokrejs `truncate table` explains it well. And them myisamchk can fix the .MYI mmokrejs according the current status of .MYD. I thought that `truncate table` mmokrejs truncates the .MYD file, and this I didn't want to happen intentionally in mmokrejs these experiments. Yes. TRUNCATE TABLE does truncate the .MYD file. If you want to use this to generate an index the way I used it, you must first do a backup of the .MYD file and then copy it back after TRUNCATE TABLE. The only way to fix this is to generate a new empty .MYI file with the correct header information (Just run 'truncate table ..' on it)
Re: Error in accept: Invalid argument and Duplicate entry '0' forkey
Hi, Victoria Reznichenko wrote: VR Martin, VR Wednesday, April 03, 2002, 5:45:00 PM, you wrote: VR VR MM would anyone please explain me what are these error messages? VR VR MM 020327 12:29:26 mysqld started VR MM 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98 VR MM /usr/local/mysql/bin/mysqld: ready for connections VR MM /usr/local/mysql/bin/mysqld: ready for connections VR MM 020327 12:29:26 Error in accept: Invalid argument VR MM 020327 12:29:26 Error in accept: Invalid argument VR MM [There're plenty of those Error in accept messages.] VR VR # perror 98 VR Error code 98: Address already in use VR Is your mysql server box behind a firewall? Perhaps firewall to keep VR out MySQL server. No firewall between those machines. I was told later by people the machine had load 20 so probably safe_mysqld restarted mysqld and it retried to start mysqld twice at the same time. I don't know why that happened so quickly, all within one second. VR VR [...] VR VR MM Actually there's a hit in old docs in Solaris section(maybe I missed that VR MM in current docs?): VR MM http://www.google.de/search?q=cache:XowJDknOOI4C:theoryx5.uwinnipeg.ca/mysql/manual_4.html+mysql+Error+in+accept:+Invalid+argumenthl=de VR MM If too many processes try to connect very rapidly to mysqld, you will see this VR error in the MySQL log: VR MM Error in accept: Protocol error VR MM You might try starting the server with the --set-variable back_log=50 option VR as a workaround for this. VR VR How does 'Error in accept: Protocol error' belong to error that you VR received? Probably no relation, that was just the only Google hit I had. Maybe few words in the offcial documentation about this kind of errors? Possible causes, solutions? VR MM ERROR 1036 at line 46: Table 'intergenome' is read only VR MM Failed to dump Synechocystis_PCC6803.intergenome VR MM ERROR 1062 at line 46: Duplicate entry '0' for key 1 VR MM Failed to dump Tmaritima.intergenome VR VR Looks like you have corrupted indexes. And speaking about 'table is VR read-only' it means that you have no permissions to write ih those VR files, but it can make problems in dump ... Unfortunately none of them are true, but Michael is looking into this already. Thanks. -- Martin Mokrejs [EMAIL PROTECTED] PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax:+49-89-3187 3585 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 monitoring
Is there any sort of mysql load monitoring tools out there? If not how can I get how many query's per/sec, users, etc, which I can log to a flat file or db, and I could run rrdtool against it to get graphs? -Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert ?'s
(and I say again...) -Original Message- From: de Chateau Thierry Axel [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 1:15 PM To: Gregory Junker; [EMAIL PROTECTED] Subject: RE: Insert ?'s do not send me mail I am not your friend. Thank you --- Gregory Junker [EMAIL PROTECTED] a écrit : no, you need to follow the list rules when posting. That's why you see a lot of posts that have a line at the end that just says mysql,sql,query or something similar. And to answer your question, it appears that you are actually attempting an UPDATE, not an INSERT? i.e. UPDATE Sellers SET Logo = 'images/helilogo.jpg' WHERE seller_id = 1 -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:17 PM To: [EMAIL PROTECTED] Subject: RE: Insert ?'s then you need to fix your filters -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:55 AM To: john Subject: Re: Insert ?'s Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID = 1; that is the command that I am attempting to issue, but states the where... is wrong. What's wrong with that? 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 Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.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
printing the database
Hi, Is it possible to print a table from the database in the same format as you can see it. I tried to export a table to an outfile, but i dont get the column names. I am using Linux so i don't have a print screen option, I think you can do using a software package called EMS MySQL Manager, but this isn't free. Is it possible? Thanks in advance, Colin __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.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: InnoDB is better than MyISAM ?
At 01:54 PM 4/5/2002, you wrote: I have seen many people saying that InnoDB is a great deal, that InnoDB rocks, etc. and I am concerced about how much better InnoDB is compared to MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB have foreign keys support, but I deal very well without then since now. My interests are justified becaus eI got out of a very old struct ( DBM + Text Files ) and jumped head first into MySQL - MyISAM tables, but my site has a good deal of visitors ( about 30.000 unique visitors by day ) and speed and reliability are my primary concerns. I plan to use replication in MySQL, and I would like to know if InnoDB is better than MyISAM for this. Have you ever heard the old saying, If it ain't broke, don't fix it?.bg If your website is mainly for read access to your database then you're not going to need InnoDb. InnoDb is great for multi-user updates because of its row locking. If you have more than say 30-50 users at a time updating records in the *same* table, then yes row locking will help. You will need to analyze the log file to determine how many processes are waiting for table locks on your MyISAM tables to determine if the switch to InnoDb is warranted. InnoDb inserts (for a single user) are much slower (for me it is around 10x slower) than MyISAM because InnoDb does a lot more work. This may dismay a few users initially, but then they realize InnoDb will maintain its speed much better than MySQL when there are a lot of heavy updates. So if your database is mostly readonly, then stick to MyISAM tables. I don't know if InnoDb supports replication or not. You'll have to check with Heikki. Brent _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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: MySQL Power ?
At 10:16 AM 4/5/2002, you wrote: Actually, according to the objective eWeek test results at the link provided in another reply, the gap between Oracle 9i and MySQL 4.x is rather slim... Gregory, A point that was sadly missing from that article was what was the cost to create the Oracle webserver? How much did it cost to purchase the Oracle software and how much were the license fees to support that many concurrent users. How much was the administration software for the Oracle database? What was the yearly support for tech support? What did it cost for tech support (in hours) to fine tune the database? Then compare those figures to MySQL and you'll start to see the real advantage of MySQL. If anyone has these costs worked out for the Oracle vs MySQL webserver benchmark that appeared in e-Week and PC Mag, I think a lot of people would be interested in seeing it. I know I would. Brent I will look forward to hearing the response of the well-informed to this. However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). (Or have I just fallen for Oracle propaganda?) Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Yahoo!? Get your free @yahoo.com address at http://mail.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: Command Line Tool
Lenny, You might find it easier to use a GUI like MySQL Front from http://www.anse.de/mysqlfront/. It will save you a great deal of time. Just enter (or copy and paste) the SQL into their query window and press a button. Editing your errors are also a lot easier. It is free or you can make a $15 donation to the author if you like it. Brent _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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: Very large BLOBS in MySQL 4.0.1
Adriano Manocchia wrote: Well, first off, I can't seem to get max_allowed_packet higher than 64 MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are reflected in the system settings, but only up to 64 MB, then regardless of what I put in there, it stays at 64 MB. But like I said, the file is only 34 MB, so theoretically it shouldn't be a problem. As for the client, I'm trying to insert the record with the Perl DBI, which, according the documentation, uses the server's max_allowed_packet value. There's no way to set it on the client side that I'm aware of. Hi, you might look for 4.0.2 (or 3.23.50) which contains some extra fix to take into account the size of the packet header when counting size of the whole packet. This affects you only if you cannot reimport mysqldump back into mysql, I used to get on 3.23.49a: $ mysqldump -O net_buffer_length=16M --extended-insert --add-drop-table Sulfolobus_solfataricus_P2 known3d | mysql -O net_buffer_length=16M mmo mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'known3d' at row: 106977 $ mysqldump -O net_buffer_length=16M --extended-insert --add-drop-table Sulfolobus_solfataricus_P2 known3d | mysql mmo mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'known3d' at row: 107088 $ mysqldump --extended-insert --add-drop-table Sulfolobus_solfataricus_P2 known3d | mysql mmo $ Look for subject Re: --extended-insert breaks import of some tables through pipe on similar thread in the bugs list. Note the last one succeeeds - this is a current workaround for me. Martin MOKREJS wrote: On Fri, 15 Mar 2002, Michael Widenius wrote: Martin And if user sets net_buffer_length=80M, then happens what? Is it set just Martin to 16M or is it ignored? This is what's not clear from docs. You can test this with: mysql -O net_buffer_length=80M --help In 4.0 it's set to about 80M, in 3.23 to 24 M (which was wrong, it should be 16M) Yes, then please update the docs to say clearly that the value for net_buffer_length CAN be larger then 16M, although automatically it will grow only up to the value of max_allowed_packet. And mention the `mysql -O net_buffer_length=80M --help' example, that's nice. Hope this helps Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB and replication
Hello there, anybody here has some background using InnoDB and MySQL replication feature ? If so, would you mind sharing those information with me ? -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 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: printing the database
Hi, Try to use tee command to log all the output into a file. It will have the column names and everything you see in the screen. See: http://www.mysql.com/doc/m/y/mysql.html Gurhan -Original Message- From: colin o [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 4:14 PM To: mysql Subject: printing the database Hi, Is it possible to print a table from the database in the same format as you can see it. I tried to export a table to an outfile, but i dont get the column names. I am using Linux so i don't have a print screen option, I think you can do using a software package called EMS MySQL Manager, but this isn't free. Is it possible? Thanks in advance, Colin __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Power ?
At 10:16 AM 4/5/2002, you wrote: Actually, according to the objective eWeek test results at the link provided in another reply, the gap between Oracle 9i and MySQL 4.x is rather slim... Gregory, A point that was sadly missing from that article was what was the cost to create the Oracle webserver? How much did it cost to purchase the Oracle software and how much were the license fees to support that many concurrent users. How much was the administration software for the Oracle database? What was the yearly support for tech support? What did it cost for tech support (in hours) to fine tune the database? Then compare those figures to MySQL and you'll start to see the real advantage of MySQL. If anyone has these costs worked out for the Oracle vs MySQL webserver benchmark that appeared in e-Week and PC Mag, I think a lot of people would be interested in seeing it. I know I would. Brent Agreed, but the article was solely about the technical merits of the various solutions. FYI (general consumption), both Sybase and MySQL sent people to the test floor, IBM provided email support, Oracle and Microsoft declined to be involved. I would say that the lower TCO of MySQL compared to Oracle would be a deciding factor in many cases (given a relatively equivalent feature set). Don't get me wrong; I'm certainly not an Oracle schill. I harbor a deep and ancestral hatred for Oracle's database server software, especially from an admin standpoint. I was simply highlighting the fact that in plain technical terms, MySQL was right there with Oracle, and far and above the other offerings. Anything on top of that (the TCO issues you raise, for example) are above and beyond that. I have to admit that I have not yet tried the .NET/OLEDB interfaces to MySQL, and honestly, am not willing to until the SP support in MySQL is fully functional. I will say that all of the VS/ADO/.NET development I am doing for IIS/MSSQL is being done with an emphasis on easily migrating to MySQL in the future (for example, making sure that I don't use any Microsoft-specific constructs on the database side). Why am I still working with MS technologies? Because they work together well (as the article also stated), and at this time I am more interested in shorter development time (which VS.NET provides in spades) than in purity of ideology. VS.NET/IIS/.NET Framework/MSQQL 2K works fine for me for now, but as soon as I can plug in MySQL on the back end without missing a beat I'm there. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginners Question
Thanks Todd and Tyler for the encouragement, When I searched on Mysql column types, I did not find any obviously suitable for images. I do not suppose I can use VARCHAR, can I? Also, I need to have very good performance on data retrieval and transport, which means I also need to have maximum retrieval speed and minimun memory size of my images. My images are just plain graphics, no rich colors. How can I realize the above purposes? Thanks for any help. -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 7:41 PM To: 'Zhao, Charles'; [EMAIL PROTECTED] Subject: RE: Beginners Question Yes, mySQL is up to the task. Just make sure you design the DB with fast retrivals in mind -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:53 PM To: '[EMAIL PROTECTED]' Subject: Beginners Question Hello there, I am trying to find which database to use. I will have text and image data. Lots of image data. Most of the time I am doing data retrieving, but when updating, it will be text almost always. No enterprise use, but very busy database hits. Could any one please educate me if mysql is a good database for this purpose? Or anything else? Many thanks. -- charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MYSQL maximum query size?
-Original Message- From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 4:02 PM To: [EMAIL PROTECTED] Subject: [PHP] MYSQL maximum query size? Is there a maximum number of characters you can use in a query? I have a giant query using the UPDATE command (updating about 120 different columns). I run this query of mine and nothing happens. No errors. No updates either. Thanks!! Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginners Question
On Friday 05 April 2002 2:54 pm, Zhao, Charles wrote: Thanks Todd and Tyler for the encouragement, When I searched on Mysql column types, I did not find any obviously suitable for images. I do not suppose I can use VARCHAR, can I? Use one of the BLOB types. Note that if you are running a web server, you might be better off just storing a path and filename in the database and have apache serve the image itself. Also, I need to have very good performance on data retrieval and transport, which means I also need to have maximum retrieval speed and minimun memory size of my images. My images are just plain graphics, no rich colors. How can I realize the above purposes? Photographic images should normally be stored as jpegs, line-art drawings as png. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
create tmp table of column list of a table for future use
mysql create table column_list (desc MYTABLE_NAME); ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)' at line 1 Anyone know how to make something like 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
Re: create tmp table of column list of a table for future use
I believe it has to be like this: create table column_list (MYTABLE_NAME DESC); Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: hong chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 05, 2002 4:13 PM Subject: create tmp table of column list of a table for future use mysql create table column_list (desc MYTABLE_NAME); ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)' at line 1 Anyone know how to make something like 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: create tmp table of column list of a table for future use
-Original Message- From: hong chen Sent: Friday, April 05, 2002 5:32 PM To: 'Alex Behrens' Subject: RE: create tmp table of column list of a table for future use No luck. Oracle and Sql Server have system tables to check. mysql desc ATTRIBUTES; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | NAME | varchar(255) | YES | | NULL| | | VALUE | varchar(255) | YES | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.02 sec) mysql create table column_list ( ATTRIBUTES desc); ERROR 1064: You have an error in your SQL syntax near 'desc)' at line 1 mysql create table column_list (desc ATTRIBUTES); ERROR 1064: You have an error in your SQL syntax near 'desc ATTRIBUTES)' at line 1 mysql select Field from (desc ATTRIBUTES); ERROR 1064: You have an error in your SQL syntax near 'desc ATTRIBUTES)' at line 1 mysql -Original Message- From: Alex Behrens [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 5:24 PM To: hong chen; [EMAIL PROTECTED] Subject: Re: create tmp table of column list of a table for future use I believe it has to be like this: create table column_list (MYTABLE_NAME DESC); Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - To: [EMAIL PROTECTED] Sent: Friday, April 05, 2002 4:13 PM Subject: create tmp table of column list of a table for future use mysql create table column_list (desc MYTABLE_NAME); ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)' at line 1 Anyone know how to make something like 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: create tmp table of column list of a table for future use
Are you trying to create a new table with an existing table's structure only ? or with the structure and data? If you just wanna duplicate a table with the data inside it you can use CREATE TABLE .. SELECT ... syntax. More info is at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html IF you just wanna copy the structure, do a SHOW CREATE TABLE on the existing table and copy and paste its CREATE TABLE syntax to create the new one with a different name. See more info at: http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Gurhan -Original Message- From: hong chen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 5:13 PM To: [EMAIL PROTECTED] Subject: create tmp table of column list of a table for future use mysql create table column_list (desc MYTABLE_NAME); ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)' at line 1 Anyone know how to make something like 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: create tmp table of column list of a table for future use
-Original Message- From: hong chen Sent: Friday, April 05, 2002 5:50 PM To: 'Gurhan Ozen' Subject: RE: create tmp table of column list of a table for future use I am trying to check if a certain column exists before I try to select it from the table. in Oracle or Sql Server I would: select count(*) from user_tab_columns (or sys_columns) where name='C_NAME'; mysql desc ATTRIBUTES; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | NAME | varchar(255) | YES | | NULL| | | VALUE | varchar(255) | YES | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.02 sec) mysql select count(*) from (desc ATTRIBUTES) where Field ='ID'; ERROR 1064: You have an error in your SQL syntax near 'desc ATTRIBUTES)' at line 1 thanx. -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 5:44 PM To: hong chen; [EMAIL PROTECTED] Subject: RE: create tmp table of column list of a table for future use Are you trying to create a new table with an existing table's structure only ? or with the structure and data? If you just wanna duplicate a table with the data inside it you can use CREATE TABLE .. SELECT ... syntax. More info is at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html IF you just wanna copy the structure, do a SHOW CREATE TABLE on the existing table and copy and paste its CREATE TABLE syntax to create the new one with a different name. See more info at: http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Gurhan -Original Message- Sent: Friday, April 05, 2002 5:13 PM To: [EMAIL PROTECTED] Subject: create tmp table of column list of a table for future use mysql create table column_list (desc MYTABLE_NAME); ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)' at line 1 Anyone know how to make something like 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
Difference between Unique Index and Primary Key?
Here are a few easy philosophical questions for a change: 1) For performance or storage benefits, is there a difference between a Unique Index and Primary Key? 2) Is there a reason why I should use Primary Key instead of a Unique Index? 3) Why isn't there a syntax for create primary index index_name on table_name (fieldlist) ? I know a primary key can be added with Alter table, but if I'm defining indexes for a table, it would look a lot better in the script if I was using the same syntax. TIA Brent sql, query _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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: create tmp table of column list of a table for future use
Problem is I'm accessing mysql through scripting against a table that may or may not have ID field, select count(*) from (desc ATTRIBUTES) where Field ='ID'; if count(*) 0 then select ID from ATTRIBUTES; else do something else; end if; -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 5:57 PM To: hong chen Subject: RE: create tmp table of column list of a table for future use SHOW CREATE TABLE ... syntax will show you whether or not the field name is there.. Gurhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB is better than MyISAM ?
On Fri, 5 Apr 2002, BD wrote: At 01:54 PM 4/5/2002, you wrote: I have seen many people saying that InnoDB is a great deal, that InnoDB rocks, etc. and I am concerced about how much better InnoDB is compared to MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB have foreign keys support, but I deal very well without then since now. My interests are justified becaus eI got out of a very old struct ( DBM + Text Files ) and jumped head first into MySQL - MyISAM tables, but my site has a good deal of visitors ( about 30.000 unique visitors by day ) and speed and reliability are my primary concerns. I plan to use replication in MySQL, and I would like to know if InnoDB is better than MyISAM for this. One note here is that transactions aren't preserved for replication with InnoDB, so you loose part of one of the major advantages of InnoDB. Rollbacks are O.K., since I don't think that goes out to the slaves until the commit, but if the master or slave goes down after part of a transaction is sent to the slave, you get a partially committed transaction on the slave. How critical this is depends on the application, and still is no worse than MyISAM which has no transactions to begin with. I think Heikki Tuuri has mentioned plans to get this fixed, though I think I remember that he said that the problem was in MySQL, not in the actual InnoDB code, which makes sense. Have you ever heard the old saying, If it ain't broke, don't fix it?.bg If your website is mainly for read access to your database then you're not going to need InnoDb. Agreed 100%, but it doesn't hurt too much (except for index sizes) on readonly databases, so on our production system, we standardized on InnoDB for all tables for consistency, though we will allow for exceptions for tables that need features that aren't in InnoDB yet, such as full text searching. InnoDb inserts (for a single user) are much slower (for me it is around 10x slower) than MyISAM because InnoDb does a lot more work. This was not my experience. Without batching the commits, InnoDB lost out to MyISAM on our initial testing by about 1.5x rather than 10x. However, when I committed every 100 or so inserts, InnoDB beat out MyISAM by a small (25%) margin. This was with a single user hitting the database, a perl program that read in a text file, split it into fields, and stuffed it into the database one record at a time (identical programs except for handling the commits()). Now, this wasn't normal database activity, pure inserts into a freshly created table, but the results were still quite impressive. Also, I'm dealing with single-user activity, so there may have been some differences there as well. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Difference between Unique Index and Primary Key?
Here are a few easy philosophical questions for a change: 1) For performance or storage benefits, is there a difference between a Unique Index and Primary Key? There can be only one primary key. There can be multiple unique indexes. Primary keys cannot contain NULL values. Unique indexes can allow NULL values (and in fact, NULL is the one value that can occur multiple times in a unique index). 2) Is there a reason why I should use Primary Key instead of a Unique Index? 3) Why isn't there a syntax for create primary index index_name on table_name (fieldlist) ? I know a primary key can be added with Alter table, but if I'm defining indexes for a table, it would look a lot better in the script if I was using the same syntax. TIA Brent sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Abandoned Cart Query
I'm trying to write a query that will tell me how many abandoned carts there are in a cart table I have. each item in a cart is a record, so simply querying on records won't work. What I need to count is how many distinct customerId's there are. a sample from the table looks like: cartItemId customerId productId 1944244 2139 1945244 2234 1946244 8291 1947198 4435 1948198 3342 1949221 3324 1950221 4432 so in this example, the number of abandoned carts would be 3, because there are only three unique customerId's. Any help on what that query would look like is appreciated! Thanks, Rory P.S. This list is awesome! you guys have helped me immensely. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with UPDATE in v3.23.49 (is this a bug)
It's not illogical at all. You often want (sometimes need) that field to make sure a record has not changed when you go back to update the row. MS Access (and others) uses this so as not to overwrite changes made since the record was retrieved. You can't always rely on the client to set field=NOW(), and it makes for that much less coding. mysql, query j- k- On Friday 05 April 2002 07:53, Hihn Jason wrote: Yes I did, but it is very long, and it was very long ago. Could someone please explain to me why this was done? It seems more confusing to do this than to not do this. Why when you can just say SET field=NOW() in the update statement would anyone build this auto update of timestamps in? (the kicker is you HAVE to do it for all timestamps in a schema past the first) Additionally, what if I wanted the time stamp format (without formatting (spaces, colons, and dashes)) (which I do) A very illogical feature I must say... Anyone agree with me? (Forgive me Rick, I didn't hit reply to all) -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Abandoned Cart Query
rory oconnor [EMAIL PROTECTED] writes: [...] each item in a cart is a record, so simply querying on records won't work. What I need to count is how many distinct customerId's there are. a sample from the table looks like: cartItemIdcustomerId productId 1944 244 2139 1945 244 2234 1946 244 8291 1947 198 4435 1948 198 3342 1949 221 3324 1950 221 4432 so in this example, the number of abandoned carts would be 3, because there are only three unique customerId's. Any help on what that query would look like is appreciated! Something like SELECT DISTINCT(customerID) FROM cart should give you want you want. See the mysql documentation for SELECT and DISTINCT for more details on exactly how these work. -ScottG. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php