Re: mysql 4.0.15 and latest redhat enterprise AS Beta - segmention fault

Thomas, the current mysqld-standard does not work with the Red Hat AS beta (Taroon). We are looking into solving this issue. The problem seems to be connected to statical linking. You can try mysqld-max, as it is dynamically linked. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com

change the *user* table OR simply use GRANT query?

Greetings, I'm so curious about this: If a new MySQL database account need to be created, do you insert the account info to the *user* table of the *mysql* database OR do you grant the new account by the GRANT query? What are the differences andn which one do you prefer? (I got some trouble

MySQL garbles some UTF-character such as capital swedish oe or cyrillic soft sign

Description: The UTF-8 encoding for capital swedish characters ae aa and oe doesn't work. Some cyrillic characters doesn't work either. A lot of other utf-encoded characters work so the settings are not wrong. It seems like mysql looses some information when it stores these characters. At first

MySQL garbles some UTF-characters such as

Title: Message capital and (cyrillic soft-sign).

Re: slow performance with large or list in where

Your problem is that MySQL don't use indeces in selects with 'or' (See MySQL manual). But i didn't have understand what's your problem executing individual selects... You don't need to open parallel connections. Put the UPDATE commands in a file, and execute them in mysql prompt like this: mysql

SQL select

hello, i spent about 2 hours solve this problem, i have got a 2 mysql tables, eg: data room_id user_id user_typ user_login messages id text from from_type (quest, user) to to_type (quest, user) itime (type datetime, time when message were insert) and my situation: data 1 1 ujoe 1

Re: slow performance with large or list in where

On Sun, 5 Oct 2003, Alexis da Cruz Henriques Guia wrote: Your problem is that MySQL don't use indeces in selects with 'or' (See MySQL manual). If you are referring to: http://www.mysql.com/doc/en/Searching_on_two_keys.html then that page doesn't say mysql doesn't use indexes on

Re: mysql account

At 14:00 +1000 10/5/03, Wang Feng wrote: If you deleted the rows with a DELETE statement, you'll need to also issue a FLUSH PRIVILEGES statement to cause the server to reread the grant tables. In order to try the FLUSH PRIVILEGES statement, I inserted a new user account into the 'user' table

Re: slow performance with large or list in where

Have You test in operator? select * from table where id in (10,20,30,50,60,90, ) Santino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: change the *user* table OR simply use GRANT query?

At 18:47 +1000 10/5/03, Wang Feng wrote: Greetings, I'm so curious about this: If a new MySQL database account need to be created, do you insert the account info to the *user* table of the *mysql* database OR do you grant the new account by the GRANT query? What are the differences andn which

Good SQL Cookbook

Does anyone have a recommendation for a good SQL cookbook? I can do some basic selects, updates and deletes but I'm not comfortable with some of the logic involved in joins or the proper use of group by, etc. In addition, though a full exposition on the SQL language might be instructive, right

Re: slow performance with large or list in where

On Sun, 5 Oct 2003, Santino wrote: Have You test in operator? select * from table where id in (10,20,30,50,60,90, ) Yes, IN does perform at the levels I want and works for the simplified example I gave, but doesn't work for the generalized case I need, which is matching individual rows in

Re: Good SQL Cookbook

Check out safari.oreilly.com, they have a two week trial right now, and they have a sh*tload of books online, including 'MySQL Cookbook' by Paul Dubois, and they also have 'MySQL' and 'MySQL and Perl for the Web' by Paul also, I would say they are probably the best MySQL books I've found, I

Re: can NOT drop the database

Just got back onto this again now. To quote the docs you pointed me at: If MySQL crashes in the middle of an ALTER TABLE operation, you may end up with an orphaned temporary table inside the InnoDB tablespace. With innodb_table_monitor you see a table whose name is #sql..., but since MySQL

Re: slow performance with large or list in where

Hi, - Original Message - From: Marc Slemko Sent: Sunday, October 05, 2003 2:27 PM Subject: Re: slow performance with large or list in where On Sun, 5 Oct 2003, Santino wrote: Have You test in operator? select * from table where id in (10,20,30,50,60,90, ) Yes, IN does

Re: slow performance with large or list in where

Might instead want to look at where fooid in (xx, xx, xx, xx) On Sat, 4 Oct 2003, Marc Slemko wrote: If I do a query such as: SELECT * from foo where fooid = 10 or fooid = 20 or fooid = 03 ... with a total of around 1900 or fooid = parts on a given table with 500k rows, it takes about

Re: Blob fields

Any mysql encryption functions would be done server side ofcourse before putting it into the database.. I'd just incorporate an de/encryption scheme into your client app, and insert as standard BLOB string to remote server. On Sat, 4 Oct 2003, sian_choon wrote: Hi, I have the question

Re: GROUP BY/ORDER BY Problem

The SQL specification does allow aggregates in the ORDER BY. Does mySQL have any plans to add such functionality (or at least add it to its list of things it doesn't do)? The problem with the solution of ordering by an alias is that I may not necessarily want the thing I'm ordering by to be in

confused newbie -- Open Office 1.1 as front end

Hi guys n gals OK MySQL is nice and robust, i'm stiil new to it and have an M$ Access mentality when it come to buiding and working with DBs. Can i build an example_client table and an example_appointment table in MySQL and then use M$ Access(odbc) or data sources in Open Office to create the

RE: confused newbie -- Open Office 1.1 as front end

Warren: Yes and no. You can use Access as a front end to MySQL, including creating forms and queries. If you want relational integrity you'll need to handle that directly in MySQL (with raw SQL) or with a dedicated MySQL designer tool (there are several available, both freeware and commercial -

Creating Triggers and procedures in MySQL

Hi All, I am looking into putting triggers, procedures and into MySQL. The tools I am using seem to lack this facility, unless MySQL doesnot actually have these important database features. Any help is appreciated. Gregory Hicks Database Analyst Programmer -- MySQL General Mailing List For

Re: Creating Triggers and procedures in MySQL

Information from the manual: 1.7.4.4 Stored Procedures and Triggers Stored procedures are being implemented in our version 5.0 development tree. See section 2.3.4 Installing from the Development Source Tree . This effort is based on SQL-99, which has a basic

Re: mysql account

Thanks Paul. Fully understand!! cheers, feng - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Wang Feng [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, October 06, 2003 4:38 AM Subject: Re: mysql account At 14:00 +1000 10/5/03, Wang Feng wrote: If you deleted

Re: Creating Triggers and procedures in MySQL

Jeff, Your name is familiar to me. Are you involved in any way with the Borland C++ Builders list on Topica.com? OK, that explains why I can't find the feature. I consider them to be important, but not mandatory. Their presence can simplfy business rules in data processing. regards