Re: Re: Searchable archives of this list
- Original Message - From: Kim Hendrikse [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 03, 2002 7:04 PM Subject: Searchable archives of this list Hi, For those of you who are not aware of it, we run a searchable archive of this list at the following location: Personally I find your automenus (under IE) most annoying and I for one won't be using the service. T. mysql table row - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi
- Original Message - From: cherian [EMAIL PROTECTED] To: MySql [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 1:12 PM Subject: Hi Hi, I have an application that has got Oracle as the central databse, if all the client machines are online then it will update the central oracle databse otherwise in the offline mode the client machine will update the local MS Access databse, and later on when ever the network comes back the central databse is updated with the changes. I want now to change the MS Access with MySql in the client machine, is it possible to do so ? Of course it's possible but you don't give many clues about what info you're after? What are your timescales, what's the budget, what are the clients written in, what is the central db update process written in, any ODBC... and a hundred other questions. Just what are you asking here? Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Showing results of a search
- Original Message - From: Daniel Ferreira Castro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 01, 2002 1:22 PM Subject: Showing results of a search I am programming the scripts of the Intranet of my Office, and I am using PHP and MySql. I would like that when I execute a search the results would be show on pages with 20 results per page. Is that possible??? Thank you Daniel F. Castro This is a good site explaining just what you are after... http://www.webmasterbase.com/article.php?pid=0aid=662 Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: seeking partner
And YOU are part of the problem - every spam is backed up by one of your complaints, doubling the traffic. If it really bothers you that much then set up a filter rule (killfile) for the persistent spammers, or risk being killfiled yourself - you have become a spammer. Can't you take your petitions to the list admins privately? T. . - Original Message - From: Marjolein Katsma [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, January 28, 2002 11:47 AM Subject: Re: seeking partner Of course, the SAME spam we saw before appears again. No surprise. Does anyone still believe this will go away by itself? It won't - it will only get worse - unless the list administrators actually *do* something about it! The filters DO NOT WORK. At 17:05 2002-01-28, you wrote: TF Information Exchange (TF) Physical Address : Room 210, Building 2, Chegongzhuang Street No. 6, Xicheng District, Beijing, China Post Code: 100044 Tel: +86-10-6800-3112 Fax: +86-10-6800-1452 Web site: http://www.tangfeng.org E-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Grrr: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] Re: Understanding throughput with JDBC
Rownum exists of a sort with the limit clause. Rowid does not exist all at. Tony - Original Message - From: Emmanuel van der Meulen [EMAIL PROTECTED] To: MySQL Java List [EMAIL PROTECTED]; MySQL General List [EMAIL PROTECTED]; Nick [EMAIL PROTECTED] Sent: Sunday, January 20, 2002 12:46 PM Subject: RE: [OT] Re: Understanding throughput with JDBC Hello Nick, Does ROWNUM exist in MySQL? Kind reagrds Emmanuel -Original Message- From: Nick [mailto:[EMAIL PROTECTED]] Sent: 19 January 2002 20:41 To: Shankar Unni Cc: [EMAIL PROTECTED] Subject: [OT] Re: Understanding throughput with JDBC With Oracle, the *only* solution is to issue a query for the whole resultset and scroll through it - it doesn't support anything *like* the LIMIT concept, though I suppose you *could* imitate it with WHERE ROWNUM blah. With Oracle, you can retrieve a part of a result set by using inline views: SQL select d.c1,d.c2,d.c3 2 from (select c1,c2,c3,rownum c4 from foo order by c3) d 3 where d.c4 =15 and d.c4 = 19 4 / C1 C2 C3 115 30 15 116 32 16 117 34 17 118 36 18 119 38 19 Not as elegant as I would like, but it works. -- Nick Email: [EMAIL PROTECTED] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Porting from MS SQL to MySQL
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 2:14 PM Subject: Re: Porting from MS SQL to MySQL Jeremy Zawodny wrote: On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote: Hello all! We've requested a database from different companies, and specifically said we wanted MySQL or PostgreSQL because of the open source angle and we're a library. One company offered MS SQL as the platform and said that they can later on port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? That's a bit strange. If the app is built with MySQL in mind, porting it should be very, very easy. But if they're going to build the app with MySQL in mind anyway, it doesn't make much sense to do so on a platform other than MySQL, does it? 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 15 days, processed 362,696,624 queries (268/sec. avg) I agree. If they are a seriuos company they should build it after the customers wishes i.e if you want mysql the company should build it with mysql. For 18,000 euro i could build the system myself:) My two cents /PM\ What about the customer who asks a car company to make the vehicle's tryes out of velvet? Would you go off in a huff if they refused and demand they do it? There are obviously issues here that we are not privy to; there *must* be logic behind the choice of SQLServer. Are they saying that mySQL isn't upto it? Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. If you think E18k is a lot then ask for a detailed task plan with effort; find out what they are asking you to pay for. The DB was described as 'fairly complicated' whatever that may mean. Perhaps - and we are all guesing - there are remote data issues, views, stored procs, java and god knows what else that all needs to be integrated. Bottom line when you get a quote is find out what they want to do task by task and then cut it down from there. Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Porting from MS SQL to MySQL
- Original Message - From: [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 18, 2002 3:34 PM Subject: Re: Porting from MS SQL to MySQL SNIPSNIP:) I agree. If they are a seriuos company they should build it after the customers wishes i.e if you want mysql the company should build it with mysql. For 18,000 euro i could build the system myself:) My two cents /PM\ What about the customer who asks a car company to make the vehicle's tryes out of velvet? Would you go off in a huff if they refused and demand they do it? There are obviously issues here that we are not privy to; there *must* be logic behind the choice of SQLServer. Are they saying that mySQL isn't upto it? Ah but if i say i want a mysql server and costs for it they shouldnt say we can do it in mssql I think they should give me an estimate on the costs for what i want then i can discuss how to get the cost down Unless they are saying they doubt that mySQL is upto, it so it's no good quoting. They may have a room full of SQLServer people twiddling their thumbs in which case I agree with you, they are not bucking for the customer here. On the other hand they have very real doubts that mySQL is upto the job; they may be wrong on this last point, but at least they are being honest in their beliefs. Who knows! Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. If you think E18k is a lot then ask for a detailed task plan with effort; find out what they are asking you to pay for. The DB was described as 'fairly complicated' whatever that may mean. Perhaps - and we are all guesing - there are remote data issues, views, stored procs, java and god knows what else that all needs to be integrated. Mysql has always filled my need (wich is with perl,java,php) Granted it would be better to know exactly what fairly complicated is Bottom line when you get a quote is find out what they want to do task by task and then cut it down from there. I have to agree with this but i dont think you should pay for getting a workdescription from them (ofcourse i dont know much about administrating papperwork i am a technichian) 100% agree. Planning, including bidding for a job, is an overhead. There should be no charge for this. IBM would disagree with us however :-) Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Porting from MS SQL to MySQL
- Original Message - From: j.urban [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 18, 2002 4:07 PM Subject: Re: Porting from MS SQL to MySQL Porting a DB takes more 'than a couple of hours'. What about the written procedures, the security mappings, the back up and recovery procs, the fallback arrangements, the testing etc. Yes, porting a database that was written for MSSQL with no intention of porting can be a painful proposition. However, if you have control over how the system is developed, you can easily design the system to be compatible with EITHER MSSQL or MySQL (the differeces are well-documented). If you develop your system with porting in mind (ie the original post of they'll develop in SQLServer and port it to MySQL later) porting should not take more than a couple of hours. You simply choose appropriate datatypes and don't use MSSQL-specific extensions... I still don't agree with this. Yes you can ease the passage by considering all the issues up front but it is still not a trivial job for a database of any consequence. There is more to a database than a physical schema - what about all the administration procedures that sit around it, what about tuning the new physical implementation, what about reviewing the access paths and optimisation, what about the redevelopment of data loading scripts. As I have said in another post, it's futile arguing about it because we don't know enough about the technical situation let the business/political one. Are you seriously saying you could sit down in front a reasonably sized DB you had never seen before and understand all the business issues and pick it up and ship to a new RDBMS and platform, rewrite the document, replan what I have stated above, and get it back up and running in two hours? Perhaps I am getting too old and slow but it would take me longer :-) I am not saying it's a huge task to do any of this but whoever said, I could do it in a couple of hours, doesn't understand the background that led to a company quoting E18k; nor do any of us, and for anything other than a very very trivial system, two hours seems inadequate. This is an area that interests me, because I directly bid for work such as this, and when tendering you usually find the bloke down the road working out of his spare bedroom that thinks he can do it for a tenner over one day. The company requesting the work then thinks that everyone else is overinflating their prices so goes cheap and pays for it big time downstream. Cheapest and quickest is rarely best. On the flip side, nor is most expensive. Tricky world init. Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Porting from MS SQL to MySQL
- Original Message - From: j.urban [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 18, 2002 4:10 PM Subject: Re: Porting from MS SQL to MySQL Unless they are saying they doubt that mySQL is upto, it so it's no good quoting. They may have a room full of SQLServer people twiddling their thumbs in which case I agree with you, they are not bucking for the customer here. On the other hand they have very real doubts that mySQL is upto the job; they may be wrong on this last point, but at least they are being honest in their beliefs. Who knows! This doesn't make much sense. If they're being honest and they believe MySQL can't handle it, why would they offer to port it to MySQL for 18,000 euro? I don't know. Perhaps they are offering not just to port to mySQL but redesign the bits that they believed made an impractical initial mySQL installation. Perhaps 'impractical' because of time and MSSQL would be faster. Perhaps impractical because the CEO is shagging the marketing manager of MSSQL and didn't want to upset her. We don't know!!! My point is that the originator of the question didn't seem to have a clear idea of what was being offered for E18k but that could be an entirely reasonable bid for the work and application required. Just because it looks like a 'big number' doesn't mean that isn't what it will cost. All of a bit of a futile argument really without knowing a lot more. Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Spam - a possible cause ?
- Original Message - From: Marjolein Katsma [EMAIL PROTECTED] To: [EMAIL PROTECTED] [RegSoft/mysql] [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 12:44 PM Subject: RE: Spam - a possible cause ? Matthew, snip Spam is people not interested in MySQL at all posting a Business opportunity (Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center!) or Golden Investment Opportunity or Great Growth Potential stock scams. Marjolein, They sound like great opportunities. Do you have any more info? Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: user / pwd access to db driven website
Why don't you forget about the automated subscription service and use the phone or email to get the money in. Once you have your 5-10+ subscriptions up and running then you can upgrade properly and then get your shopping cart or whatever. Presumably you'll also want to use a different userID/password per user and track what they are doing so you'll need a completely new set of infrastructure tables and the backend code to maintain them. Another idea if your technical skills aren't yet upto the job would be to put the data onto CD and just send that out to the early customers; the data doesn't sound that volatile and web delivery may not be the best way. All the above would also give you a much earlier idea of whether this will be a success or not. Very few sites that ask for money for information are a success and if just five subscribers will bank roll you a new platform then your prices are clearly not a couple of pence per access. Good luck, Tony - Original Message - From: Investor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 06, 2002 5:49 PM Subject: user / pwd access to db driven website HI all, I would be extremely appreciative with solution suggestions to the problem I am having. I really could use some help right now !! I am trying to get a database driven website up and running that has some amount of security on it (which i intend to make progresively better). It needs user/pwd access to a database of info, after a subscription fee is paid. Currently I am having trouble setting up the basic structure. By the way this is a starup company, and only 5- 10 subscriptions would fund much better software / hardware / server for the site. So my goal is to set up something inexpensive to get those 5 or so subscriptions. Attempt No. 1: I setup a test site ( virtual hosting I think it is called) that utilizes perl ms access. It works oK except I didn't get the user/pwd thing working. It has pwd protected directories - however they told me queries will not work with the pwd protected directory insalled. Technical support is very slow in responding. And I didn't figure out how to provide the needed security mentioned above. Currently I have been reading about mysql and just installed it on windows 98. I am open to changing over to linux based systems. However I would like to create the tempory site to get a few subsciptions prior to forking out the funds. So finally now that you guys know my situation can you please make some suggestions as to how to get the temporary site up ( to get 5 subscriptions or so) and I think I coudl painfully, over time, work on a site that could handle much more. Information: The database would be text only, less than 1 GB ! Right now I think it is at 5 MB but will increase. I am familar with perl 5.6 and ms access. Budget: Shoe string budget for now. :) I would greatly appreciate assistance I am sure many of you dealt with this type of situation before. = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multiples instances of MySQL
See manual section 4.1.4. - Original Message - From: Emmanuel van der Meulen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 30, 2001 9:47 AM Subject: Multiples instances of MySQL Hello all, Could someone please advise, what is the procedure to start and run more than one instance of MySQL? Kind regards Emmanuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Smalltalk and mySQL
Anyone have any experience of using mySQL within Smalltalk servers on a unix/linux platform? Any decent links? I am just exploring this now as I have heard there is now a Smalltalk mod for Apache. This sounds like a fun combination to play with! thanks, Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Searchable Mailing List Archive now up.
- Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 9:19 PM Subject: MySQL Searchable Mailing List Archive now up. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive Simply fabulous! Thanks! Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] A News Group Perhaps.
Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (title and text) and can be read or ignored by choice. I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. Tony - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:58 AM Subject: RE: A News Group Perhaps. Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: From Oracle to the MySQL Database Server
Hi Arjen, - Original Message - From: Arjen G. Lentz [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 09, 2001 1:40 AM Subject: Re: From Oracle to the MySQL Database Server But eh, what are those gripes about transactions and locking? Are you aware that the MySQL server with the InnoDB table handler (since over a year now!) features full transactional capabilities including row level locking? You just need to grab a 3.23-Max version, or compile 3.23 from source, or any 4.0 version. For more info on the InnoDB table handler, see http://www.mysql.com/doc/I/n/InnoDB.html in the online manual. Yep, I do know about that and I was wrong not to mention it. It's just something that I haven't set up to use yet because I don't 'need' it as another level of complexity (at the moment). I love the idea of being able to choose whether I want it or not. For what I am doing at the moment I really don't need it - a few hanging FK's or missing children won't bother me as I am dealing with statistical analysis and as long as the failures are within tolerence than that's fine! It's just so fast compared to what I have been using! When I said 'gripes', I didn't mean mine - there are the usual knockers who probably haven't looked at page 1 of the manual let alone tried the system. I have come across experienced database people who get very snotty when they find out about transactional processing not being inherent in mySQL even though there are some very commercial systems out there that have the same approach to get the speed they need. People's attitudes (especially those with an Oracle background IMHO) are very hard to change. Thanks for adding to my misleading note. Are there any highend figures to estimate the performance hit by using InnoDB across the platforms? Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: IN keyword supported?
Hi Bennett, - Original Message - From: Bennett Haselton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 09, 2001 12:31 PM Subject: IN keyword supported? I'm trying to use the IN operator as described in my databases textbook from college. This query: select count(*) from user where user.ID in (select ID from user); is supposed to evaluate to count the number of rows in the 'user' table where the ID field is in the set of all ID field values in the 'user' table (in other words, just a roundabout way of counting the rows in the 'user' table, written solely to demonstrate the IN keyword). There doesn't seem to be a syntax error in that example, but MySQL gives the error: ERROR 1064: You have an error in your SQL syntax near 'select ID from user)' at line 1 Is the IN keyword not supported in MySQL, or am I using it wrong? Subqueries are not supported in mySQL. Have to rewrite it with a combination of outer joins to do the same thing. Have a look at section 1.7.4.1 in the manual. Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Annoying article about MySql
snipped I used Oracle8i before (under very heavy load) and did not have any problems there. I am now using MySql under not so heavy load and have not yet had any problems with it, but just want to be prepared when and if they come along. Oracle 8i rel 3 enterprise edition - 28,000 pounds sterling. mySQL - freeish. Coming from an Oracle background, I started off hating mySQL. So far, I have only 'played' with it, but now have enough confidence to start using it for real. It is super fast and my test loads (as much as I can throw at it from several machines/sources/threads) have yet to fail. Does the job very nicely. Yes there are the usual gripes about views, transactional processing, and locking, but if you know about these at the design stage they can be managed. I'm a fan! Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php