Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

MUCH BETTER!! Sorry I doubted you. However you have to remember that unless you declare a second numeric column in your PRODUCT_SPECS table then everything will be treated as strings. Sorting will be as strings, comparisons will be as strings, and any attempt to use them as numbers while they a

IN(INT VS CHAR)

When using IN should i design the database to use int's or is the performance equal? WHERE col IN('test','test2','test3') vs WHERE col IN(1,2,3) - FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List Fo

Re: Min permissions to run `mysqladmin version`

At 16:33 -0800 12/9/05, Scott Haneda wrote: I need to run `mysqladmin version` from a remote host, on the same LAN, what are the min permissions for a user I need to set up to get this data? No permissions are necessary, you just need an account that has no privileges. The account needs only to

Min permissions to run `mysqladmin version`

I need to run `mysqladmin version` from a remote host, on the same LAN, what are the min permissions for a user I need to set up to get this data? -- - Scott HanedaTel: 415.898.2602

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

Yes the ordering is the only problem i have seen so far but i´m concerned that the >= ? might cause problems to? It seems to work but since it orders the results wrong can i be sure that it will always do this correct for me? In the ordering it seems like mysql thinks that 80Gb is larger than 12

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

Oh, is it really such a bad design? Here is some more. What is substring matches, and why do i need them? TBL_PRODUCTS ID PRODUCTNAME 1 SAMSUNG TV 2 PHILIPS DVD-PLAYER 3 PHILIPS TV 4 MAXTOR DMAX 5 LaCie HARDDIVE - TB

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

Test USER wrote: Hi again :) The table contains a column named value and is in the format varchar(255). This column contains specifications for different computer products. There is also a id column so i know which product it belongs to. value(varchar) 80 17" 1024x768 USB DiVX For example, the

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

This sounds like a simple case of bad design. You need to be able to locate specific values for various product descriptions but they are all mangled together into just one field. You end up trying to do substring matches and all hell breaks loose and performance hits the skids. My suggestion

RE: copying data!!!

Sorry the DROP TABLE Should be TEMP not table1 -Original Message- From: Gordon Bruce [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 3:51 PM To: Sachin Bhugra; mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: RE: copying data!!! This is kind of ugly, but with the multitable

RE: copying data!!!

This is kind of ugly, but with the multitable limitations of 3.23 it probably works. CREATE TABLE TEMP SELECT table_1 columns except age, table_2 age FROM table_1 INNER JOIN table_2 USING (name); TRUNCATE table_1; INSERT INTO table_1 SELECT * FROM TEMP; DROP TABLE_1; --

ANN: Database Workbench 2.8.0 update

Ladies, gentlemen, This week, Database Workbench 2.8.0 was released. However, that build included an error with MySQL and loading index metadata and an specific error with Firebird/InterBase. There's a new installer available at our website. Below is the original announcement... --announcement

Re: Optimize: 14 hours and still running!

Is the box swapping? Gleb Paharenko wrote: Hello. As was mentioned by other members without seeing your configuration settings it is difficult to say about InnoDB performance. You can indirectly monitor the OPTIMIZE speed by ROW OPERATIONS section of SHOW INNODB STATUS. For InnoDB it maps to A

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

Hi again :) The table contains a column named value and is in the format varchar(255). This column contains specifications for different computer products. There is also a id column so i know which product it belongs to. value(varchar) 80 17" 1024x768 USB DiVX For example, the first value 80 tel

Re: copying data!!!

Check this out. http://dev.mysql.com/doc/refman/5.0/en/insert-select.html On 12/9/05, Sachin Bhugra <[EMAIL PROTECTED]> wrote: > Hello Friend, > > Can you please let me know how to copy data from a column in table A > to a column in table B. e.g. I want to copy value of column "age" from > table

Re: recursive queries

I believe that some time in the future mysql will support oracle style connect by prior syntax but it's not implemented yet. Gleb Paharenko wrote: Hello. Though I haven't read this article, but its title looks promicing: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

I misunderstood, I thought you were looking for a way of converting your numbers-as-strings into a native numeric format. Please describe you situation better: What language are you using to build your application. Are you composing the SQL statement client-side or server-side? What kind of SQ

Re: copying data!!!

Tnx for the reply Jimmy. I also sent another question( i know its a very silly question for you all..but believe me i am tryin this for past three days and not able to get it) Pls hlp..(just give me hint in right direction, and i will try to do the rest) Tnx Sachin -- MySQL General Mailing L

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

Hello, thanks for your help! I dont really get it :) You suggestion is to have a seperate column with the name numericvalue and insert userinput into that and add a zero, right? Could you explain more, why when how will this help me :) Quoting [EMAIL PROTECTED]: > Assuming that your text data

Re: CAST as SIGNE=?ISO-8859-1?Q?D,_bad_id=E9a??=

Assuming that your text data is in the column `userinput` and you want the integer values to be in the column `numericvalue`, this statement will populate the `numericvalue` column all at once: UPDATE `odd_data_table` SET `numericvalue` = `userinput` + 0; You are better off checking for type-co

CAST as SIGNE=?ISO-8859-1?Q?D,_bad_id=E9a??=

