Re: Server Hardware
depends on your budget :) We assembled a nice dual pIII server with 512Mb ram and 40Gb ide disk (+40 for backup) running redhat 7 for less than $3000 You can spend any amount you like, from $30 for an old P133 up to $3 for a compaq, and choose almost any platform you like. without indication on the load it's just hard to tell, but probably any new-bought PC will fullfill your needs. Maybe you want some more ram, scsi drive or backup facility, but a 1Ghz box with 256Mb is enough to run a very descent server. Take a look at IBM's website, they make nice servers for a fair price, and claim they are very reliable. gl rene On Mon, 7 May 2001 18:46:04 -0400 Dan Mouw [EMAIL PROTECTED] wrote: We are trying to purchase a server for mysql and were wondering about what is the best hardware to go with. Any suggestions or web sites that have information would be appreciated. Thank you, Dan Mouw - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Regarding SQL query with Unique
We want to get the Unique value from a table. can we use the following query: select unique(ProblemNo) from MainProblem; where MainProblem is a Table having Column ProblemNo. the contents of ProblemNo are 1 1 2 2 3 3 3 the result of the above query must be : 1 2 3 Thank You. _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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: Regarding SQL query with Unique
use distinct() instead. - Original Message - From: AVDHUT SHEDGE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 3:00 PM Subject: Regarding SQL query with Unique We want to get the Unique value from a table. can we use the following query: select unique(ProblemNo) from MainProblem; where MainProblem is a Table having Column ProblemNo. the contents of ProblemNo are 1 1 2 2 3 3 3 the result of the above query must be : 1 2 3 Thank You. _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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 Help
Salvador Casquero Algarra wrote: Hi, I am having a terrible problem with MySQL and I am desperated as nobody seems to find the source. I have a Web site ( www.genteirc.com ) whith MySQL database access. The problem is that those Mysql processes are growing continuously until they consume all of the memory ( 2 Gigas ). I include at the end of the message two files that we have captured just before the reboot of the machine. Somebody is saying that MySQL doesn´t work with Intel multiprocessors and his solutions is to remove one of the proccesors ¿¿??. Can you please help me ?. Thanks very much in advanced. Best regards, Salvador Hi, I ran into problems (index corruptions under high loads) on a bipro Intel server and the problem disappeared when I rebooted with a uniprocessor Linux kernel (hopefully, no need to physically remove a processor). I got this problems with MySQL 3.23.30. I haven't tried latest version yet. However, your problem seems totally different, my server has also 2G RAM and has never run out of memory (a little bit more than 1G is actually used) with more than 350 threads (active connections). Since you don't give much information on your server configuration and usage, it is hard to help you. What are your operating system, kernel version, MySQL version, my.cnf file ? Are you running other apps on this machine or is it dedicated to MySQL ? BTW, I have you tried to find out why your SELECT are Locked ? Regards -- Joseph Bueno NetClub/Trader.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: Regarding SQL query with Unique
AVDHUT SHEDGE wrote: We want to get the Unique value from a table. can we use the following query: select unique(ProblemNo) from MainProblem; where MainProblem is a Table having Column ProblemNo. the contents of ProblemNo are 1 1 2 2 3 3 3 the result of the above query must be : 1 2 3 Thank You. Hi, The answer is in the manual ;) http://www.mysql.com/doc/S/E/SELECT.html Regards -- Joseph Bueno NetClub/Trader.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
'invalid authorization specification' error
Hi, I am new to MySql. i have server runnng mysql-3.23.37-win under Windows NT i am using mm.mysql-2.0.4-bin JDBC driver to connect to mysql server. i am able to connect to mysql server from java program run on the same pc with host as 'localhost' or '127.0.0.1'. the ip address of the pc running mysql server is 192.168.9.50 if i use host as : 192.168.9.50 in the same java program from the same pc i get the following error: Exception in thread main java.sql.SQLException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java:167) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:199) Kindly Advice. Thanks Damnish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing data from MS SQL 7 to MySQL
Hello, I am trying to transfer my Microsoft SQL Server to a MySQL Server running under Linux. Until now I have tryied the following methods. I installed DBtools 1.0.8 in a third machine running Win98 and connected to the MySQL server (Linux). I tried to import data from the Microsoft SQL server : 1) Directly from the Microsoft SQL Server through ODBC connection 2) From an Access 2000 .mdb file where I have previously imported data from the Microsoft SQL Server However both ways don't seem to import all the tables, constrains, procedures, etc. Is there any tool I can use to migrate MS SQL with MySQL??? Thank you in advance Konstantinos Katsoridis Webmaster Net One SA [EMAIL PROTECTED] + 30 (1) 68.20.240 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MySQL with C-API
Hi, I've got a couple a questions concerning the speed of insert queries when using the C API from MySQL. I've written an application that receives data through a CORBA event channel and stores it in a MySQL database. The problem is that a lot of events are dropped. I think (I'm quite sure actually) that the MySQL database is the bottleneck because it's a slow consumer. Now if I use a benchmark to check how many inserts the database can handle each second is will that result be about the same as the number of inserts the same database can handle using the C API? I guess not. Using a MySQL server on a machine with a 1000 mhz AMD processor I can insert 200 strings + timestamps a second through the API. Does that sound too less or am I expecting too much? Do benchmarks or test results for the C API exist? If someone has more experience on this or knows a place where I can find out more, plz let me know. Greetings, Raf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AUTO_INCREMENT Confusion
Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC. In a way I'm relieved; for a while there I thought I was losing my ability to read and understand a good technical book... Kevin McBrearty ATG Automation Technologies Group Ltd. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 12:53 AM To: Kevin McBrearty; [EMAIL PROTECTED] Subject: Re: AUTO_INCREMENT Confusion At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote: I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an AUTO-INCREMENT column defined as int unsigned primary key. Records are regularly added and then later deleted from this table. If the last record is deleted, the sequence begins at 1 again. Reading from MySQL (Paul Dubois) pages 94-95, it says that the values in an automatically generated series are strictly increasing and not reused, even if the maximum value is deleted. This applies to 3.23 and up. The sequence is restarted only if you delete all records from the table using the DELETE FROM tbl_name syntax. I am deleting row by row (DELETE FROM tbl_name WHERE...). Shouldn't the sequence be preserved, i.e. if the last record in the table has value 43 and I delete it, shouldn't the next record get 44 ? Yes, it should. I just tried it and it works. But then I changed the table to type BDB and got the behavior you're describing, so it appears the behavior differs betweeen table types. Are you using a BDB table? I am running 3.23.37 on Suse 7.0 Thanks. Kevin McBrearty ATG Automation Technologies Group Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AUTO_INCREMENT Confusion
Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC. In a way I'm relieved; for a while there I thought I was losing my ability to read and understand a good technical book... Kevin McBrearty ATG Automation Technologies Group Ltd. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 12:53 AM To: Kevin McBrearty; [EMAIL PROTECTED] Subject: Re: AUTO_INCREMENT Confusion At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote: I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an AUTO-INCREMENT column defined as int unsigned primary key. Records are regularly added and then later deleted from this table. If the last record is deleted, the sequence begins at 1 again. Reading from MySQL (Paul Dubois) pages 94-95, it says that the values in an automatically generated series are strictly increasing and not reused, even if the maximum value is deleted. This applies to 3.23 and up. The sequence is restarted only if you delete all records from the table using the DELETE FROM tbl_name syntax. I am deleting row by row (DELETE FROM tbl_name WHERE...). Shouldn't the sequence be preserved, i.e. if the last record in the table has value 43 and I delete it, shouldn't the next record get 44 ? Yes, it should. I just tried it and it works. But then I changed the table to type BDB and got the behavior you're describing, so it appears the behavior differs betweeen table types. Are you using a BDB table? I am running 3.23.37 on Suse 7.0 Thanks. Kevin McBrearty ATG Automation Technologies Group Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compilation error on HP-UX 11.00 with mysql-3.23.37
$ uname -a HP-UX mnemosyn B.11.00 U 9000/800 122901567 unlimited-user license $ cc -V /tmp/none.c cpp.ansi: HP92453-01 A.11.01.00 HP C Preprocessor (ANSI) ccom: HP92453-01 A.11.01.00 HP C Compiler $ aCC -V aCC: HP ANSI C++ B3910B A.03.13 $ LDFLAGS=+DA2.0W CFLAGS=+DA2.0W -D_REENTRANT CXXFLAGS=+DA2.0W -D_REENTRANT CPPFLAGS=-D_REENTRANT CC=cc CXX=aCC ./configure --with-pthread --with-named-thread-libs=-lpthread --with-charset=koi8_ru --with-extra-charsets=cp1251,latin1 --prefix=/usr/local/mysql --without-debug --disable-shared $ make [skip] Error 19: mysqld.cc, line 2480 # Unexpected ','. OPT_GEMINI_UNBUFFERED_IO, OPT_SKIP_SAFEMALLOC, ^ *** Error exit code 2 Stop. *** Error exit code 1 Stop. Here is the diff which solves this problem *** mysqld.cc.orig Tue May 8 15:43:23 2001 --- mysqld.cc Tue May 8 15:43:33 2001 *** *** 2477,2483 OPT_GEMINI_SKIP, OPT_INNODB_SKIP, OPT_TEMP_POOL, OPT_TX_ISOLATION, OPT_GEMINI_FLUSH_LOG, OPT_GEMINI_RECOVER, !OPT_GEMINI_UNBUFFERED_IO, OPT_SKIP_SAFEMALLOC, }; static struct option long_options[] = { --- 2477,2483 OPT_GEMINI_SKIP, OPT_INNODB_SKIP, OPT_TEMP_POOL, OPT_TX_ISOLATION, OPT_GEMINI_FLUSH_LOG, OPT_GEMINI_RECOVER, !OPT_GEMINI_UNBUFFERED_IO, OPT_SKIP_SAFEMALLOC }; static struct option long_options[] = { Regards, Maxim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Install problem
I am having a problem installing the MyODBC drivers. I run setup but nothing happens. Any ideas? David [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,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. You have written the following: I am having a problem installing the MyODBC drivers. I run setup but nothing happens. Any ideas? David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC General Question
Good Day: I was just wondering, if I'm using mm.mysql.jdbc-1.2c to connect to a database w/JAVA do I also need MyODBC installed and configured also? Or is mm.mysql.jdbc-1.2c all I need? Thanks alot.. Greg __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Slow Loading page and query
Hi there, Using MySQL 3.22.27 and php3. The page I have does 7 queries to the database and then displays the page. The first time it runs it takes 9 secs or more before the data is displayed and then after that the thread is cached on MySQL. But when I run the same Query from MySQL console I get query times of .16 secs. I have changed the query and use the 'limit 2' in the sql statement and it still takes 9 or more secs if it is not a cached thread. The SQL statement is as follows: SELECT mlsnumber from custmls where listingoffice = 0251 and (listingstatus = 'ACT' or listingstatus = 'A*') and scategory = 1 limit 2 The only thing different in each query is the value of scategory. This the first time its run takes 9 or more seconds, there is an index on listingstatus the looks at 12000 records. I have tried an index on listing office,listingsstatus and scategory to see if it speeds up the query and I get a result of 0 , where there are 81 records matching when I did a count before the index was created. There are only 71685 records in the table. I have set the following variables: set-variable =key_buffer=16M set-variable =table_cache=256 set-variable =sort_buffer=4M set-variable =record_buffer=1M I'm running on a Sun Ultra 10s 333 sparc Processor and 256mb of ram, Solaris 7 OS. Any ideas would be great. Thanks in advance. Pat Pat Militzer Tech Support Supervisor Metro/MLS Inc. 11430 W North Ave Wauwatosa, WI 53226 414-778-5400 ext. 124 Fax 778-6143 email: [EMAIL PROTECTED] web site: www.metromls.com www.wihomes.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlgui problem
I compiled all the components of MySQLgui without problems, but when I ran the mysqlgui program, I got the following error message: error while loading shared libraries: libsqlplus.so.1: cannot open shared object file: no such file or directory. Can you help me? -Kingsley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INNO How to set autocommit=0 as default for mysql
Hi, I would like to set autocommit = 0 as the default value when running the mysql frontend. (Maybe with an entry in my.cnf) Is that possible ??? Andre -- E-Mail: [EMAIL PROTECTED] Date: 08-May-01 Time: 15:42:09 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database Error
Good Day: Could someone help me and tell me which direction to go to see why I'm getting unknown database error caught by the SQLException catch. I checked to make sure that the Class.forName was being executed and it was. Just need a little helping hand. Thanks... Greg __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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:INNO How to set autocommit=0 as default for mysql
Andre, I did not find such an option in my.cnf. But I agree that there should be one. I will ask Monty to add that option to my.cnf. Regards, Heikki . Hi, I would like to set autocommit = 0 as the default value when running the mysql frontend. (Maybe with an entry in my.cnf) Is that possible ??? Andre -- E-Mail: [EMAIL PROTECTED] Date: 08-May-01 Time: 15:42:09 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Commit and Rollback.
Hi, Will MySQL support COMMIT and ROLLBACK. Thank You Rajeev Ramanujan
Re: Performance MySQL with C-API
insert 200 strings + timestamps a second through the API. Does that sound too less or am I expecting too much? Do benchmarks or test results for the C API exist? If someone has more experience on this or knows a place where I can find out more, plz let me know. I just ran this test on a win32-machine with 500MHz, 196 MB RAM and IDE-drive: - created table test with 3 fields: id (unsigned int, primary key, autoincrement, not null), string (varchar 128), ts (timestamp 14) - generated 10.000 random string-values (32 chars each) and made 1 insert-query out of them: insert into test (string) values (randomstring1), values (randomstring3), ... values (randomstring1) - executed this query with mysql-front (same as C-API) Result: less than one second execution time! On our sun solaris (450MHz, 256RAM) the same query needed 1,6 seconds (through php!). I think execution time depends very much on database-design. Greetings, Ansgar Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
.37 INNO Strange behaviour after deleting a table
Hi, I accidently delete all my records from a table, but I always make backups!!! Okay, I deleted the (empty) table with drop table. Than I recreate the table and all the data mith a mysql batch job (from mysqldump) . No problem. Than I started the mysql UI and make some test queries. select * from passwd; All records are displayed if I query only for one column I get an empty set back select pw_name from passwd where pw_name='pbs013'; Empty set (0.00 sec) If I query for the whole record all works fine: mysql select * from passwd where pw_name='pbs013'; +-++-+---+++---+ --+--+ | name_nr | nr | pw_name | pw_passwd | pw_uid | pw_gid | pw_gecos | pw_dir | shell_nr | +-++-+---+++---+ --+--+ | 50 | 50 | pbs013 | deleted | 10013 | 1 | andre konopka | /home/pbs013 |1 | +-++-+---+++---+ --+--+ 1 row in set (0.00 sec) After restarting mysqld all works as expected??? mysql select pw_name from passwd where pw_name='pbs013'; +-+ | pw_name | +-+ | pbs013 | +-+ 1 row in set (0.01 sec) Andre -- E-Mail: [EMAIL PROTECTED] Date: 08-May-01 Time: 16:28:44 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. I heard if you play the NT-4.0-CD backwards, you get a satanic message That is nothing, if you play it forward, it installs NT-4.0 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Performance MySQL with C-API
Not only database design but system as well. Drive speed, drive fragmentation and I/O resources can play a large factor in database speed. Could you have a better disk environment on the Solaris machine versus the win32-machine? -Original Message- From: Ansgar Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 9:29 AM To: [EMAIL PROTECTED] Subject: Re: Performance MySQL with C-API insert 200 strings + timestamps a second through the API. Does that sound too less or am I expecting too much? Do benchmarks or test results for the C API exist? If someone has more experience on this or knows a place where I can find out more, plz let me know. I just ran this test on a win32-machine with 500MHz, 196 MB RAM and IDE-drive: - created table test with 3 fields: id (unsigned int, primary key, autoincrement, not null), string (varchar 128), ts (timestamp 14) - generated 10.000 random string-values (32 chars each) and made 1 insert-query out of them: insert into test (string) values (randomstring1), values (randomstring3), ... values (randomstring1) - executed this query with mysql-front (same as C-API) Result: less than one second execution time! On our sun solaris (450MHz, 256RAM) the same query needed 1,6 seconds (through php!). I think execution time depends very much on database-design. Greetings, Ansgar Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AUTO_INCREMENT Confusion
Hi! I think that for BDB and InnoDB tables MySQL first executes SQL SELECT MAX(auto-increment-column) FROM your-table for the table, and then adds 1 to the value it gets. It means that if you delete the row with the highest counter value, MySQL will assign it again to a new row. On the other hand, MySQL probably stores the counter value separately in a MyISAM table, and therefore it will not be reused even if the row is deleted. I will change InnoDB in a future version so that it executes the SELECT MAX... only when the table is opened the first time after the database startup, and after that will increment the counter monotonously. Regards, Heikki Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC. In a way I'm relieved; for a while there I thought I was losing my ability to read and understand a good technical book... Kevin McBrearty ATG Automation Technologies Group Ltd. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 12:53 AM To: Kevin McBrearty; [EMAIL PROTECTED] Subject: Re: AUTO_INCREMENT Confusion At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote: I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an AUTO-INCREMENT column defined as int unsigned primary key. Records are regularly added and then later deleted from this table. If the last record is deleted, the sequence begins at 1 again. Reading from MySQL (Paul Dubois) pages 94-95, it says that the values in an automatically generated series are strictly increasing and not reused, even if the maximum value is deleted. This applies to 3.23 and up. The sequence is restarted only if you delete all records from the table using the DELETE FROM tbl_name syntax. I am deleting row by row (DELETE FROM tbl_name WHERE...). Shouldn't the sequence be preserved, i.e. if the last record in the table has value 43 and I delete it, shouldn't the next record get 44 ? Yes, it should. I just tried it and it works. But then I changed the table to type BDB and got the behavior you're describing, so it appears the behavior differs betweeen table types. Are you using a BDB table? I am running 3.23.37 on Suse 7.0 Thanks. Kevin McBrearty ATG Automation Technologies Group Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:.37 INNO Strange behaviour after deleting a table
Andre, it might be a bug in the multiversioning code in InnoDB. Can you describe in detail the situation: - What is the CREATE TABLE statement? - How many rows there are in the table? - How did you import the table? - Are you able to repeat the bug if you delete and drop the table, and create and import it again? Regards, Heikki .. Hi, I accidently delete all my records from a table, but I always make backups!!! Okay, I deleted the (empty) table with drop table. Than I recreate the table and all the data mith a mysql batch job (from mysqldump) .No problem. Than I started the mysql UI and make some test queries. select * from passwd;All records are displayed if I query only for one column I get an empty set back select pw_name from passwd where pw_name='pbs013';Empty set (0.00 sec) If I query for the whole record all works fine: mysql select * from passwd where pw_name='pbs013'; +-++-+---+++--- + --+--+ | name_nr | nr | pw_name | pw_passwd | pw_uid | pw_gid | pw_gecos | pw_dir | shell_nr | +-++-+---+++--- + --+--+ | 50 | 50 | pbs013 | deleted | 10013 | 1 | andre konopka | /home/pbs013 |1 | +-++-+---+++--- + --+--+1 row in set (0.00 sec) After restarting mysqld all works as expected??? mysql select pw_name from passwd where pw_name='pbs013';+-+| pw_name | +-+| pbs013 |+-+1 row in set (0.01 sec)Andre --E-Mail: [EMAIL PROTECTED] Date: 08-May-01Time: 16:28:44 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:Commit and Rollback.
Rajeev, with the transaction-safe table types InnoDB and BDB, MySQL supports commit and rollback. They are available in the Unix source distribution and in the MySQL -Max binary distribution. Monty said he already has also Windows sources ready and will post them once he has time. Regards, Heikki Tuuri Innobase Oy http://www.innobase.fi Hi, Will MySQL support COMMIT and ROLLBACK. Thank You Rajeev Ramanujan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems with mysql and access
I have downloaded the ODBC driver 2.50 37-nt form www.mysql.com http://www.mysql.com/ , I have installed it and I have created the ODBC data source called sample_mysql, but when I try to import tables form access I get an error message saying: [TCX][MyODBC] cannot connect to mysql server (10061) (#2003). My operative system is Win2000 and Im sure the IP address is right. Can you help? Thanks mariella
Newbie... accessing mysql on linux via myodbc...please help ..
Hi all... I am using mysql database in linux. Now we want to use odbc calls in a linux program to access this database. Is this possible? I have no idea of this... and as my project dead line is near i am in a fix. so if someone could tell me about this approach and also send in a very simple example it would be great. Thanks in advance... Regards Dp Balcom Systems Technologies, Inc. (408)468-6608 _ 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: Performance MySQL with C-API
Could you have a better disk environment on the Solaris machine versus the win32-machine? The Solaris machine was a little bit slower executing the query, but it runs as a production-webserver and there is much more load on it than on my win32-test-machine. query that inserted 1 string values, but wouldn't it make a great difference if you made 1 queries that each inserted only one value?? that's more my situation and I think that's a lot slower, but I do agree I tested it with 10.000 queries executing one after the other with MySQL-Front, too. Result: about 20 seconds. You must notice one thing: executing one query with a GUI like MySQL-Front means not only executing, but *many* other things too: desplaying the query in the history-window, finding out, if the query returns a result and so on. These side-mechanisms take a lot of time. If you make an application with the C-API, which executes exactly only the query and *nothing* else, you would get much better results. Greetings, Ansgar Becker [EMAIL PROTECTED] | http://www.anse.de AB7670-RIPE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my sql database and unique keys
Hi, How can I have an UNIQUE key in MYSQL which differentiates between case sensitive strings.i.e If I want to store XYZ,XYz and xyz differently.Currently mySQl is not accepting this type of strings and treating them as the same. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-test-run fails five tests
Description: On both precompiled and site compiled versions, the testsuite reports errors in rpl000xx.test. This is on Solaris7. The precompiled version reports the following errors: rpl01 rpl04 rpl07 The site compiled version reports the following errors: rpl01 rpl04 rpl07 rpl15 rpl16 How-To-Repeat: $ mysql-test/mysql-test-run Fix: ?? Submitter-Id: submitter ID Originator: Organization: - leif rustvold - computer action team - 503.725.5420 - [EMAIL PROTECTED] MySQL support: [none | licence | email support | extended email support ] Synopsis: mysql-test-run reports errors, both pre- and site-compiled Severity: non-critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Environment: System: SunOS fisheye.cat.pdx.edu 5.7 Generic_106541-15 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make /pkgs/gnu/bin/gmake /usr/local/bin/gcc /usr/ccs/bin/cc GCC: Reading specs from /pkgs/gcc/gcc-2.95.2/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1710308 Feb 21 16:16 /lib/libc.a lrwxrwxrwx 1 root root 11 Jul 31 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1124692 Feb 21 16:16 /lib/libc.so.1 -rw-r--r-- 1 root bin 1710308 Feb 21 16:16 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jul 31 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1124692 Feb 21 16:16 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/pkgs/mysql/mysql-3.23.37 Perl: This is perl, version 5.004_01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my sql database and unique keys
VVM Ravikumar Sarma Chengalvala wrote: Hi, How can I have an UNIQUE key in MYSQL which differentiates between case sensitive strings.i.e If I want to store XYZ,XYz and xyz differently.Currently mySQl is not accepting this type of strings and treating them as the same. Regards, Ravi You need to use the binary keyword when creating the column http://www.mysql.com/doc/C/H/CHAR.html or you can alter the column and add the binary key word, otherwise char and varchar are not compared with consideration of case - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Front
I have downloaded mysql front and I was wandering how on the server end I can connect to it from a remote location. I keep getting 'hostname is not allowed to connect to this mysql server. I do have a static ip at this remote location. I am new to mysql so sorry if this has already been answered. Thanks Todd Woolums Wescris Solutions http://www.wescris.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
BDB table handler error 30996
when a BDB table is being written to and another thread issues a query I sometimes get this error code. Ideas? The table is fresh it was created by the dumpfile that another thread is loading in while I'm running the count query. this is mysql-max 3.23.37 mysql select count(*) from _data; +--+ | count(*) | +--+ | 125917 | +--+ 1 row in set (26.58 sec) mysql select count(*) from _data; ERROR 1030: Got error -30996 from table handler both queries were run while the table was loading the data, the data is in the extedned-insert format. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FULLTEXT relevancy
Couple problems here... Have a database with 36,316 emails archived. emailarchive.emailbody has a FULLTEXT index. If I query on a term that exists in the majority of the emails, it returns 0 rows and takes an incredible amount of time. mysql SELECT count('') FROM emailarchive where listnum = 1 and match (emailbody) against ('shawn') group by''; Empty set (7.19 sec) The above query should return a total of 22,778. mysql SELECT count('') FROM emailarchive where listnum = 1 and match (emailbody) against ('mysql') group by''; +---+ | count('') | +---+ | 121 | +---+ 1 row in set (0.03 sec) Change nothing but the word you are searching on and it's relatively fast (although it gets slower the more instances is there are) mysql SELECT count('') FROM emailarchive where listnum = 1 and match (emailbody) against ('billing') group by''; +---+ | count('') | +---+ | 5062 | +---+ 1 row in set (1.43 sec) The only thing I can think of is that the relevancy ranking causing both problems (null set and speed problems) as it gets slower and slower the more results there are until finally it just stops returning anything (maybe there are so many the relevancy is zero?) If that is the case, is there anyway to turn off the relevancy ranking portion altogether or any suggestions to make it not so painfully slow? 7+ seconds for an indexed search on 36,000 records seems a little excessive (the FileMaker database that we are upgrading from does the 'shawn' search in 0.42 seconds and returns the correct results). - Shawn --- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-test-run fails five tests
Hi David, did you ever find out how to resolve the problem where rpl15 and rpl16 fail, after a mysql-3.23.37 build? I have the same problem, when building (using gcc-2.95.3) for Solaris/SPARC 7 and 8. When I run rpl15, the mysqld-slave.err messages say -- 010508 20:50:19 Slave: connected to master '[EMAIL PROTECTED]:9306', replication started in log 'master-bin.001' at position 73 010508 20:50:20 Slave thread killed while reading event 010508 20:50:20 Slave thread exiting, replication stopped in log 'master-bin.001' at position 73 010508 20:50:20 Slave thread: error connecting to master:Can't connect to MySQL server on '127.0.0.1' (146)(134), retry in 60 sec 010508 20:50:20 Slave thread killed while connecting to master 010508 20:50:20 Slave thread exiting, replication stopped in log 'FIRST' at position 4 010508 20:50:20 Slave thread: error connecting to master:Can't connect to MySQL server on '127.0.0.1' (146)(134), retry in 60 sec 010508 20:50:20 Slave thread killed while connecting to master 010508 20:50:20 Slave thread exiting, replication stopped in log 'FIRST' at position 4 010508 20:50:20 Slave: connected to master '[EMAIL PROTECTED]:9306', replication started in log 'FIRST' at position 4 010508 20:50:20 Slave: received 0 length packet from server, apparent master shutdown: (0) 010508 20:50:20 Slave: Failed reading log event, reconnecting to retry, log 'master-bin.001' position 73 010508 20:50:20 Slave thread: error re-connecting to master:, last_errno=134, retry in 60 sec Thanks; Larry C. ([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
AIX recommendations
Hi Darren, were you ever able to resolve the failures for tests rpl15 and rpl16 (mentioned in your 27-Apr message)? I have the same problem, when building (using gcc-2.95.3) for Solaris/SPARC 7 and 8. When I run rpl15, the mysqld-slave.err messages say -- 010508 20:50:19 Slave: connected to master '[EMAIL PROTECTED]:9306', replication started in log 'master-bin.001' at position 73 010508 20:50:20 Slave thread killed while reading event 010508 20:50:20 Slave thread exiting, replication stopped in log 'master-bin.001' at position 73 010508 20:50:20 Slave thread: error connecting to master:Can't connect to MySQL server on '127.0.0.1' (146)(134), retry in 60 sec 010508 20:50:20 Slave thread killed while connecting to master 010508 20:50:20 Slave thread exiting, replication stopped in log 'FIRST' at position 4 010508 20:50:20 Slave thread: error connecting to master:Can't connect to MySQL server on '127.0.0.1' (146)(134), retry in 60 sec 010508 20:50:20 Slave thread killed while connecting to master 010508 20:50:20 Slave thread exiting, replication stopped in log 'FIRST' at position 4 010508 20:50:20 Slave: connected to master '[EMAIL PROTECTED]:9306', replication started in log 'FIRST' at position 4 010508 20:50:20 Slave: received 0 length packet from server, apparent master shutdown: (0) 010508 20:50:20 Slave: Failed reading log event, reconnecting to retry, log 'master-bin.001' position 73 010508 20:50:20 Slave thread: error re-connecting to master:, last_errno=134, retry in 60 sec Thanks; Larry C. ([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
loader
hi list, im giving this command mysqlLOAD DATA LOCAL INFILE c:/phani/phani.txt INTO TABLE phani1; the columns in phani1 are equal to columsn in phani.txt There are totally 3 columsn (empno, ename, address) when i say select * from phani1; im getting only empno and null values for ename and address fields Regards, Venkata Sudheer Buddiga. Web Hosting Solutions, Ext : 219, 250 === Venkata Sudheer Buddiga Nettlinx Limited, 3rd Floor, My Home Sarovar Plaza, Secretariat Road, Saifabad, Hyderabad- 500 004. Tel: +91 (0)40 3232 200 Fax: +91 (0)40 3231 610 http://www.nettlinx.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: loader
Specify the format of the text field in your query. For example, if the fields are tab-delimited and each line is a new row, you would use load data local infile 'c:\phani\phani.txt' into table phani1 fields terminated by '\t' rows terminated by '\n'; Ben Gollmer On Tuesday, May 8, 2001, at 01:42 PM, Venkata Sudheer Buddiga wrote: hi list, im giving this command mysqlLOAD DATA LOCAL INFILE c:/phani/phani.txt INTO TABLE phani1; the columns in phani1 are equal to columsn in phani.txt There are totally 3 columsn (empno, ename, address) when i say select * from phani1; im getting only empno and null values for ename and address fields Regards, Venkata Sudheer Buddiga. Web Hosting Solutions, Ext : 219, 250 === Venkata Sudheer Buddiga Nettlinx Limited, 3rd Floor, My Home Sarovar Plaza, Secretariat Road, Saifabad, Hyderabad- 500 004. Tel: +91 (0)40 3232 200 Fax: +91 (0)40 3231 610 http://www.nettlinx.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 mysql-unsubscribe- [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 table..
create table button doesnt work. William Bowman Hirons Company Interactive Programmer 555 N. Morton St. Bloomington,Indiana 47404 812-331-7500 Ext. 150 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 2:39 PM To: William Bowman Subject: Re: create table.. 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: database,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. You have written the following: create table button doesnt work. William Bowman Hirons Company Interactive Programmer 555 N. Morton St. Bloomington,Indiana 47404 812-331-7500 Ext. 150 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Not unique table/alias
What does this mean? It is referring to the following SQL statement: INSERT INTO MaterialSubwall SELECT subwallClassId, mirrorEW, rotation + 180, sizeX, sizeY, offsetS, offsetW, offsetN, offsetE FROMMaterialSubwall; AFAIK, this is perfectly valid SQL syntax. Peter Spierenburg. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using where xxxx in (select ...... )
Hello, I have recently converted my Java Servlets to run against mySQL where previously I was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything works fine, more or less. However, I have one big problem which is as follows :- My servlet software dynamically builds SQL of the following form, which to my knowledge is fairly standard :- - Query is: select * from service where ((primary_category in (select sub_category from category where sport = 1 ))); java.sql.SQLException: Syntax error or access violation: You have an error in yo ur SQL syntax near 'select sub_category from category where sport = 1 )))' at li ne 1 - The text above is copied directly from some diagnostics on my Tomcat console. If I use exactly the same query from phpMyAdmin I get exactly the same error so it's not my JDBC driver that's at fault. Why won't mySQL let me use this construct ? Many thanks. Jon Green.
Re: Using where xxxx in (select ...... )
green jon wrote: Hello, I have recently converted my Java Servlets to run against mySQL where previously I was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything works fine, more or less. However, I have one big problem which is as follows :- http://www.mysql.com/doc/M/i/Missing_Sub-selects.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using where xxxx in (select ...... )
On Tue, 8 May 2001 22:38:52 +0100, green jon [EMAIL PROTECTED] wrote: MySQL currently does not support sub select queries Hello, I have recently converted my Java Servlets to run against mySQL where previously I was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything works fine, more or less. However, I have one big problem which is as follows :- My servlet software dynamically builds SQL of the following form, which to my knowledge is fairly standard :- - Query is: select * from service where ((primary_category in (select sub_category from category where sport = 1 ))); java.sql.SQLException: Syntax error or access violation: You have an error in yo ur SQL syntax near 'select sub_category from category where sport = 1 )))' at li ne 1 - The text above is copied directly from some diagnostics on my Tomcat console. If I use exactly the same query from phpMyAdmin I get exactly the same error so it's not my JDBC driver that's at fault. Why won't mySQL let me use this construct ? Many thanks. Jon Green. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: create table..
got an error in PhpMyAdmin for this syntax but no error message displayed, could someone help me that's the first time i run such inner joins on an other DDB than Ms SQL ... Here's the Query : SELECT informations.titre, informations.Texte FROM informations INNER JOIN recurrence_informations ON recurrence_informations.id_informations = informations.id INNER JOIN recurrence ON recurrence.id = recurrence_informations.id_recurrence INNER JOIN type ON type.id_type = recurrence.type WHERE type.nom_type = 'liens' LIMIT 6 TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not unique table/alias
Check out the 2nd bullet under 7.21.1 of the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#INSERT_SELECT You could do this by creating a temporary table out of MaterialSubwall and using that to select rows for the insert. - TIM What does this mean? It is referring to the following SQL statement: INSERT INTO MaterialSubwall SELECT subwallClassId, mirrorEW, rotation + 180, sizeX, sizeY, offsetS, offsetW, offsetN, offsetE FROMMaterialSubwall; AFAIK, this is perfectly valid SQL syntax. Peter Spierenburg. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to move a MySQL database from Windows to Linux machine.
Hello, I have a question on moving a MySQL database from a Windows Me machine to a Linux machine. Most of our tables have over 22 million rows. I suppose the slow but safe way is to dump the whole database on the Windows machine using mysqldump and then ftp the dump file over to the Linux box. But to save time can I just ftp over the files in the /data directory in ascii mode ? Or does Mysql store the data differently in Windows vs Unix and I have to do this the slower way as mentioned above ? Thank you. ___ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange behavior.
Hi, Im not sure wheter this is a bug ( and it will make me look silly ) but its been annoying :).. It could even have been fixed since 3.22.27 :) ( Yes! I will upgrade tomorrow :) I have these three tables: ***RULES*** CREATE TABLE rules (id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, owner int(10), name blob, comment blob, allow bit, allusers bit, allcds bit, date_entered DATETIME); *** ***RULEMEMBERS*** CREATE TABLE rulemembers (id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, ruleid int(10), userid int(10), date_entered DATETIME); *** insert into rulemembers (ruleid,userid) values(0,0); ***RULEITEMS*** CREATE TABLE ruleitems (id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, ruleid int(10), itemid int(10), date_entered DATETIME); *** And they are sloppy done, I know. As you probably understand they are linked togheter.. When I select data from rules I link with ruleitems and rulemembers. My SQL is looking like this (for example): select rules.id as ruleid from rules, rulemembers, ruleitems where rules.owner = 1 and rules.allow and ((rulemembers.ruleid = rules.id and rulemembers.userid = 1) OR rules.allusers) and ((ruleitems.ruleid = rules.id and ruleitems.itemid = 100) OR rules.allcds) If there isnt some obvious errors in my SQL there is something wrong with MySQL because when I DONT have any posts in ruleitems or rulemembers this statement always returns zero. (Even if rules.allcds och rules.allusers is set). Very annoying. Well, shouts to the mysqlteam for a great product .. heh. and sorry if ive been bothering you about this if there isnt any problems. cheers. --Hjalmar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to move a MySQL database from Windows to Linux machine.
On Tue, May 08, 2001 at 03:15:31PM -0700, David Potter wrote: I have a question on moving a MySQL database from a Windows Me machine to a Linux machine. Most of our tables have over 22 million rows. I suppose the slow but safe way is to dump the whole database on the Windows machine using mysqldump and then ftp the dump file over to the Linux box. But to save time can I just ftp over the files in the /data directory in ascii mode ? Or does Mysql store the data differently in Windows vs Unix and I have to do this the slower way as mentioned above ? Thank you. MySQL 3.23.xx uses a platform independant format for the data. So just shut down the server and copy all the *.MYD *.MYI *.frm files over to Linux and go from there. Sure beats the time needed to dump and reload the data on the other end. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 125 days, processed 774,627,600 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MOD_AUTH_MYSQL
Is there anyone out there who knows where I can get support with this mod for apache? The web page listed in the package seems to be invalid and I can't seem to locate any support lists on the apache side of things. Actually any help at all on how to make this install or any other method out there to have apache authenticate against a mysql user database would be great. Here is what I have done so far: Downloaded mod_auth_mysql_2.20 from ftp.mysql.com. Noted that all links on the web page were broke so I just went on the ftp anonymous and started digging until I found it. I ran configure script with flag to point to source for apache which was not where the script expected. I then attempted to Make but it told me to run configure script on apache with --activate-module=/src/modules/auth_mysql/libauth_mysql.a then run make again. I get an error that states that it doesnt know how to make ../../alloc.h. I am unable to find this file in the folder it is looking in but do find it (or one with same name) in /usr/local/include/G++/ If I copy this file over to where make is expecting it then the apache make works but I still get the same message when I try to make mod_auth_mysql Whatever you can do to assist is greatly appreaciated. I am at a complete standstill until I can find a way to make mysql and apache work together. At present I am using htaccess files but I have no way to secure certain files by user name without having the user enter a password everytime they request a certain change. Thanks Jason Cribbins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FILE Permission Security Question
Hello everyone, I was wondering if anyone could help me out and explain a bit about the FILE permissions and how they relate to two particular scenarios: In both cases MySQL is running on SunOS 5.7 and running MySQL client version 3.22.23b MySQL UserA has permissions only on DatabaseA and is granted FILE permissions to all tables in that database Scenario 1: If UserA connects to the database using the MySQL client What are the restrictions on what files that user can access using a LOAD DATA command? Are they dependent at all on the UNIX file permissions for the user who is logged in and actually connects to the database using the mysql -u... etc command? Do the UNIX permissions for the user that started the MySQL server have any effect on this? Is there anything configuration wise that might allow LOADing in other DBs or system files? What defines where outfiles can be written? Scenario 2: If UserA's credentials are used to connect to the MySQL database using the Perl DBI Same question, what factors influence what files can be read in using a LOAD DATA command? What defines where outfiles can be written? In both scenarios is there anything that can compromise this security such as the MySQL server running as root? (I know that's a big no-no) Also, I know I'm running an ancient version of MySQL, can anyone help me find out when that version was released? 3.22.23b? It will help me convince the right people that it's time for an upgrade! I've checked in the release notes section but I can't find anything about when particular releases were made... Thanks, -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FILE Permission Security Question
At 11:13 PM -0400 5/8/01, A. Chris Nichols wrote: Hello everyone, I was wondering if anyone could help me out and explain a bit about the FILE permissions and how they relate to two particular scenarios: In both cases MySQL is running on SunOS 5.7 and running MySQL client version 3.22.23b MySQL UserA has permissions only on DatabaseA and is granted FILE permissions to all tables in that database Nope. The FILE privilege is one of the global privileges. You either have it or you don't. Doesn't depend on which databases you have access to. (The indicator for whether or not you have the FILE privilege is stored in the user table along with the other global privileges. That table isn't db-specific.) Scenario 1: If UserA connects to the database using the MySQL client What are the restrictions on what files that user can access using a LOAD DATA command? Are they dependent at all on the UNIX file permissions for the user who is logged in and actually connects to the database using the mysql -u... etc command? Do the UNIX permissions for the user that started the MySQL server have any effect on this? Is there anything configuration wise that might allow LOADing in other DBs or system files? What defines where outfiles can be written? The user who is logged in has nothing to do with the LOAD DATA (this is not true for LOAD DATA LOCAL, but that's not what you're asking about). There are two reasons for this: 1) you connect to the server using a MySQL user name, not your UNIX login name. (They might be the same, but that's just coincidence.) 2) The server can only access files that are accessible by the account whose ID the server runs as. This has nothing to do with either your MySQL user name *or* your UNIX login name. What defines where outfiles can be written are the privileges of the UNIX account under which the server runs. There's nothing special about this. If the server runs as root, it can access anything (which is why it's a bad bad bad idea to run the server as root). If the server runs as an ordinary user, it has that user's privileges. Scenario 2: If UserA's credentials are used to connect to the MySQL database using the Perl DBI Same question, what factors influence what files can be read in using a LOAD DATA command? What defines where outfiles can be written? The privileges of the UNIX account under which the server runs. Doesn't matter what MySQL user you connect to the server as. In both scenarios is there anything that can compromise this security such as the MySQL server running as root? (I know that's a big no-no) Right. Don't run the server as root. Run it as an ordinary user to limit the amount of damage it can do. (Or that users with the FILE privilege can make it do.) Also, I know I'm running an ancient version of MySQL, can anyone help me find out when that version was released? 3.22.23b? It will help me convince the right people that it's time for an upgrade! I've checked in the release notes section but I can't find anything about when particular releases were made... Not sure exactly, but I know it was prior to December 1999. Thanks, -Chris -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL help
How do I write SQL in MySQL to randomly select 5 records from a table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 help
SELECT * FROM db ORDER BY rand() LIMIT 5 --zak - Original Message - From: Webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 9:38 PM Subject: SQL help How do I write SQL in MySQL to randomly select 5 records from a table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Front
I have a dedicated server in a colocation data center and I have root access but I would like to use mysqlfront(http://www.mysqlfront.de) to administer the mysql server from a specific location my static ip on a different computer. Sorry should have been more clear about it. Todd Woolums Wescris Solutions http://www.wescris.com [EMAIL PROTECTED] - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: TWooly [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 8:41 PM Subject: Re: mysql Front You mean mysql client?!! and what about the mysql server? Is it running on your ISP?? Some ISP's do not allow remote access. You also need to read Ch 6 and the GRANT and REVOKE statements in Ch 7 - Original Message - From: TWooly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 0:55 Subject: mysql Front I have downloaded mysql front and I was wandering how on the server end I can connect to it from a remote location. I keep getting 'hostname is not allowed to connect to this mysql server. I do have a static ip at this remote location. I am new to mysql so sorry if this has already been answered. Thanks Todd Woolums Wescris Solutions http://www.wescris.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 help
i think it is more suitable to do it in programming level in mysql, though I know there is a function is M$sql server. if your table schema has a unique id field, before submit a query to DB, 1) select count(*) from it 2) from the above resultset, program to draw whatever number of records you want. 3) submit the query, select * from it where id in (your random record ids); - Original Message - From: Webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 11:38 AM Subject: SQL help How do I write SQL in MySQL to randomly select 5 records from a table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
POST operation looses variables? *sometimes* HTTP 302 error???
This may not be a mysql issue, but mysql is the manefestation of the problem: Sometimes POST operation seems to loose variable contents, and the apache log shows 302 result. Blank row is inserted into DB. My script has a form: form method=post action= ?echo $PHP_SELF;??action=? if ($action==mod) echo modedlog_id=$log_id\; else echo add\; ? when the post occurs, the script checks $action. If $action==add, it does a db insert: if ($action == add) { $query = INSERT INTO log SET log_id = NULL, name = \$name\, category = \$category\, duration = \$duration:00\, date = \$date\, notes = \$notes\, timestamp = NULL, client = \$client\, billable = \$billable:00\; $queryResult= mysql_db_query($database, $query, $connection) or die (Could not execute query: $query. . mysql_error()); SOMETIMES it works fine. SOMETIMES, a blank record (all fields are empty) gets inserted into the record, and the apache log shows that the POST operation returned code 302: some.domain.com - - [08/May/2001:23:54:13 -0400] POST /log/index.php?action=add HTTP/1.0 302 0 http://www.mydomain.com/log/index.php?Example_Session=70d9b5e963be24003dcc780329b12a7b; Mozilla/4.76 [en] (X11; U; Linux 2.4.1-0.1.9 i686) After moving from a slow server to a fast server, the error occurs with increased frequency. Usually hitting [back] on the browser and posting again, the INSERT works correctly... but not always. I'm stumped. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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 Front
Ah! ok, maybe I won't be much help after all. Only thing I can think of would be your privilege tables. - Original Message - From: TWooly [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 11:58 Subject: Re: mysql Front I have a dedicated server in a colocation data center and I have root access but I would like to use mysqlfront(http://www.mysqlfront.de) to administer the mysql server from a specific location my static ip on a different computer. Sorry should have been more clear about it. Todd Woolums Wescris Solutions http://www.wescris.com [EMAIL PROTECTED] - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: TWooly [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 8:41 PM Subject: Re: mysql Front You mean mysql client?!! and what about the mysql server? Is it running on your ISP?? Some ISP's do not allow remote access. You also need to read Ch 6 and the GRANT and REVOKE statements in Ch 7 - Original Message - From: TWooly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 0:55 Subject: mysql Front I have downloaded mysql front and I was wandering how on the server end I can connect to it from a remote location. I keep getting 'hostname is not allowed to connect to this mysql server. I do have a static ip at this remote location. I am new to mysql so sorry if this has already been answered. Thanks Todd Woolums Wescris Solutions http://www.wescris.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL help
i dont follow step #3. At 11:42 PM 5/8/2001, Tony Shiu wrote: i think it is more suitable to do it in programming level in mysql, though I know there is a function is M$sql server. if your table schema has a unique id field, before submit a query to DB, 1) select count(*) from it 2) from the above resultset, program to draw whatever number of records you want. 3) submit the query, select * from it where id in (your random record ids); - Original Message - From: Webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 11:38 AM Subject: SQL help How do I write SQL in MySQL to randomly select 5 records from a table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL help
for 3) if you have a set of random values e.g. 1,3, 6, 9, 4 then your sql will be select * from your-table where id in (1, 3, 6, 9, 4); FYI: if you are using ver 3.23.X, you may use SELECT * FROM your-table ORDER BY rand() LIMIT 5 contributed from: Zak Greant [EMAIL PROTECTED] rand() seems using primary key of your table. mine works in both old and new versions. - Original Message - From: Webmaster [EMAIL PROTECTED] To: Tony Shiu [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 12:27 PM Subject: Re: SQL help i dont follow step #3. At 11:42 PM 5/8/2001, Tony Shiu wrote: i think it is more suitable to do it in programming level in mysql, though I know there is a function is M$sql server. if your table schema has a unique id field, before submit a query to DB, 1) select count(*) from it 2) from the above resultset, program to draw whatever number of records you want. 3) submit the query, select * from it where id in (your random record ids); - Original Message - From: Webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 11:38 AM Subject: SQL help How do I write SQL in MySQL to randomly select 5 records from a table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL help
You might be able to do something like this instead: SELECT *, id*0+RAND() AS r FROM table ORDER BY r LIMIT 5; Check the list archives, this issue comes up quite often. On Wed, 9 May 2001, Webmaster wrote: i dont follow step #3. At 11:42 PM 5/8/2001, Tony Shiu wrote: i think it is more suitable to do it in programming level in mysql, though I know there is a function is M$sql server. if your table schema has a unique id field, before submit a query to DB, 1) select count(*) from it 2) from the above resultset, program to draw whatever number of records you want. 3) submit the query, select * from it where id in (your random record ids); - Original Message - From: Webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 11:38 AM Subject: SQL help How do I write SQL in MySQL to randomly select 5 records from a table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Key_Writes Key_write_requests ???
Hi, Mysqladmin shows me : | Key_write_requests | 80850 | | Key_writes | 112447| What does it mean, and how could this be possible ? Thank you, Jocelyn Fournier Presence-PC www.presence-pc.com