Re: No Subject
At 20:31 13-4-01 +, [EMAIL PROTECTED] wrote: Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. PHP, Perl also seen message from people who use VB and ODBC to connect to MySQL. Take a look at this lists archive.. as far as I can remember a few messages about these should be found there. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ms frontpage
On Thu, 12 Apr 2001, ilker YILDIZ wrote: Install MyODBC Adrian Hi, I want connect mysql databse with ms front page 200. How? What do i? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Does MySQL support sub queries ?
Hi, Does anyone know whether this MySQL support sub queries? such as: select ref from tool1 where detail = 'xxx' and ref in (select ref from tool1 where detail='yyy'); No matter it's within the same table or different table. However below is the error I've got, anyone can help? ERROR 1064: You have an error in your SQL syntax near 'select ref from tool1 where detail='yyy')' at line 1 Thank you. rgds, Yen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Does MySQL support sub queries ?
On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote: Does anyone know whether this MySQL support sub queries? Anyone who has checked the MySQL Manual does. (Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ms frontpage
Hi MS FrontPage does not handle database connections. MS FrontPage is nothing more than a WYSYWYG HTML Editor. Database connectivity is handled by what is known as an Application Server e.g Miva Mia, PHP, IIS, ColdFusion, etc So the answer is consult the documention for your chosen Application Server At 23:40 12/04/2001 +0300, ilker YILDIZ wrote: Hi, I want connect mysql databse with ms front page 200. How? What do i? Thanks. Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, 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
Re: Stable version
Hi At 21:17 12/04/2001 -0400, Jocelyn Bernier wrote: Hi everybody, I am currently running MySQL 3.23.35 on Windows NT 4.0 SP6. I checked the mailing list regularly and didn't see any complaint or bug report regarding version 3.23.37. In fact I would like to know what is the most stable version running on that platform ? The best place to check for new versions is the MySQL web site or you could subscribe to the announcements list __ Jocelyn Bernier 259 Racicot Saint-Jean-sur-Richelieu, QC J3B 8N3 [EMAIL PROTECTED] (514) 572-5878 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, 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
Re: Select Question
Hi The short answer is no, but you could get around this by using JOIN Sub-queries are not yet supported At 21:39 12/04/2001 -0400, James Gonthier wrote: The following works ok in SQL Server, can it work in mySQL? select * from users where id in (select userid from group where name='sales') TIA, Jim Gonthier --- The Fastest Browser on Earth now for FREE!! Download Opera 5 for Windows now! Get it at http://www.opera.com/download/ --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, 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
Re: mail to mysql database recepient
I will like to mail all the users in Mysql database having valid email record, their data with user name and password. How to go about this? does anyone have a free script to share? I also want a column to be updated with random password for each user. This is an application issue. You can do this with PHP, C or Perl and a few others. I've got no free script.. but you could take a look at www.php.net I've seen several scripts there which might be twisted a bit to fit your needs. It's better to learn how to do this yourself. Several good tutorials can be found on the web. The book MySQL written by Paul DuBois can also be a good start if you don't like to search/read/print everything online. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Query and MySQL
Hello! I'm trying to use Microsoft Query (from MS Office 97) with MySQL 3.23.33 via MyODBC 2.50.36. (MySQL runs on a FreeBSD 4.3RC machine) It sometimes works, but often MySQL reports strange errors about inexistants tables or fields names. Often, in MySQL log file, I see something like "select dummy.foo dummy_0.foo from dummy dummy_0" where dummy is my table name and foo is my field(s) name. What's that "_0" (underscore zero) that it sometimes add ? I tried manually from mysql console login and it works ! It does not report errors like "table name not existant". But, if in MSQuery I try to use a "WHERE" clause it always uses the "_0" and MySQL complains ! What the "_0" represents, and why it's used ? I saw that MySQL accepts sometimes and refuses it other times. Does someone is successfully in using MSQuery with MySQL ? Any hint is welcome! :) Thanks a lot ! Alessandro de Manzano Playstos - TIMA S.p.A. Corso Sempione 63 20149 Milano, Italy tel.: +39-023314153 fax: +39-02315678 email: [EMAIL PROTECTED] http://www.playstos.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
count distinct
I can make this query: select a from table. I can count it: select count(a) from table. I can select it: select distinct a from table. But how can i count it? select count(distinct a) from table doesn't works Z - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: count distinct
On Fri, Apr 13, 2001 at 12:37:40PM +0200, Z_da_eXTaZie wrote: I can make this query: select a from table. I can count it: select count(a) from table. I can select it: select distinct a from table. But how can i count it? select count(distinct a) from table doesn't works It works for me on MySQL 3.23.36.. which version of MySQL are you running? G'luck, Peter -- I am jealous of the first word in this sentence. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is MySQL support distributed database ?
Is MySQL support distributed database or not ? If yes, then please let me know , how it's doing . Maybe not in a sense you'd like, but it has support for replication. Just read up on the manual, as in (the url will propably wrap): http://www.mysql.com/documentation/mysql/bychapter/manual_Replication.html#R eplication Now that you know about the term 'replication' you can just read the manual.. -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: No Subject
On Fri, 13 Apr 2001 [EMAIL PROTECTED] wrote: Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. Sure. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Select Diferences
- Original Message - From: [EMAIL PROTECTED] To: "Agustin Eloy Barrios Arteaga" [EMAIL PROTECTED] Sent: Friday, April 13, 2001 8:22 AM Subject: Re: Diferences 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: Hello: I have 3 tables to obtain one relation many to many, and need know when all elements whats not exists in the other part of relation. sorry my bad english ** * Agustin Eloy Barrios Arteaga* * Supervisor del CEIS * *[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
MySQL can be used with QNX Neutrino?
Could you please let me know whether MySQL database can be used with QNX Neutrino Realtime Platform ? If so, what version? Thanks for the help Lekha Das - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innobase name changes to InnoDB in 3.23.37, have to change my.cnf
Hi! To avoid mixing to a German company Innobase AG, we are changing the name of the product Innobase to InnoDB in 3.23.37. - In my.cnf you have to change the parameter names innobase_... to innodb_... - The SQL parser in 3.23.37 will still know the table type innobase, but before July 15, 2001, you should also change the CREATE TABLE table type from TYPE = INNOBASE to TYPE = INNODB. I am sorry for the extra work this causes to you. The name of the company will stay as Innobase Oy. The website will within a few days be reachable through www.innodb.com as well as www.innobase.fi My email address still stays as [EMAIL PROTECTED] 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
replication problems
does anyone that is using replication have any suggestions at all about how to get past this problem? is anyone using replication successfully? - Forwarded message from Jim Ziegler [EMAIL PROTECTED] - Envelope-to: [EMAIL PROTECTED] Delivery-date: Tue, 10 Apr 2001 16:42:26 -0400 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: replication problems From: Jim Ziegler [EMAIL PROTECTED] X-UIDL: bf6be71aa70b2cf435089831f4dbdcb3 mysql sql db I am unable to get replication running. I have set up both master and slave systems with version 3.23.33-log of musql. I can do a "load table from master" but when I start the slave, all I get in the slave log is: 010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010410 16:37:24 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010410 16:37:24 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) and in the master log: 010410 16:35:583006 Connect[EMAIL PROTECTED] on 3007 Connect[EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum What is wrong? Where do I get a better magician? -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - End forwarded message - -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Books
Paul's book on MYSQL, and the Wroc book on PHP... and you'll be good to go. On Thu, 12 Apr 2001 21:51:53 -0600, Mike wrote: I am looking at using MySQL,Apache and PHP on a Web app and was wondering if there was a good book out there. I seen a few on the MySQL site that look really interesting, any comments on them. Cheers Mike Benzel [EMAIL PROTECTED] Code it once with ASTA and run it anywhere Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE) ASTA Technology Group http://www.astatech.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
Update bug?
Hi, There might be some kind of bug in UPDATE. Let's say there is a 4 row table, which looks like this: | fd_01 | int(11) unsigned | | PRI | 0 | | | fd_02 | text | | | | | | fd_03 | varchar(4) | | | | | ... | fd_10 | varchar(20) | | MUL | | | | fd_11 | varchar(20) | | | | | and indexes are: | test| 0 | PRIMARY |1 | fd_01 | A | 40934 | NULL | NULL | | | test| 1 | fd_10|1 | fd_10 | A | 40934 | NULL | NULL | | Now when I do this update: UPDATE test SET fd_11='value' WHERE fd_10='some_value' it usually executes in 0.00 sec But when the query looks like this: UPDATE test SET fd_11='value' WHERE fd_10=some_value It takes about 2 seconds to execute. Tested on MySQL 3.23.36 / FreeBSD 4.2 (i386) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query to create table
Hi Though it is a simple question, i want help reg this. In the manual it is giving we can create table with foreign key and references table to make foreign key concept though it is not supporting the same. When i try to create the table with foreign key it is giving ERROR 1064: You have an error in your SQL syntax near 'order smallint(2), foreign key (code) references master(code))' at line 1 My query is: create table master(code varchar(10) not null, name varchar(20), primary key (code)) It is creating table correctly when i try to create this create table details(code varchar(10), scode varchar(20), order smallint(2), foreign key (code) references master(code)); I am getting the above error. I tried different options. Can u any of u send me the correct syntax with the example. My platform is Win NT. Thanks in advance Regards venkatesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Long Query or Multi
Is a more complex single query going to run faster on a server than several smaller queries where the results are set to variables and then used as criteria in tertiary queries. Bryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BLOB in mysql_create mysql++
Hello all, When I use mysql_create to create the struce to access table, I have a question about the BOLB type. My table defined as follow: drop table ClipBoard; #4-13 create table ClipBoard( # added 4-12 xuan li id INTEGER NOT NULL, data blob, primary key(id) ); Then I use mysql_create_2{ ClipBoard, 1,2, int,id, string, data }; If I use this clipBoard class to access table. Sometimes there is a error. I think string (the data type i am using) is not ok for blob. So what is the right datatype for blob. I know string is ok for text. Thanks Xuan Li - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Update bug?
On 2001 Apr 13, Maciek Dobrzanski [EMAIL PROTECTED] wrote: | fd_10 | varchar(20) | | MUL | | | | fd_11 | varchar(20) | | | | | Now when I do this update: UPDATE test SET fd_11='value' WHERE fd_10='some_value' it usually executes in 0.00 sec But when the query looks like this: UPDATE test SET fd_11='value' WHERE fd_10=some_value It takes about 2 seconds to execute. This is because with the first query it can use the index. With the second query, it has to check the whole table. Why? Because obviously you're using numbers. And let's make some_value == 10. In the second query it has to check for rows where fd_10 is: '10' '010' '0010' ... If you're storing numbers, use a numerical column. If you're testing a varchar field, use a string. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ 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
Client Problems
Hi, gnorpm did not list any other RPMs. I only downloaded one from mysql.com. At any rate, since I'm running Red Hat on that machine, I tried going to Red Hat's site, and they had several RPMs and I found the ones I needed. Is there a reason that msyql.com doesn't list any clients other than the GUI? Well, don't bother replying since I got something to work. Thanks for your help! Thanks, Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 table y select * from x;
MYSQL I am trying to create tables that will be used in merge definition. The merge seems to be very strict in the definition of like tables. So I tried to use the "create table y select * from x;" but it does not create the indexes in the new table. I did copy the x.frm to y.frm and all seem ok. Is there a better way to do this? When I created the original 150 tables I used a perl program that generated all the like tables, now I am faced with setting up another 15 tables and was trying to get out of writing another perl program. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: round and computer science
Dennis Nichols [EMAIL PROTECTED] writes: At 4/13/01 03:42 AM, Peter Holm wrote: mysql select floor(23.49 + 0.5); = 23 mysql select floor(23.499 + 0.5); = 24 Why are there different results? Apparently the closest (most accurate) expression of the first constant (23.49) as a floating point number using binary arithmetic is less than 23.5 while the closest expression of the second constant (23.499) is 23.5 or greater. This has to do with IEEE floating-point format. Both these are maintained internally as "double"s (as C programs usually do). An IEEE double is 64 bits long, with a 48-bit mantissa (the fractional part). 2^(-48) == 3*10^-15 (== basically, around 16 decimal digits of precision, with the 16th digit being approximate). Now, if you look at 23.49 (the first number), it has 16 digits (don't forget the part before the period - it's *significant* digits we're talking about here, since the format normalizes numbers so that the binary part before the period is always "1"). The second number has 17 digits, so the string-to-number converter tries to get the 16-digit number that closest approximates the 17-digit number (in this case, rounding it up to 23.5). (OK, the *real* nitpickers, back off :-). I'm just doing approximate math here, dredging up ancient memories of life in compiler and CPU-land..) -- Shankar Unni. [EMAIL PROTECTED]
Load Data Errcode 13
I keep getting the following error everytime i tried to use Load Data mysql load data infile '/home/laovision/lvdb/region.dat' - into table tlu_region fields terminated by '\t'; ERROR 13: Can't get stat of '/home/laovision/lvdb/region.dat' (Errcode: 13) I get same error using mysqlimport Any help would great. Thanks, Kalvin
Re: Update bug?
This is because with the first query it can use the index. With the second query, it has to check the whole table. Why? Because obviously you're using numbers. And let's make some_value == 10. I thought that maybe MySQL should check the field type and do the conversion to string. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to create table
Hi, On Fri, Apr 13, 2001 at 08:39:52PM +0530, Venkatesh T wrote: when i try to create this create table details(code varchar(10), scode varchar(20), order smallint(2), foreign key (code) references master(code)); ORDER is a reserved word in SQL. If you really want, you can use it for column names by back-quoting it like `order`. You will have to do that in all your queries then and any middleware you use would have to do the same. So I suggest you use a different name. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Update bug?
On 2001 Apr 13, Maciek Dobrzanski [EMAIL PROTECTED] wrote: This is because with the first query it can use the index. With the second query, it has to check the whole table. Why? Because obviously you're using numbers. And let's make some_value == 10. I thought that maybe MySQL should check the field type and do the conversion to string. To which string? '10' or ' 10' or '010', ...? One thing that might work in this case is to only scan the ranges ['0' - '1'], [' ' - '!'] and an exact match. Something like that. But it's messy, and best to fix the application. It would be nice if MySQL could optimize even the worst queries, though. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ 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: ssh connection between web server and mysql]
On Fri, Apr 13, 2001 at 09:35:38AM +0800, Leon Harris wrote: I believe that the session was idle. It also does it when I give the -2 option to ssh ( ssh2 is supposed to not time out, according to some usenet posts I have read). The point of the excercise is to have an encrypted connection that I can make DBI calls to the database. I am just using the mysql commandline tool to diagnose. Is either side behind a firewall or similar device doing Network Address Translation (NAT)? If so, that device may be the problem. I've seen that cause idle ssh connections to get dropped in the past. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trying to build mysql-3.23.36 on AIX 4.3.3.25
Hi, I downloaded the source of mysql and I am able to compile it fine. When i run "make" i get the following error, "my_pthread.c", line 456.5: 1506-068 (S) Operation between types "struct hostent*" and "int" is not allowed. I am using an IBM C++ compiler. I also followed all of the instructions in the manual for compiling on AIX. Is their a fix for this?? Thanks, Alain - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication
I'm 2/3 of the way to getting my daisy chained replication working. Here's my set up Machine 1: Compaq Proliant 6000, RedHat Linux 7, mysql 3.23.36, 1 NIC, 2 IPs server id 1 bound to IP 65.64.51.104 server id 2 bound to IP 65.64.51.105 Machine 2: Ultrasparc 450, Solaris 2.6, mysql 3.23.26, 1 NIC, 1 IP server id 3 What I want is 2 to replicate from 1, 3 to replicate from 2 and 1 to replicate from 3. However, when server 2's slave thread tries to connect to server 1, I get this: 010413 16:12:20 Slave thread: error connecting to master:Unknown MySQL Server Host '' (4)(107), retry in 60 sec I have name resolving turned off and have verified that all the grant tables are correct, flushed privileges. It seems that server 2 is not reading the master-host line? Here's the relevant section of the my.cnf for server 2: log-bin server-id = 2 master-host = 64.64.51.104 master-user = repl master-password = blahblah master-port = 3306 I've tried everything I can think of. Any help would be most appreciated! Cary -- Cary Collett [EMAIL PROTECTED] http://cary.ratatosk.org/ "To me boxing is like ballet, except that there's no music, no choreography, and the dancers hit eachother." -- Jack Handy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Exporting/Importing
Hi, I need to export data from development to production. Development - Win98 Production - Unix What is the best way to transport data to fro dev prod ? mysqldump doesn't seem to work - keeps giving me errors (of course, I don't know if I'm doing it the right way, and whether that command is the solution at all). Any help will be greatly appreciated. Thanks in advance, Ravi http://BabyNamesIndia.com __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.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: Exporting/Importing
On Fri, Apr 13, 2001 at 01:48:26PM -0700, Ravi Jayagopal wrote: Hi, I need to export data from development to production. Development - Win98 Production - Unix What is the best way to transport data to fro dev prod ? mysqldump doesn't seem to work - keeps giving me errors (of course, I don't know if I'm doing it the right way, and whether that command is the solution at all). If you're using MySQL 3.23.xx, just copy the raw files from one place to the other. (Taking care to flush tables and whatnot.) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Silent Install Ready
try http://www.avukatpro.com/mysql.html Regards. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Stable version
Hello. On Fri, Apr 13, 2001 at 09:15:32AM -0400, [EMAIL PROTECTED] wrote: At 04:55 2001-04-13, John Dean wrote: At 21:17 12/04/2001 -0400, Jocelyn Bernier wrote: I am currently running MySQL 3.23.35 on Windows NT 4.0 SP6. I checked the mailing list regularly and didn't see any complaint or bug report regarding version 3.23.37. In fact I would like to know what is the most stable version running on that platform ? The best place to check for new versions is the MySQL web site or you could subscribe to the announcements list I think my question wasn't clear. I know that we should usually use the last version but I also know that we shouldn't use the last version when it comes out. Hm. Not really. The recommendation is to never put a new release on a production system before you tested it appropriatly. And nothing stands against using the recommended tree (say 3.23.x) in this way. Just don't play around with the development tree, except if that is what you really want. I also know that sometime new version has bugs. I just would like to know which version is currently the most stable and bug free? The answer to this depends on your usage pattern. If you don't use feature A, you don't have to care about a bug in its code. The same with WinNT. So the general answer is: the current version is 3.23.36 and it is also the recommended one. The last recommended before that was 3.23.33. I saw many times in your mailing list that we should wait before using a new version. So what is the best thing to do in that case. Well, if you can't run it yourself in a test environment, it's the least should can do. I have a web site running mysql and I just want to be sure that I won't have any problems when I upgrade. Note : I think that version 3.23.37 seems to be pretty good because I didn't see bug report. Is that right ? Well, 3.23.37 is not released yet, so there can hardly be any bug reports. ;-) Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Identifying companies, their representives
How do you guys uniquely identify companies within your mysql databases, both foreign and domestic? Tax ID numbers? Name and State and City(US) Other? In the database I am designing the PublicMembers are identified by email/login/person/member(num), and only has financial capabilities with my company via a credit card. Also, How does everyone verify that Joe Smuckatelli is ACTUALLY the representative for Johnson and Johnson company, has the positioned claimed, has authority to allow J-n-J logo's to be placed on my site, and can commit to billed accounts, or enter private company data to be processed and displayed on my site? (J--J is a 'fictitious' name and I am certainly not dealing yet with the real McCoy) And Finally, How often do you reverify both active and inactive accounts/logins, what limits do you put on account activity before flagging that account for researching? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Identifying companies, their representatives
Tax ID numbers are a good solution for companies in the US, as they're unique. Same with Taxpayer IDs (SSN) for employees. I use both as primary keys (or at least unique keys) in databases I develop. Short of placing a phone call, there's not much way to assure a company representative. Best left to the accounting types to review your data. I generally place a 90 day "no activity" flag on things -- as in they come up for review after 90 days of no activity, but this would obviously depend completely on the application. A 90 day review would be silly in an application where someone only visits yearly for an annual renewal. Dennis Gearon [EMAIL PROTECTED] wrote: How do you guys uniquely identify companies within your mysql databases, both foreign and domestic? Tax ID numbers? Name and State and City(US) Other? In the database I am designing the PublicMembers are identified by email/login/person/member(num), and only has financial capabilities with my company via a credit card. Also, How does everyone verify that Joe Smuckatelli is ACTUALLY the representative for Johnson and Johnson company, has the positioned claimed, has authority to allow J-n-J logo's to be placed on my site, and can commit to billed accounts, or enter private company data to be processed and displayed on my site? (J--J is a 'fictitious' name and I am certainly not dealing yet with the real McCoy) And Finally, How often do you reverify both active and inactive accounts/logins, what limits do you put on account activity before flagging that account for researching? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple Querie or Long- Speed
Is a more complex single query going to run faster on a server than several smaller queries where the results are set to variables and then used as criteria in tertiary queries. Bryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Myths Debunked..
Since I'm sick of the misinformation being spread about MySQL, and a google search didn't bring up anything conclusive, here I am scratching the itch. Obviously, I'm not perfect. I'd love comments or criticism, and maybe with some help this could become a valuable resource. http://netgraft.com/~mbac/research/mysqlmyths.html -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, 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
Mysql and Perl DBI
I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-14.tar.gz. User name for connecting to database test? [undef] Password for connecting to database test? [undef] Creating files for MySQL Checking if your kit is complete... Looks good Using DBI 1.14 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI Writing Makefile for DBD::mysql Writing Makefile for Msql-Mysql-modules [gordon@fido Msql-Mysql-modules-1.2213]$ make mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/Msql-Mysql-modules mkdir blib/lib/auto mkdir blib/lib/auto/Msql-Mysql-modules mkdir blib/man1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux \ -I/usr/lib/perl5/5.6.0 -Ilib -MExtUtils::PerlPP \ -e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm" /usr/bin/pod2text mysql/lib/DBD/mysql.pm README make[1]: Entering directory `/home/gordon/Msql-Mysql-modules-1.2213/mysql' mkdir ../blib/lib/DBD mkdir ../blib/arch/auto/DBD mkdir ../blib/arch/auto/DBD/mysql mkdir ../blib/lib/auto/DBD mkdir ../blib/lib/auto/DBD/mysql mkdir ../blib/man3 cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm cp lib/Mysql.pm ../blib/lib/Mysql.pm gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/m ysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/li b/perl5/5.6.0/i386-linux -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0413\" -DXS_VERSION=\"2.0413\" -fPIC -I/usr/lib/perl5/5.6.0/i 386-linux/CORE -DDBD_MYSQL dbdimp.c /usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI/Driver.xst mysql.xsi /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 /usr/lib/perl5/5.6.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.6.0/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/m ysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/li b/perl5/5.6.0/i386-linux -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0413\" -DXS_VERSION=\"2.0413\" -fPIC -I/usr/lib/perl5/5.6.0/i 386-linux/CORE -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.96" gcc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L/usr/lib/mysql -lmysqlclient -lm -L/usr/lib/gc c-lib/i386-redhat-linux/2.96 -lgcc chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs Manifying ../blib/man3/DBD::mysql.3pm Manifying ../blib/man3/Bundle::DBD::mysql.3pm Manifying ../blib/man3/Mysql.3pm make[1]: Leaving directory `/home/gordon/Msql-Mysql-modules-1.2213/mysql' mkdir blib/script cp dbimon blib/script/dbimon /usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -MExt Utils::MakeMaker -e "MY-fixin(shift)" blib/script/dbimon Manifying blib/man1/dbimon.1 *** ERROR: unterminated C... at line 1426 in file dbimon *** ERROR: unterminated C... at line 1450 in file dbimon Can any one help Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trying to build mysql-3.23.36 on RedHat 6.2
I've having a HORRIBLE time compiling this new version of MySql. Can someone please tell me what could be wrong? I have upgraded glibc to 2.96 per recommendations on the website, with no change in results. Here is the error I get 6 -DDBUG_OFF -c my_error.c my_error.c: In function `my_error': my_error.c:104: Internal error: Segmentation fault. Please submit a full bug report. See URL:http://bugzilla.redhat.com/bugzilla/ for instructions. make[2]: *** [my_error.o] Error 1 make[2]: Leaving directory `/usr/src/mysql-3.23.36/mysys' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-3.23.36' make: *** [all-recursive-am] Error 2 [root@kahoolawe mysql-3.23.36]# make test cd mysql-test ; ./mysql-test-run /bin/sh: ./mysql-test-run: No such file or directory make: *** [test] Error 126 Troy [EMAIL PROTECTED] "I do not understand what I do, for what I want to do I do not do but what I hate I do" Rom 7:15 NIV --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.243 / Virus Database: 118 - Release Date: 03/30/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: MySQL Myths Debunked..
On Fri, Apr 13, 2001 at 06:49:51PM -0400, Michael Bacarella wrote: Since I'm sick of the misinformation being spread about MySQL, and a google search didn't bring up anything conclusive, here I am scratching the itch. It certainly can't hurt! :-) Obviously, I'm not perfect. I'd love comments or criticism, and maybe with some help this could become a valuable resource. http://netgraft.com/~mbac/research/mysqlmyths.html Good start. Here are some comments (numbered to match your list): (2) Another data point for performance. One of my machines is a FreeBSD box with 2GB of RAM and a 1GHz CPU. I had it up to about 900 queries per second before the WAN bandwidth became the bottleneck. A 2 CPU Linux box (850MHz CPUs) with 1GB of RAM was doing roughly 2.5 times as much work in the same sort of test. Oh, and did I mention that those were almost all UPDATE queries. (4) I have a server here running 3.23.29-gamma with a 100 day uptime and just under half a billion queries under its belt (right around 465 million currently). (6) I don't know that I'd deal with the stored procedures issue in a document like this. I've come to find that folks who are convinced they need them simply aren't going to change their mind (without a LOT more convincing). (7) Cool! We're listed. :-) (9) Does MySQL often get accused of being "obscure"? This is the first time I've heard of that. I think there needs to be a "MySQL Doesn't Scale" Myth debunked. I've done that internally a few times. I can help out with content on that one if you need a hand. Thanks for the great start. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
default password?
After intsalling mysql is there a default password assigned to root? I type "./mysqladmin -u root -p password 'new-password'" Well, I don't know what the old/default password is deermind for the american How do I fix it? thx, DAVE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can you convert a MS Sql database to MySQL?
Does anyone know any good source of info for the conversion of MS Sql databases to MySql? Perhaps a prog that does this? Thanks for any information in advance, AJ Workman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can you convert a MS Sql database to MySQL?
AJ, In the past, I have used ACCESS ODBC to create an Update Query to move data between Access and MySQL. My stuff was small so I did it by hand. Andy AJ xtrude@hugheTo: [EMAIL PROTECTED] s.net cc: Subject: Can you convert a MS Sql database to MySQL? 04/13/2001 11:58 PM Does anyone know any good source of info for the conversion of MS Sql databases to MySql? Perhaps a prog that does this? Thanks for any information in advance, AJ Workman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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