Re: 1266 creating innodb tables

Hello. > Anywhere else I can check for that ? Send the output of 'show variables'. I'm especially interested in version, and have_innodb. Are there any lines in the error log similar to "InnoDB: Started"? BTW, options to MySQL Server could be passed in several different ways: http://dev

Re: Foreign characters in the shell

Hello. I'm not sure about German version of Windows, but from using a Russian localization I've found that Windows console usually isn't as good as GUIs. However, if all German characters are correct if you're just typing them, then mysql command line client should be able to show the correc

Re: Server-side functions

Hello. Please, could you send the 'SHOW GRANTS' statement for the root and some other user (which should be able to execute the routine). Include the source of your function (use 'SHOW CREATE' statement) and definitions of the tables, if your routine works with them. What version of MySQL ar

Re: Best field type for exact matches on alphanumeric fields.

Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/data-size.html You can freely download a sample character about data types from perfect book (MySQL 3-d edition): http://www.samspublishing.com/articles/article.asp?p=374690 You said that you're going to TEXT fields,

Re: PK or simple key?

Hello. > Or something else entirely? I'd guess the latter is the > Right Way, since the index will be significantly smaller, > but then I still need to go to the table to retrieve foo_id. What is important for you - speed or space? 5-6 million rows for table with this structure won't take

Re: Database IDs

Robert Crowell <[EMAIL PROTECTED]> wrote on 11/11/2005 12:39:37 AM: > > Hello, > > If I am relying on MySQL's AUTO_INCREMENT feature for the id for a table, how > can I reliably retrieve the ID of an item I just entered into the database? > > For instance, I have a table that stores first nam

RE: Database IDs

Hi Robert, You can use the function LAST_INSERT_ID() after the insert, this will return the id that was just assigned. It is documented here : http://dev.mysql.com/doc/refman/5.0/en/information-functions.html Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Ade

Database IDs

Hello, If I am relying on MySQL's AUTO_INCREMENT feature for the id for a table, how can I reliably retrieve the ID of an item I just entered into the database? For instance, I have a table that stores first names, and has an id field that is generated via AUTO_INCREMENT. However, this id will

Re: Does MySQL Support '=' Sign?

The Nice Spider <[EMAIL PROTECTED]> wrote on 11/10/2005 09:40:31 PM: > Does MySQL support: > > SELECT ID_TAG= ID > FROM TABLE > > rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty. > > Within the SELECT statement you must use := If you were in a SET statement, yo

Re: Load data infile fails to put entire PDF into one record

Gleb Paharenko wrote: Hello. Are you sure that you want to load PDF with LOAD DATA INFILE? Well, I had been sure, but not so much anymore. Maybe LOAD_FILE is that you want: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html Yup, this was the ticket. I'd seen several reference

Does MySQL Support '=' Sign?

Does MySQL support: SELECT ID_TAG= ID FROM TABLE rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty. - Yahoo! FareChase - Search multiple travel sites in one click.

RE: Can't start mysql 5.0.15

You don't appear to have completed the installation process. The processes are described here http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61

Can't start mysql 5.0.15

I am unable to start mysql after several trials and fixes. I compiled a mysql 5.0.15 source for FreeBSD 5.3. It doesn't seem to have placed the files in their proper locations. Below is what I keep getting and I don't know now how to get it working. What do I need to do about this "mysql.host" tabl

Re: Best field type for exact matches on alphanumeric fields.

We were storing relational data all in one field in XML. We now have a need to search through that data and we're now doing fulltext searches. And as you can imagine, this is getting painfully slow. We're now designing a true normalized database (well, normalized within reason) with table

PK or simple key?

I don't know why I have so much trouble visualizing indexes, but such is life. Imagine a simple table with only two columns: user_id and foo_id. I will only ever be looking up records in this table by user_id, but I will always retrieve both fields. Figure a million rows and maybe 5 or so rows per

Re: Best field type for exact matches on alphanumeric fields.

