Re: User Variables

Ed Reed wrote: Thanks for the reply, So is there anyway to use User Variables with a single connection. All my apps are in VB6 and VBA. They all take a query, open a connection, run query, fill array from query results, close connection and pass back the array. Because of backward compatibility

Re: User Variables

Thanks for the reply, So is there anyway to use User Variables with a single connection. All my apps are in VB6 and VBA. They all take a query, open a connection, run query, fill array from query results, close connection and pass back the array. Because of backward compatibility there's no way

grant question

I am here in the docs. GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... ON {tbl_name | * | *.* | db_name.*} TO user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ... [REQUIRE NONE | [{SSL| X509}] [C

Re: grant question

At 11:19 -0500 4/22/05, Scott Purcell wrote: I am here in the docs. GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... ON {tbl_name | * | *.* | db_name.*} TO user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ... [REQUIRE

Re: InnoDB: How do I know how much free space there is left on a raw device?

At 17:48 +0200 4/22/05, Jarle Aase wrote: Hi list, Just a simple question. How do I know how much free space there is left on a device assigned to InnoDB? Depends on what you mean by "free space." Do you mean not space on the device not assigned to the InnoDB tablespace file, or space free within

RE: Write to a mysql table from Excel

Thank you for your reply. Can you provide more details on how to write to a MySQL table from Excel? I am a newbie to MySQL. Thanks. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, April 22, 2005 3:00 PM To: Huang, Ou; mysql@lists.mysql.com Subject: RE: Wri

InnoDB: How do I know how much free space there is left on a raw device?

Hi list, Just a simple question. How do I know how much free space there is left on a device assigned to InnoDB? Jarle -- Jarle Aase email: [EMAIL PROTECTED] Author of freeware. http://www.jgaa.com news:alt.comp.jgaa War FTP Daemo

RE: Write to a mysql table from Excel

Oh well, I am just not smart as you are. Sorry, I am a new comer in the Geek's world. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, April 22, 2005 3:12 PM To: Huang, Ou; mysql@lists.mysql.com Subject: RE: Write to a mysql table from Excel [snip] Thank yo

RE: Write to a mysql table from Excel

Get a beginners book then rather than posting messages. -Original Message- From: Huang, Ou [mailto:[EMAIL PROTECTED] Sent: Friday, April 22, 2005 5:17 PM To: Jay Blanchard; mysql@lists.mysql.com Subject: RE: Write to a mysql table from Excel Oh well, I am just not smart as you are. Sorry

Re: User Variables

Ed Reed wrote: If I run the following in MySQLFront v3.1 Set @A='Test'; Select @A; I get back same result +--+ | @A | +--+ | Test | +--+ If I run the same query in MySQL Query Browser v1.1.6 I get this, ErrNo 1060, You have an error in your SQL syntax; check the manual that correspo

RE: Write to a mysql table from Excel

[snip] Thank you for your reply. Can you provide more details on how to write to a MySQL table from Excel? I am a newbie to MySQL. Thanks. [/snip] You must be new to mailing lists too... http://catb.org/~esr/faqs/smart-questions.html You can save the excel as a CSV file and import that into MySQL

RE: Write to a mysql table from Excel

At 03:12 PM 4/22/05, Jay Blanchard wrote: [snip] Thank you for your reply. Can you provide more details on how to write to a MySQL table from Excel? I am a newbie to MySQL. Thanks. [/snip] You must be new to mailing lists too... http://catb.org/~esr/faqs/smart-questions.html You can save the excel

RE: Write to a mysql table from Excel

[snip] Is it possible to write to a MySQL table from Excel? [/snip] Sure. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB Writes blocking Reads

Andy, Can you send me the table layout and the script ? I'd like to try it here on one my test systems running 4.0.23. walt Andy McCurdy wrote: I haven't seen any other replies as of yet. After looking closer at the innodb status dump, the last known deadlock occured several days ago... so I don

Why is this table lock?

Hi In the output from the show innodb monitor I can see, that I have a table lock on a table. But, I never set a table lock on a table (only row locks). Do I misinterpret the output or what causes this table lock? thanks Reto TRANSACTIONS Trx id counter 0 95338708 Pur

problem with update statement

Hello, all: In a MyISAM table, I have a column named "MAC", of type VARCHAR(17). This field is used to hold MAC addresses of computers' network interface cards. These MAC addresses are in the form "XX:XX:XX:XX:XX:XX", where X can be either a number or an uppercase letter. I can run "select

innodb, optimizer and outer join

We are considering using Hibernate as a persistence layer to our web application. It seems to only want to do outer joins and this concerns me b/c they can be expensive. I created the following benchmark experiment and learned that the explain plan for the two constrained queries is the same.

Re: extract numeric value from a string.

Easy enough. Get the numeric part via CONVERT, then get the rest of the string from the length of the numeric part, plus one: SELECT tag, @num := CONVERT(tag, SIGNED) AS num_part, SUBSTRING(tag, LENGTH(@num) + 1) AS rest_of_string from tags; ++--++ | tag| num_par

RE: Write to a mysql table from Excel

One problem I've encountered in the past creating CSV files from Excel is with fields that exceed 256 or 258 characters. The fields end up truncated in the CSV file. A script to directly access the data in Excel and move it to MySQL is appropriate, but can be a lot of work if you only need to do

Write to a mysql table from Excel

Is it possible to write to a MySQL table from Excel? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB Writes blocking Reads

Andy McCurdy wrote: I forgot to mention: we're running mysql version 4.0.23-standard-log -- Official MySQL-standard binary. Here's the innodb status output during a problematic period. = 050421 15:29:46 INNODB MONITOR OUTPUT

User Variables

I'm having trouble using user variables and I hope someone can help, My test environment is MySQL 4.1.11 on WindowsXP with MyODBC 3.51.11 If I open a command line client, I can do this mysql> SET @A='Test'; Query OK, 0 rows affected (0.00 sec) mysql> Select @A; +--+ | @A | +--+ | Te

MySQL to XML

Hi list, does it possible for MySQL to generate XML in the followin format: This XML is the structure of the ServiceType table, I'll hope that you can help me Thnx in advanced Greetings P.S. Any suggestions (tools) will be appreciated -- MySQL General Mail

Re: Why is this table lock?

Reto Breitenmoser wrote: Hi In the output from the show innodb monitor I can see, that I have a table lock on a table. But, I never set a table lock on a table (only row locks). Do I misinterpret the output or what causes this table lock? thanks Reto TRANSACTIONS Trx

MySQL and FreeBSD instability

We've been using mysql version 4.7 on a FreeBSD 4.10 machine for the past few months, and while we've been putting a lot of load onto the DB, it's been stable. This past weekend, our sysadmin updated FreeBSD from 4.10 to 4.11, at which point mysql began having serious problems. The DB itself is fin

Re: innodb, optimizer and outer join

Boyd, You can tell Hibernate not to use outer-joins by setting hibernate.use_outer_join to false in the hibernate configuration properties file. It's an always-never proposition. Of course, you can code your own queries using the Hibernate Query object to write your own when you know you do ne

mysql_fix_privilege_tables error

Would it be possible to add: ENGINE=MyISAM To all the CREATE TABLE statements in the mysql_fix_privilege_tables script? The server (tested with 5.0.3 and 5.0.4) crashes when creating/altering these tables if the following is in /etc/my.cnf: default-table-type=innodb I had to drop all the new

Re: concat multirow subselect

Michael Stassen wrote: Stano Paska wrote: Hi, it is possible to ? I have two tables. create table aaa (id int auto_increment not null, title varchar(255), primary key (id)); create table bbb (id int auto_increment not null, fk_aaa int not null, detail varchar(255), primary key (id)); insert into

Re: concat multirow subselect

Stano Paska wrote: Hi, it is possible to ? I have two tables. create table aaa (id int auto_increment not null, title varchar(255), primary key (id)); create table bbb (id int auto_increment not null, fk_aaa int not null, detail varchar(255), primary key (id)); insert into aaa values (1, 'aaa'),

concat multirow subselect

Hi, it is possible to ? I have two tables. create table aaa (id int auto_increment not null, title varchar(255), primary key (id)); create table bbb (id int auto_increment not null, fk_aaa int not null, detail varchar(255), primary key (id)); insert into aaa values (1, 'aaa'), (2, 'bbb'); insert

Re: 4.0 -> 4.1 update killed my db!

MySql creates a directory for each version and a symbolic link to the new installed version. If you open the terminal and do a: ls -l /usr/local/ there should be the old releases, the new one and a symbolic link 'mysql'. Look at the data directory in the old release directory; if you find your ta

Re: Mygrating from 3.23 to 4.1

Mário Gamito wrote: Hi, For years i've been using MySQL 3.23, but now that i'm about to reinstall my company's web server, i've decided that it's time to go to 4.1 I've read quite a few things in the web about migrating the databases, *including the mysql one*, but each article i read, pointed me i

UTF-8 problems in text fields

MySQL: 4.1.11 OS: Solaris I have a database that stores Japanese in utf-8. I have NO problems if the field is defined as VARCHAR, but if the field is defined as TEXT any data after an extended character (Japanese, special symbols etc.) gets truncated. Looking at the archives I ran the followin

Re: ERROR 2005

Hello. MySQL CC is no longer under development and could have unfixed bugs. However, usually it works for me. What did you do? Were you trying to connect to host 'abc'? Ercilio Almeida <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 8bit, charset: iso-8859-1, 10 lines --] > >

Re: crushed innodb table

Hello. Tools for MyISAM tables won't help you with InnoDB. See: http://dev.mysql.com/doc/mysql/en/gone-away.html iv <[EMAIL PROTECTED]> wrote: > hi > I've got a problem with a crushed innodb table (as i think) > > When I'm trying to make a backup, something like this appears

Re: LongText Warning

Hello. There's a similar bug: http://bugs.mysql.com/bug.php?id=7654 But it was closed due to absence of feedback. You may reopen this bug. Check this field has the correct encoding. [EMAIL PROTECTED] wrote: > I have a table with a field that has a field of type LONGTEXT. I try

Re: 4.0 -> 4.1 update killed my db!

Hello. What type of tables do you use? I haven't heard about significant changes in MyISAM format. For InnoDB you should check the manual about incompatible changes. If nothing helps I suggest you to upgrade using mysqldump. See: http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html

String of 150 queries fast locally, but takes much longer accross cross connect

Hello, We are running FreeBSD on two Dual 2.5GHZ Xeon's each with 2 gigs of ram. One is our web server and the other our mySQL database server. The machines are connected directly with a cross connect cable. We are seeing transfer speeds of 8mb/s with scp between the two of them. Also, pinging is

RE: Query Problem

Ok, Thanks for all Roger. -Mensaje original- De: Roger Baklund [mailto:[EMAIL PROTECTED] Enviado el: viernes, 22 de abril de 2005 4:06 Para: Dto. Sistemas de Unitel CC: mysql@lists.mysql.com Asunto: Re: Query Problem Dto. Sistemas de Unitel wrote: > You don't understand me, I refer that