AW: EMS MySQL Manager for Linux 1.15 released!
Hi, ok, no doubt about that's related software would be nice to informed about here. But what I found amazing that there wasn't a discuss just a non-related hint to get back in mind But if I'm lonely with my opinion, there's no problem for me! 2EMS HiTech Team: BTW, I'm not a member of Siemens and and wouldn't be a difference. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 18. Marz 2003 16:31 An: [EMAIL PROTECTED] Cc: Rusch (ext) Reiner Betreff: Re: EMS MySQL Manager for Linux 1.15 released! Hello All, We are not spammers at all. We just think that our announcements may be interesting to the MySQL community as our products are directly related to MySQL server. Thanks to everyone who understands that and supported us in this discussion. 2Reiner: BTW, one of the Siemens AG branches is an owner of MySQL Manager site license. :-) Best Regards, EMS HiTech Team http://www.ems-hitech.com - Original Message - From: Rusch (ext) Reiner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:27 PM Subject: AW: EMS MySQL Manager for Linux 1.15 released! Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS MySQL Manager for Linux 1.15 released! EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.mysqlmanager.com/download.phtml What's new in version 1.15? 1. Export Data Dialog: export to PDF added. Now you can export data to one of the most popular document formats as well as to the other supported formats. 2. Export Data Dialog - export to HTML: a possibility of customizing navigation links for multi-file export and a possibility to define a background picture for the result table added. 3. Import Data Wizard: import modes are implemented - now you can define an action to be executed with the concurrent records in the source file and the target table. You can either update these records, delete them, insert only new records, and more. For these purpose you should define key columns as primary key. 4. Import Data Wizard: added a possibility of defining a way to add data to the destination table - insert or append. 5. Several small improvements and minor bugfixes. What is MySQL Manager? EMS MySQL Manager provides powerful tools for MySQL Server administration and object management. Its Graphical User Interface (GUI) allows you to create/edit all MySQL database objects in a simple and direct way, run SQL scripts, manage users and administer user privileges, extract, print, and search metadata, create database structure reports in HTML format, export/import data, and supplies many more services that will make your work with the MySQL server as easy as it can be... Don't forget to check out other our products: http://www.ems-hitech.com/sqlmanagers Powerful database administration tools for InterBase/FireBird, MySQL and PostgreSQL servers http://www.ems-hitech.com/sqlutils/ Cross-platform data management utilities http://www.ems-hitech.com/components/ Powerful components for Delphi/C++ Builder developers We hope you'll like our products. Thank you for your attention. Best Regards, EMS HiTech Team http://www.ems-hitech.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php
AW: EMS MySQL Manager for Linux 1.15 released!
Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS MySQL Manager for Linux 1.15 released! EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.mysqlmanager.com/download.phtml What's new in version 1.15? 1. Export Data Dialog: export to PDF added. Now you can export data to one of the most popular document formats as well as to the other supported formats. 2. Export Data Dialog - export to HTML: a possibility of customizing navigation links for multi-file export and a possibility to define a background picture for the result table added. 3. Import Data Wizard: import modes are implemented - now you can define an action to be executed with the concurrent records in the source file and the target table. You can either update these records, delete them, insert only new records, and more. For these purpose you should define key columns as primary key. 4. Import Data Wizard: added a possibility of defining a way to add data to the destination table - insert or append. 5. Several small improvements and minor bugfixes. What is MySQL Manager? EMS MySQL Manager provides powerful tools for MySQL Server administration and object management. Its Graphical User Interface (GUI) allows you to create/edit all MySQL database objects in a simple and direct way, run SQL scripts, manage users and administer user privileges, extract, print, and search metadata, create database structure reports in HTML format, export/import data, and supplies many more services that will make your work with the MySQL server as easy as it can be... Don't forget to check out other our products: http://www.ems-hitech.com/sqlmanagers Powerful database administration tools for InterBase/FireBird, MySQL and PostgreSQL servers http://www.ems-hitech.com/sqlutils/ Cross-platform data management utilities http://www.ems-hitech.com/components/ Powerful components for Delphi/C++ Builder developers We hope you'll like our products. Thank you for your attention. Best Regards, EMS HiTech Team http://www.ems-hitech.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
AW: Large resultset
Hi, why don't you try to solve the problem with ordinary sql-selects. You can take select . limit regards Reiner -Ursprüngliche Nachricht- Von: Roland Carlsson [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. März 2003 12:54 An: [EMAIL PROTECTED] Betreff: Large resultset Hi! I have a query that returns a resultset of 70 mb. I'd somehow would like J/Connector to fetch only small pieces using Statement.setFetchSize but it still get the whole ResultSet at once and then I get an OutOfMemoryError. Is it a bug in setFetchSize? Does J/Connector ignore it? Have I totally missunderstood what setFetchSize does? I use J/Connector 3.0.6 Regards Roland Carlsson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mix soundex and fulltext
Hi,
as MySQL doesn't seems to support a direct access to the fulltext index
tables I wonder how or if it's possible to mix a
soundex-fulltext-mixed-mode selection.
So my actual selection is like:
select data,match(data) against ('$query' in boolean mode) as score from
TABLE where match(data) against ('$query' in boolean mode) order by score
desc
How to use a soundex without using a selfmade indextable???
Any ideas?
Thanks and regards,
Reiner
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hit on Reg.Expression like in Perl
Hi, I wonder if something like in perl is possible: data in rows: 1) a12345xb54321x 2) b54321xa12333x I want to extract b(number) and store into another table. In perl this would work with pattern matching (reg.expressions) like: $data =~ s/.*?b(.*?)x.*?/$1/; $data_b = $1; so, reg.expressions in MySQL also works as I know, but how could I get the $1 to go further and store a substring of the hit into another table? Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB
Hi, I have one question about InnoDB-tables especial the filesize of all tables. In the past I took MyISAM but found out, some things in InnoDB make the system more stable. But I want to get more free space. In MyISAM the space grows automatically, but not in InnoDB by default. In my /etc/my.cnf the line for the path and file size is not active like in the original file. But it works but with about 250-300MB max. size (don't know exactly). If I uncomment this line to expand my space, mysql (4.0.10) doesn't start. Don't know why. Any hint? Thank you. Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: InnoDB
thanks a lot, I managed it now. was just a little misconfigured my.cnf-file -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 19. Februar 2003 14:34 An: [EMAIL PROTECTED] Betreff: re: InnoDB On Wednesday 19 February 2003 13:21, Rusch (ext) Reiner wrote: I have one question about InnoDB-tables especial the filesize of all tables. In the past I took MyISAM but found out, some things in InnoDB make the system more stable. But I want to get more free space. In MyISAM the space grows automatically, but not in InnoDB by default. Take a look at autoextend option: http://www.mysql.com/doc/en/InnoDB_start.html In my /etc/my.cnf the line for the path and file size is not active like in the original file. But it works but with about 250-300MB max. size (don't know exactly). If I uncomment this line to expand my space, mysql (4.0.10) doesn't start. Don't know why. Check error logs. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: InterBase vs. Mysql
Hi Maciej, I don't know much about Interbase, but MySQL is for some cases a very good choice! Some database engineers would say MySQL isn't a database because it has no transactions by know (in a stable version). But think about, if you really need this!!! In versions 4.x (coming soon in a stable version) transactions, subselects etc. would be available! We use MySQL because of its speed and the costs are very low! Have a look on http://www.w3research.com ! The charts are rendered in realtime by a roxen server in the data comes out of MySQL. Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: InterBase vs. Mysql
Hi Ben, hi Maciej, the only arguments you can get in favour of mysql is that it's free, Free??? Bollocks. you're right! It's NOT free. Just for personal use there're no costs. I program for a small company producing commercial programs. We have found: MySQL Licence will cost us more than our product price. MySQL sails staff are rude and unfriendly. I contribure to MySQL stuff (in a minor way), and now I am expected to pay as well. Get real! This is the main reason why I am looking at PostgreSQL at the moment, although I've not looked much at Interbase, any good? Ok, if you're not making money on what you're working, then you're right! But: Is it the fault of MySQL AB that you sell your work for nothing? I don't understand, why everybody wants anything for free! Open Source != Freeware The license of MySQL is very cheep! Look at oracle and you know what I try to explain. Ok, Oracle is an other thing, seems to be for very greath projects, but if you need speed and having a small budget then MySQL is a good choice. Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: AW: InterBase vs. Mysql
Hi Ben, Some database engineers would say MySQL isn't a database because it has no transactions by know (in a stable version). But think about, if you really need this!!! Very much so! With dependent foreign key constraints that are being developed by MySQL, you have to use delayed constraint checking in the form of a transaction, or with cyclic references, you can never add data to your tables :) ok, you're right! But there are possible other ways to solve this. You possibly could take care by your program. In our project we have no problems like this because we use different tables for input and output. We use unique keys so that theres no corrupted data. Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: InterBase vs. Mysql
Hi Ben, I'm not sure what you really want to sell. If you have to take a license from MySQL because of a commercial use, you just have to take ONE license. Correct me, if I'm wrong! If you want to sell your programs etc. which uses MySQL then see it in another way: Firstly MySQL isn't very expensive in my opinion. If your client wants to buy your programs then he has to buy a license (when his way is a commercial one). So this would be a must that your client has to take. But, if you would sell programs based on Microsoft Windows, what would be the difference? None! Your client would need to have a valid license on this OS! But would you say, Microsofts Windows (for example!) would be bad just because it's difficult to tell your client that he NEED'S windows to run your work? NO, you wouldn't! Perhaps because everyone has windows. But why to think in another way about MySQL? I think this isn't fair!!! Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: AW: InterBase vs. Mysql
Hi Ben, I feal I am digging my self a grave here, so this will be about my last ever posting... Either that or your mailing administrator will start bouncing my mail I don't think so. You said nothing bad! Just talking about things which perhaps could be better or discuss that would no reason to take you from the list of discussions about MySQL!!! Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: apostrophe and comma error on submit
Hi, Does anyone know about an error that occurs when you try to submit into mysql. Whever i try to imput any text with a comma in it or an appostrophe, i get an error until i remove it. Any suggestions. .. anyone...? Im using php and submiting via post, when i get the error. Thank you so much for your time. Under perl I use $handle-quote($data) to solve this. By using this you could insert even binary things!!! Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 cache
Hi! I've got one question which belongs to the new query cache in 4.01. I wonder why the cache should be deleted if there's a statement like update, insert etc. I think it must be considered that there are possible situations where this isn't the best way. For example: 1) select * from DATABASE where DATE = '2002-12-02' 2) update DATABASE set NAME = 'my name' where DATE = '2002-12-01' So 2) would kill the whole cache, but for 1) the update doesn't matter! Wouldn't it be better to look for what selects matters for the cache by updating something in the table??? I think that would improve much more performance. Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