> I have to do some re-design of a website database that has quickly > outgrown itself. I'm trying to migrate to MySQL Cluster 5.0.15. Outgrown size or performance? Cluster 5.0 is memory based, databases are limited to a few gigs. Throughput can be good if application is _massively_ parallel.

Re: libmysqld as shared library (The Sequel)

On Thursday 10 November 2005 22:05, Warren Young wrote: > Peter M. Groen wrote: > > Still no luck. I'm trying to build libmysqld as a shared library for use > > in a project. > > This is a platform-specific issue. I don't see anything in this message > or your previous thread that tells the detail

Re: 1266 creating innodb tables

P. Evans wrote: Shawn, as far as I can tell, no. Here's all my innodb options set in my.cnf : Well, it's easy to check: grep skip-innodb my.cnf Is there anything interesting in the logs, maybe on MySQL startup? Jasper -- MySQL General Mailing List For list archives: http://lists

Best field type for exact matches on alphanumeric fields.

I'm runnung MySQL-Cluster 5.0.15 on Linux. I have to do some re-design of a website database that has quickly outgrown itself. I'm trying to migrate to MySQL Cluster 5.0.15. Mostly I've used VarChar fieldtypes in the past, but I want to make sure I'm using the best fieldtype for alphanumeri

Best field type for exact matches on alphanumeric fields.

I'm runnung MySQL-Cluster 5.0.15 on Linux. I have to do some re-design of a website database that has quickly outgrown itself. I'm trying to migrate to MySQL Cluster 5.0.15. Mostly I've used VarChar fieldtypes in the past, but I want to make sure I'm using the best fieldtype for alphanumeric in

Best field type for exact matches on alphanumeric fields.

I'm runnung MySQL-Cluster 5.0.15 on Linux. I have to do some re-design of a website database that has quickly outgrown itself. I'm trying to migrate to MySQL Cluster 5.0.15. Mostly I've used VarChar fieldtypes in the past, but I want to make sure I'm using the best fieldtype for alphanumeric in

Re: 1266 creating innodb tables

Shawn, as far as I can tell, no. Here's all my innodb options set in my.cnf : innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 4G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 inno

Re: libmysqld as shared library (The Sequel)

Peter M. Groen wrote: Still no luck. I'm trying to build libmysqld as a shared library for use in a project. This is a platform-specific issue. I don't see anything in this message or your previous thread that tells the details about your platform. What compiler, what operating system, wh

libmysqld as shared library (The Sequel)

Hi (Again), Still no luck. I'm trying to build libmysqld as a shared library for use in a project. I'd rather not link it statically into my project.. I'm using 5.0.15. According to the documentation, I'll have to configure with --enable-shared=yes and --with-embedded-server. The result in

RE: Format for saving date field.

What is the source of the data that is displayed on the screen. If it is a field in a MySQL table and the data type for that field is either DATE or DATETIME then it will intsert/update without any manipulation. Try doing a SELECT datefield FROM table Limit 15; outside of your ASP.NET envi

Re: GROUP BY / HAVING / Aggregrates

On 11/10/05, Peter Brawley <[EMAIL PROTECTED]> wrote: > Scott, > > >I created a report that shows effiency for each associate (K.AID). I > >am trying to figure out how to use GROUP BY to AVG(Effiency) for each > >K.AID in subquery. Originally I used temporary tables (4) to figure > >out the ave

Format for saving date field.

When doing an update or insert into a database with a date field, the format for the data on the screen is m/d/. However, I believe that MySQL is expecting it in the format of -mm-dd. I'm using MySQL in an ASP.Net application. Is there an EASY way to convert to the data to a format that

Re: GROUP BY / HAVING / Aggregrates

Scott, >I created a report that shows effiency for each associate (K.AID). I >am trying to figure out how to use GROUP BY to AVG(Effiency) for each >K.AID in subquery. Originally I used temporary tables (4) to figure >out the average effiency for each K.AID. That often left hanging >temporary tab

Server-side functions

I have written a little routine that returns somebody's age from a date-of-birth input, and it has always worked perfectly as part of a client-side front end. However, the best place for it is as a server-side function, which MySQL v.5 now allows. So I have re-written it as a server-side func

