Re: No of columns in a table

Hi, As of our understanding, The maximum number of columns for any storage storage engine depends upon the option "AVG_ROW_LENGTH". If you length of the column name is large, then no of columns will be less and obviously vice-versa also holds true. The options MAX_ROWS * AVG_ROW_LENGTH will

Re: before update trigger syntax

Hi Try with mysql> delimiter // mysql> CREATE TRIGGER eat_lub BEFORE UPDATE ON d -> FOR EACH ROW BEGIN -> UPDATE d SET NEW.s=user(); -> END// Query OK, 0 rows affected (0.03 sec) mysql> delimiter ; Hope this helps. Thanks, ViSolve DB Team - Original Message - From: "Ted Yu

Re: username audit column

In the last episode (Nov 29), Ted Yu said: > By username I mean Linux login. Is there a way to call Perl/Shell > script to obtain this information ? Won't work for remote users, of course. If you were on *BSD, AIX, or Solaris you could write a UDF that called the getpeereid() or getpeerucred() li

before update trigger syntax

Can someone tell me what's wrong with my before update trigger syntax ? Thanks Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 5.0.18-log mysql> use eventtracker; Reading table information for completion of table and column names You ca

Re: username audit column

By username I mean Linux login. Is there a way to call Perl/Shell script to obtain this information ? --- Ted Yu <[EMAIL PROTECTED]> wrote: > Has any MySQL user established triggers to fill out > the audit columns (such as CREATED_BY - username > that > performs the underlying operation) ? > > T

Re: DROP DATABASE weirdness

Yeah, that is the bug exactly. I can't even get 5.0.27 to start it comes up with the exact same error. Maybe if I get rid of the SSL option but this sucks! Thanks for the help Logan, David (SST - Adelaide) wrote: Hi Bruce, Have a squiz here http://bugs.mysql.com/bug.php?id=16586 sounds sus

RE: DROP DATABASE weirdness

Hi Bruce, Have a squiz here http://bugs.mysql.com/bug.php?id=16586 sounds suspiciously like your issue. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_

Re: DROP DATABASE weirdness

Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't seem to have them got glib23 anymore. Suggestions? Bruce Ferrell wrote: I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3. Trying a static build now. Anyone wanna bet? :) Bruce Ferrell wrote:

username audit column

Has any MySQL user established triggers to fill out the audit columns (such as CREATED_BY - username that performs the underlying operation) ? Thanks Want to start your own business? Learn how on Yahoo! Small

Re: DROP DATABASE weirdness

I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3. Trying a static build now. Anyone wanna bet? :) Bruce Ferrell wrote: Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec fi

Re: DROP DATABASE weirdness

Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec file Logan, David (SST - Adelaide) wrote: Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself?

RE: DROP DATABASE weirdness

Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *

Re: DROP DATABASE weirdness

I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards --- *

RE: DROP DATABASE weirdness

Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd *

DROP DATABASE weirdness

I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that'

RE: Any explanation for this, please

Thank you Mikhail Berman -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 3:30 PM To: Mikhail Berman; mysql@lists.mysql.com Subject: RE: Any explanation for this, please At 14:41 -0500 11/29/06, Mikhail Berman wrote: >Thank you, Sir. >

RE: Any explanation for this, please

At 14:41 -0500 11/29/06, Mikhail Berman wrote: Thank you, Sir. So, there is no way to plan update query? Not except in the sense of getting a plan for a similar SELECT statement. Regards, Mikhail Berman -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesda

RE: Any explanation for this, please

Thank you, Sir. So, there is no way to plan update query? Regards, Mikhail Berman -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 2:37 PM To: Mikhail Berman; mysql@lists.mysql.com Subject: Re: Any explanation for this, please At 14:31

Re: Any explanation for this, please

On Wed, 2006-11-29 at 14:31 -0500, Mikhail Berman wrote: > Dear List, > > Could I get an explanation why 1 fails, but 2 works. > > 1. Update statement preceded with explain, fails: > > explain update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES > t on c.ticker = t.TickerSymbol an

Re: Any explanation for this, please

At 14:31 -0500 11/29/06, Mikhail Berman wrote: Dear List, Could I get an explanation why 1 fails, but 2 works. Because EXPLAIN is used only with SELECT statements. Try to use a similar SELECT. 1. Update statement preceded with explain, fails: explain update COMPANY_NUMBERS_tmp_Mikhail c

Any explanation for this, please

Dear List, Could I get an explanation why 1 fails, but 2 works. 1. Update statement preceded with explain, fails: explain update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES t on c.ticker = t.TickerSymbol and t.InterimEndingDate = replace(left(c.date_qtr,7),'-','/') set c.total

List-Unsubscribe

List-Unsubscribe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqldump --compatible=mysql40 Bugs?

Hallo ich habe eine mysql 5 Datenbank so extrahiert (für den Import in eine mysql 4 Datenbank): mysqldump -h localhost -p -u mareb --compatible=mysql40 mydatabase >mydatabase.sql Im SQL-Script fehlt dann die Angabe "auto_increment" - mit fatalen Folgen. Wenn ich mysqldump -h localhost -p -

Re: MySQL Cookbook, second edition, now available

At 8:45 -0600 11/29/06, [EMAIL PROTECTED] wrote: > The second edition of MySQL Cookbook (O'Reilly, 2006) is now available. The second edition brings the recipes up to date for MySQL 5.0/5.1. For example, it covers views, stored routines, triggers, and events. The second edition also adds co

using SSL certificates when connecting to mysqld

Hi. mysql --version mysql Ver 14.7 Distrib 4.1.21, for pc-linux-gnu (i686) using readline 5.1 I'm trying to secure a replication connection between a master and a slave. However, seems to me that the issue I'm facing relates to any SSL client<->server connection, so the scenario I'll be specifyi

Re: MySQL Cookbook, second edition, now available

> The second edition of MySQL Cookbook (O'Reilly, 2006) is now available. > The second edition brings the recipes up to date for MySQL 5.0/5.1. For > example, it covers views, stored routines, triggers, and events. The > second edition also adds coverage for Ruby (using the Ruby DBI module). > Mo

Logging aborted_connects to error log instead of gen. log

It is noted in http://dev.mysql.com/doc/refman/4.1/en/communication-errors.html: The server increments the |Aborted_connects| status variable when the following things happen: * A client doesn't have privileges to connect to a database. * A client uses an incorrect password

ANN: Advanced Data Generator 2.0 released

e on: http://www.upscene.com/purchase.htm#adg More information available here: http://www.upscene.com/news/20061129.htm With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.co

No of columns in a table

I need information for Maximum no. of columns in a table in MySQL with diff. engines. Where can I get it? Thanks and regards, CPK

replacing characters

Hi I have to move the date to one DB to another by live, so i wrote a Java program which will read the data from Sourse DB, and make the data as a Strings which nothing but insert statements with data. I simply add these as a batch and fire them to destination. Everything is fine, if simple data

lost connection to MySQL server during qu ery

i've done a non-stop insert test for 3 days, using mysql++ to connect to MySQL server i only use one connection, if it fails to execute ,it will reconnect during this test , this exception came out twice is that because of the server or the client?

Re: InnoDB Transaction and LAST_INSERT_ID()

Mike Kruckenberg wrote: mysql> SET @staff_id = LAST_INSERT_ID(); Query OK, 0 rows affected (0.01 sec) I don't know if this behaviour has changed in later versions of mysql, but using session variables, although lovely, was the quickest way to break replication (at least up to and including 4.