Quick Question - quick reply please!
Hi, Assuming that a 'table' has been defined with MAX_ROWS high enough to allow the table to be 4Gbytes, does the same size limit apply to the index as the data file, or is the index file subject to a different limit? Thanks for a speedy response Quentin Bennett Transport Systems Division Infinity Solutions www: http://www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone: +64 9 358 9720 Fax: +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: changing column order in MySQL tables?
How do you change the order of columns in MySQL tables? I assume the tables have a concept of column order, since the DESCRIBE command always lists the columsn in the order in which they were created. http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_5_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Quick Question - quick reply please!
Hi, I found a discussion about the index file not being able to be RAIDed, and know that the OS Limit will apply in any case, but this is Solaris 8, so that isn't a problem, but can't find anything that explicitly states it. Even SHOW TABLE STATUS: mysql show table status like 'tt_tickets'\G *** 1. row *** Name: tt_tickets Type: MyISAM Row_format: Dynamic Rows: 176206 Avg_row_length: 38 Data_length: 6713540 Max_data_length: 1099511627775 Index_length: 4264960 Data_free: 0 Auto_increment: NULL Create_time: 2001-10-02 11:06:03 Update_time: 2001-10-31 15:53:03 Check_time: 2001-10-02 11:08:10 Create_options: max_rows=4294967295 pack_keys=1 Comment: 1 row in set (0.03 sec) Shows Max_data_length - does the same limit apply to the index? Quentin -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: Saturday, 3 November 2001 11:47 p.m. To: Quentin Bennett Subject: RE: Quick Question - quick reply please! I seem to remember some discussion about this, and that the index *is* subject to filesystem limits i.e., it can't be split. It has been discussed rather extensively at some time in the near past; check the list archives. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 03, 2001 10:28 AM To: MySQL (E-mail) Subject: Quick Question - quick reply please! Hi, Assuming that a 'table' has been defined with MAX_ROWS high enough to allow the table to be 4Gbytes, does the same size limit apply to the index as the data file, or is the index file subject to a different limit? Thanks for a speedy response Quentin Bennett Transport Systems Division Infinity Solutions www: http://www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone: +64 9 358 9720 Fax: +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI hangs on certain commands
[EMAIL PROTECTED] writes: MySQL is working perfectly on my Linux box. I downloaded MySQLGUI, and ran it. It connects fine, I can view a table, etc.. But, when I click on the GRANT/REVOKE menu, it hangs on the Windows side. When I go to the Linux side and issue SHOW PROCESSLIST, there are as many processes connected as I have ports open. When I forcibly kill the MySQLGUI, and issue SHOW PROCESSLIST, it's back to 'normal'. The above happens as SOON as a I click the GRANT/REVOKE menu item! I can view the mysql.user table (by using the view table button), but, it dies when I go to the GRANT/REVOKE menu item. David Hi! If I understand you well, you are talking about Windows version of MySQLGUI ?? Please clear it out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: linking to a database id
I have a database of dealers. =Hmm, reminds me of a joke: how many industries do you know that refer to their customers as users and their suppliers as dealers? A web page loads a list of states, a user clicks on the state and the database is queried and lists in a table the dealers for that state. Simple enough. When the dealers page is first loaded, it shows all dealers in the database, name, address, phone, etc. I want to change that to just the dealer names linked to their state listing. I can get the page to display the dealer names okay, but when I try to get the link to work it just reloads the currant page. The url shows the correct information. I shouldn't have to designate a seperate page to show the results should I? I don't want to, I want this to be the default that loads when the page is loaded. I have this code snippet below, that when I click on the the link in the web page, the url shows the correct info for the page, but it does not load, it just reloads the same current page. =nothing has sprung off the page and caught my eye (yes well...), but two things: =1. recommend that you put in an echo/printr immediately before the mysql_query() call, to check the $query contents - and the outcome of the logic in the preceding lots of elseif statements trimmed =2. that statement lots of elseif statements trimmed throws up a yellow flag, because the more intertwined/nested ifs, if-thens, and if-then-elses there are, the more there is space for confusion. Assuming that $orderby is in fact a code for 'state' (as in location) and that the trimmed statements are similar why not do away with the many choices and settle for: $query = select * from dealers where ID = $orderby order by 'DealerName' asc; =Does the debug output match up with the URL? =dn Thanks for the help... -- Chip --- lots of elseif statements trimmed -- elseif ($orderby == '46'): $query = select * from dealers where ID = '46' order by 'DealerName' asc; else: $query = select * from dealers; endif; $result = mysql_query($query); $i = 0; while ( $row = mysql_fetch_array($result)) { if ($result): { printf(tda href=\http://www.mapquest.com/cgi-bin/ia_free?width=500height=600level=8streetaddress=%scity=%sstate=%s\; target=\_new\%s/a \n, $row[Address1], $row[City], $row[State], $row[DealerName]); printf(br%s\n, $row[Address1]); printf(br%s\n, $row[Address2]); printf(br%s, %s %s\n, $row[City], $row[State], $row[Zipcode]); printf(brPhone: %s\n, $row[Phone]); printf(brFAX: %s\n, $row[FAX]); printf(br\na href=\mailto:%s\;%s/a\n, $row[Email], $row[Email]); print(/td\n); if ($i % 2) { echo /tr\ntr\n; } $i++; } else: printf(td.$row[ID]. a href='dealerDB2.php?ID=$row[ID]'%s/a, $row[DealerName]); print(/td); if ($i % 2) { echo /tr\ntr\n; } $i++; endif; } ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 question
I don't know how to remove users other than directly removing them from mysql.user table This may be very obvious but being a new mysql admin user how do I do what you say above, to delete the user from the user table. There doesn't appear to be any examples of this in the docs. =Isn't that curious - instructions to add new users, but not to remove - the Hotel California philosophy? =In addition to the obvious 7.35 GRANT and REVOKE Syntax, the manual offers chapter 6 The MySQL Access Privilege System - in particular 6.14 Adding New Users to MySQL which offers examples/compares GRANT with direct manipulation of the authority tables. Once understood, REVOKE-ing a user becomes straightforward (pity we don't have referential integrity to cope with all those tables though!) =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help !!
Enquiries writes: Does anyone know of any EASY instructions on how to you MYSQL? The manual, the FAQ, and the book by Paul DuBois. I haven't read the book myself tho. I've forgotten the password to mysql and cannot understand how you actually reset it? I've read the documentation but does not make any sense. The manual is crystal clear on how to do it. Have you read the entire chapter 4 and appendix A.4? And please correct your date. It's off by a couple of days. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to MS' Access '97
Does anyone know how to download a table from MySQL (at a server)to MS' Access '97 (at a client)? Thanks! Anthony F. Rodriguez ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL to MS' Access '97
I have done Access to mySQL, but not the other way around... I guess you would need to export the table to a CSV file then import it into Access. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 03, 2001 7:51 AM To: [EMAIL PROTECTED] Subject: MySQL to MS' Access '97 Does anyone know how to download a table from MySQL (at a server)to MS' Access '97 (at a client)? Thanks! Anthony F. Rodriguez ([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: MySQL to MS' Access '97
You can use phpadmin to control the database and there is an option to view dump into a CSV file either in MS Excel format or standard CSV file. Once you dumped it, you can then import it into Access Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 03, 2001 7:51 AM To: [EMAIL PROTECTED] Subject: MySQL to MS' Access '97 Does anyone know how to download a table from MySQL (at a server)to MS' Access '97 (at a client)? Thanks! Anthony F. Rodriguez ([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
time grouping in mysql
I haven't succeeded in being able to group by time. My timestamp field is -mm-dd hh:mm:ss. What I would like is have a query that will enable me to be to group on events say every 5 minutes. I've played around with using time_to_sec(timestamp) to convert all the times to seconds and then group by the timestamp to return only distinct seconds (timestamp). the timestamp field is multivalued. Any thoughts Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
REGEXP problem
I want to enable a user-friendly search for authors in a books database. When an author's name is spelled in several ways (T.S. Eliot; Eliot, T S; Eliot, Thomas Stearns, etc.) the user input using these different spellings should find all entries from this author. I thought I could get this done by isolating last name and initials and building the query (somewhat simplified) as ...where author like '%$lastname%' and author REGEXP '[[::]]$Initial[0][-/A-Za-z\(\)\. ]*[[::]]$Initial[1]' This, however, also finds authors like 'Thompson, Eliot and Simpson, Ken'. To narrow down the search I am now trying to find a way to instruct Mysql to find both initials in the required order in two consecutive words only, so only in 'T.S.' or 'Thomas Stearns' or minor variants. I cannot discover in the Mysql manual, nor in Dubois, nor in Friedl's regex book, how to do this. [[::]] doesn's have a negation, which would come in handy here. Are there any regex wizards who could help? Are there other ways to accomplish what I want? Thanks in advance, Piet Wesselman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to MS' Access '97
Use MYODBC (see http://mysql.com ) to connect to the mysql database Within Access database use 'link to external data' for mysql and use an INSERT query to get the data into the Access table HTH Peter -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: 03 November 2001 14:05 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MySQL to MS' Access '97 You can use phpadmin to control the database and there is an option to view dump into a CSV file either in MS Excel format or standard CSV file. Once you dumped it, you can then import it into Access Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 03, 2001 7:51 AM To: [EMAIL PROTECTED] Subject: MySQL to MS' Access '97 Does anyone know how to download a table from MySQL (at a server)to MS' Access '97 (at a client)? Thanks! Anthony F. Rodriguez ([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
copying row
is there any API in mySQL for copying rows in the same table.. or any function of that sort. Later, Mags __ Do You Yahoo!? Find a job, post your resume. http://careers.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
MySql as an Embedded Java Database
We are developing an application for commercial distribution using a Java client, JDBC, and an SQL database . It will come in 2 versions - a standalone single-user version that will run on a PC and multi-user version where the database will run on a separate server. For the standalone version we started using an embedded Java database. A number of issues are now causing me to look at MySql for both versions. For MySql to work, we need to --- 1. Install MySql silently along with the Java application - basically a one-click install. 2. Be able to start and shutdown MySql server when the application is started and shut-down. 3. No database maintenance - or able to automate whatever maintenance there is - preferably using a Java interface. Can MySql do the job? And if so, can someone point me in the right direction? For example, embedded MySql appears to require a C interface - could it also be made to work with JDBC? What is required for a silent install? Thanks for your insights. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 as an Embedded Java Database
Al Giacomucci writes: We are developing an application for commercial distribution using a Java client, JDBC, and an SQL database . It will come in 2 versions - a standalone single-user version that will run on a PC and multi-user version where the database will run on a separate server. For the standalone version we started using an embedded Java database. A number of issues are now causing me to look at MySql for both versions. For MySql to work, we need to --- 1. Install MySql silently along with the Java application - basically a one-click install. 2. Be able to start and shutdown MySql server when the application is started and shut-down. 3. No database maintenance - or able to automate whatever maintenance there is - preferably using a Java interface. Can MySql do the job? And if so, can someone point me in the right direction? For example, embedded MySql appears to require a C interface - could it also be made to work with JDBC? What is required for a silent install? Thanks for your insights. Hi! All that you ask for is, of course, possible. Only it would ask for some additional installation scripts, which will depend a lot on the OS to which it will install. If you will be selling your product, you will also require MySQL licence. Regarding embedded server, it works with C , but it could be made linkable in java application, with some additonal work. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Max database recovery crashed - Fixed!
Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: I will have to include a warning in the comments section of the MySQL documentation to NOT CONVERT MySQL SYSTEM TABLES FROM myISAM TO INNODB TYPE! I have now added a warning about this to the manual. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Apple article on Mac OS X and MySQL/Postgres
Apple has posted an article on using MySQL and Postgres under Mac OS X: http://developer.apple.com/internet/macosx/osdb.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
Copying DB to DB
Hi. I have already written a php / mysql search engine, so i have a vague idea of what i'm doing. But i do have a query no seems to be able to answer. Is it possable to copy a row from one table, to another table? Both tables have the same field names, and settings. And i can easily insert data manually. But i was wondering if i could simply copy the data from DB to DB 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: MySQLGUI hangs on certain commands
Yes.. It is the windows version of MySQLGUI that I am using. Windows 2000 SP2 David - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, November 03, 2001 4:14 AM Subject: Re: MySQLGUI hangs on certain commands [EMAIL PROTECTED] writes: MySQL is working perfectly on my Linux box. I downloaded MySQLGUI, and ran it. It connects fine, I can view a table, etc.. But, when I click on the GRANT/REVOKE menu, it hangs on the Windows side. When I go to the Linux side and issue SHOW PROCESSLIST, there are as many processes connected as I have ports open. When I forcibly kill the MySQLGUI, and issue SHOW PROCESSLIST, it's back to 'normal'. The above happens as SOON as a I click the GRANT/REVOKE menu item! I can view the mysql.user table (by using the view table button), but, it dies when I go to the GRANT/REVOKE menu item. David Hi! If I understand you well, you are talking about Windows version of MySQLGUI ?? Please clear it out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
There's a FAQ?
The FAQ clearly states There's a FAQ? I don't see one mentioned at http://www.mysql.com/documentation/index.html , except for the dynamic FAQ. I just tried this dynamic FAQ with Topic Language Reference, keyword join. That produces 0 results. The welcome message for this list says Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] I just tried getting a FAQ that way and got back an email saying None available yet. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI hangs on certain commands
David Wolf writes: Yes.. It is the windows version of MySQLGUI that I am using. Windows 2000 SP2 David Thanks, I will check it out ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
Join syntaxes not all defined
The manual's description of Join Syntax lists the various kinds of syntax but doesn't define some of them, e.g.: table_reference, table_reference and table_reference INNER JOIN table_reference join_condition I'm guessing these two are equivalent, except that you can't use a join_condition with the first form. Could someone please confirm? Thanks, Uriel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Join syntaxes not all defined
The manual's description of Join Syntax lists the various kinds of syntax but doesn't define some of them, e.g.: table_reference, table_reference and table_reference INNER JOIN table_reference join_condition Yes, it does. I'm guessing these two are equivalent, except that you can't use a join_condition with the first form. Could someone please confirm? section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MySQL be run from a CD-ROM?
I went to the link provided to the list archive just to see if I could find anything. I couldn't find anything with CD, CD ROM, CD-ROM, running mySQL for a CD and various permutations and combinations thereof. Also did a Google search for this and came up blanked. So, this is not as readily available as it might seem. Now what I did to get MySQL 3.23.41 to run off of a CD with Win32 was this. Downloaded put the install zip file on CD. Installed mySQL on my machine. Installed mySQL ODBC driver. Ran WinMySQLadmin to make sure that the my.ini file was correct and closed the application. Copied my.ini to a safe place, edited original so that the application related paths pointed to the new location on the CD. If you want to change/update your data, you might want to leave the data paths pointing to a folder on your hard drive. Burnt a CD from the mySQL subdirectory + the my.ini file. Uninstalled mySQL from the hard drive Rebooted. Logged onto e:\mysql\bin and ran mysql from there. Finish using mySQL log off. Remove CD. Works for me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jeremy Zawodny Sent: Wednesday, October 31, 2001 10:30 PM To: Carter, Robert L (MN65) Cc: '[EMAIL PROTECTED]' Subject: Re: Can MySQL be run from a CD-ROM? On Mon, Oct 29, 2001 at 09:49:08AM -0600, Carter, Robert L (MN65) wrote: Alternatively, is it possible to set up MySQL to be runnable from a CD-ROM, but using a hard-wired hard drive location in which to find the database tables? Yes. This was discussed here about a week ago, so it should be easy to find in the archives. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 56 days, processed 1,245,102,049 queries (257/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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT, UPDATE and Groundhogs
At 10:05 AM -0700 10/26/01, Jonathan M. Morgan wrote: I am working my way through Paul DuBois' excellent book MySQL and Perl for the Web. One of the examples shows how to conduct a poll- vote for your favorite groundhog: http://www.kitebird.com/cgi-perl/groundhog.pl Paul then suggests modifying the poll ...to log EACH vote and when it occurred so that you can perform time-based analysis of poll activity. How does one tally the vote (UPDATE) and insert a new record for each vote? The original MySQL table is as follows: CREATE TABLE ( name CHAR(10) NOT NULL, tally INT UNSIGNED NOT NULL DEFAULT 0 ) The vote tally is updated like this: $dbh-do (UPDATE groundhog SET tally = tally + 1 WHERE name = ?, undef, $name); I updated the table to include an auto incremented vote_id(PRIMARY KEY) as well as a timestamp. But how do you log each vote and tally the vote? Thanks! JMM The original table maintains the current count using a single record per name, so that doesn't work if you want to maintain a log of each vote. To log each vote, you could use a table that has a TIMESTAMP (or DATETIME) column and a string column to hold the name. Then you don't need a column to count the number of votes, because that is implicit as the number of rows per name. CREATE TABLE groundhog_log ( t TIMESTAMP NOT NULL, name CHAR(10) NOT NULL INDEX (name) ) Each time you get a vote for a name $name, you add a record to the table like this: $dbh-do (INSERT INTO groundhog_log SET name = ?, undef, $name); That'll set the t column to the current date and time automatically. To summarize votes, issue this query: SELECT COUNT(*), name FROM groundhog_log GROUP BY name; Another approach would be to use both the original and the log table. Update the tally in the original table and add a new log record each time you get a vote. That way, when you want to produce the vote tallies, you need only query the original table, not summarize the log table. That might be preferable if the summary query got slow as the log table becomes large. Glad you like the book, by the way. :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Addendum: DBI Handle Has No Magic
I forgot to mention one very important thing: this error cropped up after I edited /usr/local/libdata/perl5/site_perl/i386-openbsd/DBI.pm to use DBI version 1.20 instead of 1.15 (apparently, this file was not updated after I uninstalled 1.15 and installed 1.20, because I got errors complaining about the wrong version when I first tried this). Is there any way I can just delete everything associated with DBI and start fresh? I really need to get Perl to interface with MySQL. Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't access MySQL via PHP
Hi all, I have a MySQL database 'mydb' and I can perfectly access it via telnet. I have one database and I have full access to it. I can't create user and other databases, but its fine. Problem is that I write a PHP script and I can't access my sql database using that script! I got 'Access Denied' Error. I've tried MySQL grant commands e.g. Grant ALL PRIVILEGES ON mydb.* TO imran@%; (replaced % with my hostname etc. too) command is executed properly. Here is the PHP script: include(passwords.php); $openConn2db = mysql_connect( $hostname:$port, $username,$password ); $dbSelected = mysql_select_db( $dbname, $openConn2db ); $result = mysql_db_query ($dbname,select * from Girls); while ($row = mysql_fetch_array ($result)) { $sFace = $row[face]; print(trtdfont face='Arial' size='1'$sFace/font/td/tr); } How can I configure mysql so I can access it with my web applications too, not just telnet? And anyone knows how to make mysql accessible via GUI clients like mascon or myadmin etc. Some of my MySQL databases got accessible by them and some just telnet? depending on different provides? Merci a bunch! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't access MySQL via PHP
Hi should be mysql_connect(fred.com, fredsusername, fredspassword) or mysql_connect($host, $username, $password) Only needs quotes if you are using actual values HTH Peter -Original Message- From: Imran Aziz [mailto:[EMAIL PROTECTED]] Sent: 03 November 2000 19:49 To: [EMAIL PROTECTED] Subject: Can't access MySQL via PHP Hi all, I have a MySQL database 'mydb' and I can perfectly access it via telnet. I have one database and I have full access to it. I can't create user and other databases, but its fine. Problem is that I write a PHP script and I can't access my sql database using that script! I got 'Access Denied' Error. I've tried MySQL grant commands e.g. Grant ALL PRIVILEGES ON mydb.* TO imran@%; (replaced % with my hostname etc. too) command is executed properly. Here is the PHP script: include(passwords.php); $openConn2db = mysql_connect( $hostname:$port, $username,$password ); $dbSelected = mysql_select_db( $dbname, $openConn2db ); $result = mysql_db_query ($dbname,select * from Girls); while ($row = mysql_fetch_array ($result)) { $sFace = $row[face]; print(trtdfont face='Arial' size='1'$sFace/font/td/tr); } How can I configure mysql so I can access it with my web applications too, not just telnet? And anyone knows how to make mysql accessible via GUI clients like mascon or myadmin etc. Some of my MySQL databases got accessible by them and some just telnet? depending on different provides? Merci a bunch! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: changing column order in MySQL tables?
At 04:26 PM 11/2/2001 -0600, Paul DuBois wrote: At 2:12 PM -0800 11/2/01, Bennett Haselton wrote: How do you change the order of columns in MySQL tables? I assume the tables have a concept of column order, since the DESCRIBE command always lists the columsn in the order in which they were created. I figured that the place to look would be the syntax page for the ALTER TABLE statement: http://www.mysql.com/doc/A/L/ALTER_TABLE.html but there's nothing there about how to change the order of columns. You can specify the position with a FIRST or AFTER col_name clause when you add a column, but not (as far as I know) change the position of an existing column. Do you have some weird application requirement that makes this necessary? You can always name the columns in the order you want them to come out, when you issue a SELECT query. I know it's bad practice for an application to depend on the order of columns within a table; I'm avoiding that. The only reason I cared about order was because, in the Web-based interface that I'm writing for my own use, one of the functions is to dump the contents of a MySQL table into a viewable HTML table. When viewing that output, it's helpful if the columns are organized into some meaningful order. -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: time grouping in mysql
At 9:02 AM -0500 11/3/01, Greg Sarsons wrote: I haven't succeeded in being able to group by time. My timestamp field is -mm-dd hh:mm:ss. What I would like is have a query that will enable me to be to group on events say every 5 minutes. I've played around with using time_to_sec(timestamp) to convert all the times to seconds and then group by the timestamp to return only distinct seconds (timestamp). the timestamp field is multivalued. Convert to seconds as you're doing, then divide the result by 300 (5 minutes in seconds) to slot them into 5-minute bins. You'll probably want TRUNCATE(seconds_val/300,0) to produce integer division. Otherwise, you'll get a bunch of floating point values that don't group as you want. Any thoughts Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: copying row
At 6:07 AM -0800 11/3/01, Mags wrote: is there any API in mySQL for copying rows in the same table.. or any function of that sort. What does copying rows in the same table mean? Copying them to where? Later, Mags - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
where is setup.exe
Good day, Your installation instructions read as follows: If you don't have a copy of the MySQL distribution, you should first download one from `http://www.mysql.com/downloads/mysql-3.23.html'. To install either distribution, unzip it in some empty directory and run the `Setup.exe' program. Unfortunately I didnt find a file with name setup.exe within the downloaded file mysql-3.23.43.tar.gz. Could you help me further? Many thanx Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: where is setup.exe
At 9:42 PM +0100 11/3/01, paul wrote: Good day, Your installation instructions read as follows: If you don't have a copy of the MySQL distribution, you should first download one from `http://www.mysql.com/downloads/mysql-3.23.html'. To install either distribution, unzip it in some empty directory and run the `Setup.exe' program. Unfortunately I didnt find a file with name setup.exe within the downloaded file mysql-3.23.43.tar.gz. You didn't download the Windows distribution. Could you help me further? Many thanx Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
localhost.err Fille
I was poking around my Error Files today and I came across this error in the localhost.err file: 011101 13:00:33 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = /mysql/data/ibdata1:20M More information on setting the parameters you find in the manual. /usr/local/mysql-3.23.43/bin/mysqld: ready for connections It was my understanding that I was using InnoDB. Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: a bug or intentional? -- problem with multiple table query
Thanks! I altered my statements to use left joins and now it all looks like it's working! On Thursday 01 November 2001 09:51 pm, Quentin Bennett wrote: Hi, You need to read up on Left Joins, which will insert a 'NULL' row in the results for B where there isn't a real one. Regards Quentin -Original Message- From: Q [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 4:40 p.m. To: [EMAIL PROTECTED] Subject: a bug or intentional? -- problem with multiple table query I am having a problem with a query and I don't know if it is a bug or intentional. Anyway any input is greatly appreciated. Here is a basic query that is simpler than what I am dealing with but should demonstrate my problem. Lets say: SELECT A.1, A.2 FROM A yeilds: test1 test2 then: SELECT A.1, A.2 FROM A, B yeilds nothing, unless B has something in it. my problem is that b does not always have something in it. I need to have B in the FROM list because I use it in the WHERE statement. I am curious if this is intentional, but mainly I would like to know if there is a way around it other than putting a dummy entry in the tables. If anyone cares here is the real query: SELECT DISTINCT services.serviceid, services.name from admin_permissions, pop_permissions, admin_pops, services WHERE (concat('service_',services.serviceid)=admin_permissions.object AND (admin_permissions.can_change=1 OR admin_permissions.can_grant=1) AND admin_permissions.userid=1) OR (concat('service_',services.serviceid)= pop_permissions.object AND (pop_permissions.can_change=1 OR pop_permissions.can_grant=1) AND pop_permissions.popid=admin_pops.popid AND admin_pops.userid=1) ORDER BY services.name - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query results cached, or other explanation?
I've observed that if I run a simple SELECT * command on a two-row table, the query takes anywhere from half a second to four seconds: mysql select * from pet; +--+-+-+--++---++ | name | owner | species | sex | birth | death | ID | +--+-+-+--++---++ | snort| bennett | mammal | m| 1986-12-08 | NULL | 1 | | fluttersnort | bennett | mammal | m| NULL | NULL | 2 | +--+-+-+--++---++ 2 rows in set (3.95 sec) but if I enter the same command several times in succession, the time taken is always 0.00 sec. In fact, it looks like if I re-enter the query less than 15 seconds after the last time it was entered, it takes 0.00 sec to rerun it. (After the 15-second cutoff, the query times start going back up again.) What causes this? Does MySQL do any caching of query results? The first alternative explanation that came to mind was that if you re-enter a recent query, then the disk files storing the data will still be cached in memory. This is supported by the observation that if you have recently run the query select * from pet; then the query select * from pet where name=snort; is also very fast -- i.e. the data itself is being cached (either by MySQL or by the file system), not the query results. However, if that's the cache, shouldn't the data still be cached, say, 60 seconds later? I don't think the machine is busy enough that data would be pushed out of virtual memory less than 60 seconds after the last time it was placed there, although I don't know anything about virtual memory on Linux. -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Win32 mysqld-opt: Invalid page fault on certain query
At 19:10 02/11/2001 -0500, Ken wrote: Hi Ken, Unlucky with your report I can't able to begin any test for fix this behavior. Try to make notes about every step until reach the crash, then send me the notes and the structure of the tables. Regards, Miguel I'm running MySQL 3.23.41 on Win95 (just upgraded from an earlier 3.23 beta, in case that would solve the problem). I have a moderately complex query that causes the MySQL server to crash when I execute it. (invalid page fault in module MYSQLD-OPT.EXE) The same query works fine on a Redhat version of MySQL I have access to. It's definitely not a syntax error (not that a syntax error should crash the database server). It even gives me the correct results. If I systematically remove a piece at a time from the SELECT portion, I can eventually come up with a working query. But I can't narrow it down to one part in particular. Certain combinations work, and certain ones lead to this consistent crash. I just haven't identified a pattern. I tried dropping the database, then rebuilding it from a txt dump I made from my production version of the database (the Redhat one). Didn't help. The same query causes the same crash in Win95. I'm stumped. Does anyone know of a known issue with Win32 MySQL that would cause this? Is there some way I can re-order my query to avoid this problem? I'm paralyzed, now not being able to run my application in my development environment. Thanks immensely to anyone who can help! - Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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: Join syntaxes not all defined
section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... Carsten H. Pedersen ?? Since this does not appear in the manual for v. 3.23.42, which I'd been using, I just downloaded the current one from http://www.mysql.com/documentation/index.html . For some reason, the manual I got is for version 4.0.0-alpha. Can someone explain why that webpage doesn't offer the manual for the lastest stable release? Still more puzzling is that the above excerpt about INNER JOIN does not appear in this alpha version manual either. Where does it come from? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Join syntaxes not all defined
section 6.4.1.1: ... INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. ... Carsten H. Pedersen ?? Since this does not appear in the manual for v. 3.23.42, which I'd been using, I just downloaded the current one from http://www.mysql.com/documentation/index.html . For some reason, the manual I got is for version 4.0.0-alpha. Can someone explain why that webpage doesn't offer the manual for the lastest stable release? Still more puzzling is that the above excerpt about INNER JOIN does not appear in this alpha version manual either. Where does it come from? The manual for v. 3.23.41. You're right: It seems to have been left out in the current version. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
performance of joins
hello! im storing pretty big amounts of customer data in a mysql databases. its about 2 million rows. what im wondering about now is, how does mysql perform joins on such amounts of data? i was planning to split the info in at least 3 tables: a general customer table, a address table, and a contact table. since also other needs than just customers, for storing addresses and contacts. would it perform better though to store all that in one single table or is is it okay to split it up in 3 and join them later then, depening on what information is needed? thanks alot. florian -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 UNION and UNION ALL on a database running 4.0
Hi all, I have looked throught the manual and found that I could use a UNION syntax to join a bunch of tables into 1 query. How the heck can I do this with 15 tables, order the records by date_created desc and have there be WHERE title LIKE 'something'. I have those other parts (order, etc) just need the union syntax. here is my current non-working query: SELECT * FROM tbl1 UNION ALL WHERE title LIKE 'something' ORDER BY date_created DESC Basicly, I want every single record in the database. Thanx ppl! And by the way, the MySQL Manual is NO HELP AT ALL. too confusing and doesn't even explain it fully. - Deryck Henson - http://www.sourcecodecafe.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: Using UNION and UNION ALL on a database running 4.0
Hi, Try : SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2 UNION SELECT * FROM tbl3 cut UNION SELECT * FROM tbl15 WHERE title LIKE 'something' ORDER BY date_created DESC Regards, Jocelyn Fournier Presence-PC - Original Message - From: Deryck Henson [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Sunday, November 04, 2001 2:26 AM Subject: Using UNION and UNION ALL on a database running 4.0 Hi all, I have looked throught the manual and found that I could use a UNION syntax to join a bunch of tables into 1 query. How the heck can I do this with 15 tables, order the records by date_created desc and have there be WHERE title LIKE 'something'. I have those other parts (order, etc) just need the union syntax. here is my current non-working query: SELECT * FROM tbl1 UNION ALL WHERE title LIKE 'something' ORDER BY date_created DESC Basicly, I want every single record in the database. Thanx ppl! And by the way, the MySQL Manual is NO HELP AT ALL. too confusing and doesn't even explain it fully. - Deryck Henson - http://www.sourcecodecafe.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
Where REGEX documentation?
Under Description of MySQL regular expression syntax, the manual says: This is a simplistic reference that skips the details. To get more exact information, see Henry Spencer's regex(7) manual page that is included in the source distribution. Since the source is 11 MB and I have no other need for it, I wonder if there's another source for this documentation. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 of joins
Well, you usualy split your data in tables for a reason, because some data in mulitple numbers are associated to one, or multiple data. In your case, if you have one address and contact per customers, then make it one table. If you have an unknown numer of contacts and numbers per customer, then make multiple tables. The joins will be on the primary keys (they should be at least). so it should be fast, even with 2 million records. On Saturday 03 November 2001 07:06 pm, florian wrote: hello! im storing pretty big amounts of customer data in a mysql databases. its about 2 million rows. what im wondering about now is, how does mysql perform joins on such amounts of data? i was planning to split the info in at least 3 tables: a general customer table, a address table, and a contact table. since also other needs than just customers, for storing addresses and contacts. would it perform better though to store all that in one single table or is is it okay to split it up in 3 and join them later then, depening on what information is needed? thanks alot. florian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and cgi
On Saturday 03 November 2001 04:26, paco anubis wrote: Hello, I started learning Perl 4 weeks ago and mysql 3 days ago so I know that I am in over my head, but here goes nothing. I am trying to build a Perl CGI application (using DBI) to pass form contents from a web page directly into a MySql database. I don't know how to pass the Perl variable from the form into the database. I tried to assign the value using the following code (where $feilds{user} is the Perl variable to pass): $userdb=$dbh-($feilds{user}); $rows=$dbh-do (INSERT INTO bandbook (user, ect, ect...) VALUES ($userdb, 'ect', 'ect', ...)) || die fucked up inserting data: $DBI::errstr; print $rows row succesfully added to bandbook\n; As you may have guessed the table, bandbook is still empty because the script always dies. Can anyone point me in a better direction. Due to my unfamiliarity with either language, I am definately not ruling out a syntax error. It's good practice to assign your SQL query to a variable which you can then print out for debugging purposes. It also allows you to copy and paste that query into mysql directly and see what results it yields. I think your problem is that you haven't quoted the VALUES that you're inserting. Try: $QRY = INSERT INTO bandbook (user, ect1, ect2...) VALUES ('$userdb', '$ect1', '$ect2', ...); print($QRY); ## For debugging $rows=$dbh-do($QRY) || die Error; hth -- Jason Wong Gremlins Associates www.gremlins.com.hk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please help me restore my table
mysql,hello£¡ There are three table(a,b,c) in my database,Today, I want to delete some records from b; but I regreted very much my having send wrong command :delete from a where id3 I make a mistake, I deleted the records from a table which I shouldn't delete from! Can I restore the records? What can i do ? it is very important for me to restore them! Please help me out! thank you very much! sincerely lvchunli ÂÀ´ºÀû [EMAIL PROTECTED] 2001-11-04 15:23: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