RE: really big key_buffer_size (> 4GB)?

chris I chased this down a while back. you are correct. 4G is max on 4.0 & 4.1 versions of mysql. I don't know about 5.0 though. I looked at the source for sql/mysqld.cc line 4170 UINT_MAX32 someone else found docs that said monty had done this since myism tables had issues deep inside the

Re: really big key_buffer_size (> 4GB)?

Chris Wells wrote: Chris Kantarjiev wrote: I'm running 4.0.25 on NetBSD 3 on an amd64. It appears that the key_buffer_size is being truncated to 4GB, even though I've set it larger. Could someone give me a hint about where to look? I'm a little suspicious of ha_resize_key_cache() which is usi

GROUP BY / HAVING / Aggregrates

I created a report that shows effiency for each associate (K.AID). I am trying to figure out how to use GROUP BY to AVG(Effiency) for each K.AID in subquery. Originally I used temporary tables (4) to figure out the average effiency for each K.AID. That often left hanging temporary tables and took

Re: How to write this query?

Michael McFadden <[EMAIL PROTECTED]> wrote on 11/10/2005 08:55:13 AM: > Hi Jerry. > > I'm new to the list, so don't take this as the final > answer. Wait for a guru to pounce with a better > solution! > > But, here is my idea: > > Before we start, note that "order" is a reserved word. > So we

Re: really big key_buffer_size (> 4GB)?

Chris Kantarjiev wrote: I'm running 4.0.25 on NetBSD 3 on an amd64. It appears that the key_buffer_size is being truncated to 4GB, even though I've set it larger. Could someone give me a hint about where to look? I'm a little suspicious of ha_resize_key_cache() which is using longs internally t

really big key_buffer_size (> 4GB)?

I'm running 4.0.25 on NetBSD 3 on an amd64. It appears that the key_buffer_size is being truncated to 4GB, even though I've set it larger. Could someone give me a hint about where to look? I'm a little suspicious of ha_resize_key_cache() which is using longs internally to hold the keybuff_size, b

Re: 1266 creating innodb tables

Is your server configured with "skip-innodb" ? It's an option that turns off support to that engine forcing it to elect a different method of storage. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "P. Evans" <[EMAIL PROTECTED]> wrote on 11/10/2005 10:10:44 AM: > Here's a

Re: How to write this query?

item_status table can have more than one status. I need to get the latest status from the table. Thanks On 11/10/05, ISC Edwin Cruz <[EMAIL PROTECTED]> wrote: > > Try it: > > select distinct a.* > from order a, > item b, > item_status c, > status d > where a.order_id = b.order_id > and b.item_i

Re: Consolidating two databases into one

On 11/10/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Seriously, "function" ?? Come on, Scott, you have been at this long enough > to be able to tell a function from a statement. ;-) > > Are you saying that you just want to move tables from one database to > another? "Combining data" has a

RE: How to write this query?

Try it: select distinct a.* from order a, item b, item_status c, status d where a.order_id = b.order_id and b.item_id=c.item_id and c.item_status_id = d.item_status_id where d.status = 'completed' It isn´t "tunned" but I think that it works for that you want -Mensaje original- De: Jerry

Re: Consolidating two databases into one

Seriously, "function" ?? Come on, Scott, you have been at this long enough to be able to tell a function from a statement. ;-) Are you saying that you just want to move tables from one database to another? "Combining data" has a wholly different meaning to it than simply relocating tables. The

Re: 1266 creating innodb tables

Here's an example : mysql> create table petest (col1 integer,col2 char(5)) engine=innodb; Query OK, 0 rows affected, 1 warning (0.07 sec) mysql> show warnings -> ; +-+--++ | Level | Code | Message

Re: MySQL .NET Connector

Jesse >I can actually see the line # where AN error occurrs, but it doesn't make >sense. It indicates "Type 'MySqlConnection' is not defined", however, it IS >defined. At the top of the file, I include <%@ Import >Namespace="MySql.Data.MySqlClient"%>. Besides this, before I did the "Create >ap