in an application i have written there is the need to do a search from mysql using numbers that are stored in a varchar column. it is not possible to store only the results with numbers in a seperate column. so i was looking at CAST(), is this a big performance loss? is there some way of benchma

RE: copying data!!!

Hello, We expect to offer native support for LDAP and PAM authentication, late next year. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Sachin Bhugra [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 1:38 PM To: mysql@lists.my

Re: cursor in 4.1

At 11:17 -0800 12/9/05, Kemin Zhou wrote: All, I am using the perl DBI to access a large table. I need to a simple manipulation of the table then write it to a file. If I use the simple "select * from table" then process this statement on the client side, it looks that the client first receiv

copying data!!!

Hello Friend, Can you please let me know how to copy data from a column in table A to a column in table B. e.g. I want to copy value of column "age" from table 2 to column "age" in table 1, provided the entries in column "name", which is there in both the table, should match. In MySQL v 4 it cou

cursor in 4.1

All, I am using the perl DBI to access a large table. I need to a simple manipulation of the table then write it to a file. If I use the simple "select * from table" then process this statement on the client side, it looks that the client first receive all the content of the table. This caus

Re: MySQL newb trying to write a trigger...

you could also have a look at http://dev.mysql.com/tech-resources/articles/mysql-triggers.pdf which I found useful. -jp

Re: SELECT all except ... ?

It's not possible in the query, but I wonder if there's a UDF you could write that takes in the name of a table, and then a list of columns NOT to show, and outputs a string of comma-separated values. That'd be neat, so then you could write: SELECT allBut(mytable,badfield1,badfield2,. . .) FROM m

Re: Normalization question

Rod Heyd wrote: Hi Everyone, I've got a little debate that maybe you can all help me settle. I have three tables that I need to join, but there are performance problems with the joins due to some misunderstandings of my predecessor about what's needed to join the tables efficiently. Here's the

Re: Normalization question

Rod Heyd <[EMAIL PROTECTED]> wrote on 12/09/2005 11:01:38 AM: > Hi Everyone, > > I've got a little debate that maybe you can all help me settle. > > I have three tables that I need to join, but there are performance problems > with the joins due to some misunderstandings of my predecessor about

Normalization question

Hi Everyone, I've got a little debate that maybe you can all help me settle. I have three tables that I need to join, but there are performance problems with the joins due to some misunderstandings of my predecessor about what's needed to join the tables efficiently. Here's the setup. t1 has a

Fw: SELECT all except ... ?

Oops, I meant to send this to the original poster _and_ the list :-) Rhino - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Frank Rust" <[EMAIL PROTECTED]> Sent: Friday, December 09, 2005 9:02 AM Subject: Re: SELECT all except ... ? - Original Message - From: "F

Re: SELECT all except ... ?

Frank Rust <[EMAIL PROTECTED]> wrote on 12/09/2005 01:59:35 AM: > Is there a possibility to select all columns from a table except one or > two columns? For example I have a table with 30 columns and want all > columns but one column *not*. Do I have to write a very long select > statement with

Re: Rpm installation problem

Hello. It is a bug: http://bugs.mysql.com/bug.php?id=15223 Like temporary workaroud I use on my FC4 system MySQL-shared-compat-4.1.13-0 rpm. Logg, Connie A. wrote: > I am trying to install the following rpm on a red hat linux machine.=20 > MySQL-client-standard-5.0.16-0.rhel3.i

Re: recursive queries

Hello. Though I haven't read this article, but its title looks promicing: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html Duncan Miller wrote: > I am looking to do a query on a self join table that returns the parent > records. > > Obviously there are ways to d

Re: SELECT all except ... ?

On 09/12/05, Frank Rust <[EMAIL PROTECTED]> wrote: > Is there a possibility to select all columns from a table except one or > two columns? For example I have a table with 30 columns and want all > columns but one column *not*. Do I have to write a very long select > statement with 29 column names

Re: String Manipulation

On 09 Dec 2005 10:45:04 +0800, Jeffrey G. Ubalde > I have been thinking about this for hours, and I cant quite get the > correct keyword for me to search it in the manual. > > for example i have a field that contains string1:string2:string3 > where colon ':' is the delimiter. > > How do i create a

Re: transaction with bdb table gives error "Lock table is out of available locks"

Maybe i got it! For the chronicle: I resolved the problem decreasing the max_bdb_lock to the default value and creating an index on the column used in the where clause of my query. Probably mysql tried to lock the whole table because the primary key wasn't in the where clause. Cheers, Marco Marc

Re: Optimize: 14 hours and still running!

Hello. As was mentioned by other members without seeing your configuration settings it is difficult to say about InnoDB performance. You can indirectly monitor the OPTIMIZE speed by ROW OPERATIONS section of SHOW INNODB STATUS. For InnoDB it maps to ALTER TABLE, which rebuilds the table.

Re: transaction with bdb table gives error "Lock table is out of available locks"

Hi, here's my create table: mysql> show create table parametrivaloriplc; ++-+ | Table | Create Table| ++-+ | parametrivaloriplc | CREATE

Re: transaction with bdb table gives error "Lock table is out of available locks"

Bdb tables locks are at page level, how can I determine the number of pages of my table? mysql> show variables like '%binlog_cache_size%'; +---++ | Variable_name | Value | +---++ | binlog_cache_size | 32768 | | m