Re: Stored Procs, functions

Hugh >However, the best place for it is as a server-side function, which MySQL >v.5 now allows. So I have re-written it as a server-side function and >tried to run it, but it only works so long as I log in as root. Any >other user throws up an error, regardless of permissions granted. And >even l

Consolidating two databases into one

I got two databases that do not have similiar tables and would like to consolidate those two databases into one. What function should I use to do that? Scott -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html -- MySQL General Mai

Re: Does BLOB=Memo?

It depends, BLOB you can store just about anything in, like a document or an image. If you just want to store lots of text, then use the TEXT type. On Nov 9, 2005, at 2:32 PM, Jesse Castleberry wrote: I'm a bit new to MySQL. I need to create a Memo field (a field that could contain a lot

Re: How to write this query?

Hi Jerry. I'm new to the list, so don't take this as the final answer. Wait for a guru to pounce with a better solution! But, here is my idea: Before we start, note that "order" is a reserved word. So we must backtick `order` to reference the table in SQL (or the interpreter will think we're u

Foreign characters in the shell

Hello there, I'm new to MySQL and have just installed the 5.0 on a WinXP-Workstation. I have a question concerning the use of the shell-interface of my mysql-Installation. To load data in a table I used WinXP-Notepad to create tab-separated records (they contain special german chars ("Umla

RE: Triggers that handle multiple events (insert and update)

A valid question. However that's only the simplest example of the kind of validation I'm trying to put into the triggers (for the sake of a shorter email). Dan. -Original Message- From: Björn Persson [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 5:25 PM To: mysql@lists

RE: Column type problem

Thank you for your response. The information provided has been very useful in my progress Lance Longstreth Bandag Inc 1-(563)-262-2927 [EMAIL PROTECTED] -Original Message- From: Remo Tex [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 7:54 AM To: mysql@lists.mysql.com Sub

Stored Procs, functions

Database Manager Marlborough College I have written a little routine that returns somebody's age from a date-of-birth input, and it has always worked perfectly as part of a client-side front end. However, the best place for it is as a server-side function, which MySQL v.5 now allows. So I

How to write this query?

How to write the query? table1: order (order can have more than 1 item) table2: item (has order_id). table3: item_status (has item_status_id and item_id) table4: status (has item_status_id). Status can be 'complete', 'pending'. I need to get all orders that have ONLY completed items. Examples: if

Re: Problem with joins in MySQL 5.0.15

Hi Florin, I get a very strange error from a join in Mantis and this started after I upgraded from Mysql4 to Mysql5. I know there were some changes regarding the joins but this error doesn't say anything about the join. And the error I get is ERROR 1054 (42S22): Unknown column 'p.field_id' in

Re: libmysqld as shared library

Hi, I'm not building a client, I'm trying to build the library itself. If that's what you mean, I afraid I'm missing the point.. Could you be more specific? Thanx, Peter On Thursday 10 November 2005 11:45, Bruce Martin wrote: > Check out this link: >

Re: libmysqld as shared library

Check out this link: I was having a similar problem, but after I did what this page said it worked. On Nov 10, 2005, at 5:24 AM, Peter M. Groen wrote: Hi everyone, Iḿ new on this list, so please forgive me if i'm asking somethi

libmysqld as shared library

Hi everyone, Iḿ new on this list, so please forgive me if i'm asking something already discussed. (Found nothing in the archives, though) For this project we're doing, we try to build qt 4.0.1 with embedded mysql-support. The qt-part is no problem, but mysql 5.0.15 won't let me build a shared

Re: Problem with joins in MySQL 5.0.15

in MySQL 5.0.15 u must do like this: SELECT f.name, f.type, f.access_level_r, f.default_value, f.type, s.value FROM mantis_custom_field_project_table AS p LEFT JOIN mantis_custom_field_table AS f ON p.field_id = f.id LEFT JOIN mantis_custom_field_string_table AS s ON p.field_id=s.field_id AND s.