From: "Ed Reed"
> Is there way to return the ordinal position of a value within a table?
>
> Let's say I have a table of phone numbers. Over time the table has had
additions and deletions. The table has an autonumber ID field. If I sort by
the ID field I'd like to know what position the number '55
In the last episode (Jun 17), Ed Reed said:
> Is there way to return the ordinal position of a value within a table?
>
> Let's say I have a table of phone numbers. Over time the table has
> had additions and deletions. The table has an autonumber ID field. If
> I sort by the ID field I'd like to
So I am attempting a 5.0 upgrade from 4.1 on one of our OS X servers...
When attempting to launch mysqld it quits, with this error (showing
two from the log files, happens with our build or the MySQL binary):
050617 14:03:46 mysqld started
/usr/local/mysql-standard-5.0.7-beta-osx10.3-powerp
Thanks for the reply.
What do you mean by 'self join'?
>>> Eric Bergen <[EMAIL PROTECTED]> 6/17/05 4:39:28 PM >>>
Could you accomplish this with an update and self join?
Ed Reed wrote:
>Sorry, I thought it was easy to understand.
>
>I wanna update a field in a table with a value from the s
Thanks
>>> <[EMAIL PROTECTED]> 6/17/05 2:03:02 PM >>>
Hi,
There is one caveat: It is not currently possible to modify a table and select
from the same table in a subquery.
this phrase is from
http://dev.mysql.com/tech-resources/articles/4.1/subqueries.html
solution
*
create table t as S
Is there way to return the ordinal position of a value within a table?
Let's say I have a table of phone numbers. Over time the table has had
additions and deletions. The table has an autonumber ID field. If I sort by the
ID field I'd like to know what position the number '555-1212' is in the t
Could you accomplish this with an update and self join?
Ed Reed wrote:
Sorry, I thought it was easy to understand.
I wanna update a field in a table with a value from the same field but from a different record of the same table.
For example, using the query in my original message,
+
pretty interesting. i'll test it for oracle. But the db_cache will be a simple
swap file. i don't think it's as good as real memory for dirty lists
management.
Mathias
Selon David Griffiths <[EMAIL PROTECTED]>:
>
> I'll post something I heard about when looking into upgrading Oracle 8i
> from Wi
Sorry, I thought it was easy to understand.
I wanna update a field in a table with a value from the same field but from a
different record of the same table.
For example, using the query in my original message,
+--+
|RecID |FIELD1 |FIELD2 |
+---
Hi,
i don't think so. 2 go is a limit of almsot 32-bits plateform, linux or others.
Migrate to 64-bits.
Mathias
Selon Brady Brown <[EMAIL PROTECTED]>:
> Have any of you MySQL/FreeBSD cats successfully set
> innodb_buffer_pool_size > 2G without runing into any of the memory
> allocation problems
Hi,
There is one caveat: It is not currently possible to modify a table and select
from the same table in a subquery.
this phrase is from
http://dev.mysql.com/tech-resources/articles/4.1/subqueries.html
solution
*
create table t as Select field1 From table1 Where field2="Some
Value"
Upda
We use MySQL-Front from Star-Tools GmbH (www.mysqlfront.de)... works pretty
much like you have asked.
Thanks,
Car
- Original Message -
From: "Berman, Mikhail" <[EMAIL PROTECTED]>
To:
Cc: "D_C" <[EMAIL PROTECTED]>
Sent: Friday, June 17, 2005 4:36 PM
Subject: RE: simple data GUI editor?
Well,
Actually MS-Access through ODBC should work for you
-Original Message-
From: D_C [mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 4:28 PM
To: mysql@lists.mysql.com
Subject: simple data GUI editor?
i was wondering if people can recommend a simple Excel like tool for
editing
i was wondering if people can recommend a simple Excel like tool for
editing data?
MySql control center - seems to have limitations (unicode, not in dev
anymore)
Query browser - have to type raw sql to show/hide columns...
ideally i want something with a few more features than either of these,
e
I'll post something I heard about when looking into upgrading Oracle 8i
from Windows to Oracle 10g on Linux.
To get more memory for the process, you would enable big memory page,
and then create an in-memory temp file system; you could then allocate
extra memory for a process, and part of it
On 6/16/05, Gabriel B. <[EMAIL PROTECTED]> wrote:
> If i have a table with about 800M records. and one of the fields is a
> enum("a", "b", "c") and i want to change it to enum("a","b","x")
My understanding (such as it is) is that the best way to do this is to add a
second column with enum('a','b
On Friday 17 June 2005 02:38 pm, Brady Brown wrote:
> Have any of you MySQL/FreeBSD cats successfully set
> innodb_buffer_pool_size > 2G without runing into any of the memory
> allocation problems found on Linux platforms?
It has nothing to do with linux.. its an x86 thing.. So no..
However, so
Have any of you MySQL/FreeBSD cats successfully set
innodb_buffer_pool_size > 2G without runing into any of the memory
allocation problems found on Linux platforms?
Although I have been given good advice to migrate to an AMD platform
overcome this limitation (and will do so eventually), I am l
probably biased towards AMD.
money is a powerful thing, which is why it should be taken with a grain
of salt as you stated.
i would guess the 12% decrease on 64bit xeon and 32% increase on 64bit
opteron is BS. why didn't they try itanium instead? ;)
David Griffiths wrote:
Anandtech has an in
On 18/06/2005, at 4:28 AM, David Griffiths wrote:
Anandtech has an interesting article
(http://www.anandtech.com/IT/showdoc.aspx?i=2447) on hardware for
Linux database servers.
Some very interesting conclusions:
1) Moving to 64-bit MySQL on a 64-bit Xeon actually decreases
performance by a
Anandtech has an interesting article
(http://www.anandtech.com/IT/showdoc.aspx?i=2447) on hardware for Linux
database servers.
Some very interesting conclusions:
1) Moving to 64-bit MySQL on a 64-bit Xeon actually decreases
performance by about 12% on average, while an Opteron running 64-bit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
asteddy wrote:
> Thank you, but why has mysql made seminars wich must be seen with a non-free
> software with a 14 days trial? Is there nothing else to see it?
> Asteddy
Asteddy,
I would guess because nothing "free" has the functionality and
ease-o
asteddy wrote:
Thank you, but why has mysql made seminars wich must be seen with a non-free software with a 14 days trial? Is there nothing else to see it?
Asteddy
We haven't :)
You can download a free player at:
http://www.webex.com/customercare/downloads-player.html
This is not a trial
There are 3 things [that are exclusivly MyISAM}.
Full Text index
autoincrement column as the last column in a multi column primary key
MERGE tables
Tables which don't require these features can be INNODB tables. We have
a few tables that use these, otherwise we are exclusively INNODB.
There is
"Ed Reed" <[EMAIL PROTECTED]> wrote on 06/17/2005 01:35:40 PM:
> Can anyone tell me how I can make this work or suggest a work around?
> Update table1 Set field1=(Select field1 From table1 Where field2="Some
Value")
> Where field2 ="Another Value";
> Thanks
OK, your example must be broken (or
>
> -Original Message-
> From: Scott Plumlee [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 17, 2005 10:21 AM
> To: mysql@lists.mysql.com
> Subject: Backup database with MyISAM and InnoDB tables together
>
> I'm not clear on best practice to use on a database containing both
> MyISAM and I
Can anyone tell me how I can make this work or suggest a work around?
Update table1 Set field1=(Select field1 From table1 Where field2="Some Value")
Where field2 ="Another Value";
Thanks
On 6/17/05, asteddy <[EMAIL PROTECTED]> wrote:
> Hello,
> I have found Mysql Performance Tuning Seminar available for download, but I
> don't know how to see it.
Use the WebEx player at http://www.meetingcenter.net/record_play.htm
-JP
--
MySQL General Mailing List
For list archives: http://lis
Hi list,
I have the following error in a MySQL server:
050617 09:16:35 mysqld started
InnoDB: Error: tablespace size stored in header is 8660992 pages, but
InnoDB: the sum of data file sizes is only 6432768 pages
050617 9:16:40 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections
And
Can anyone help, please, when I tar -xvzf this file I am getting the error
"Archive contains obsolescent base-64 headers
gzip: stdin: invalid compressed data--crc error"
and installation exits
I tried to acquire the Compaq compilers mentioned under "platforms" in case
it is a gcc problem, but th
Hi,
I was wondering if there's a way to make mysql not care about (or
ignore) columns in an insert statement that don't exist in the table.
For example, I have a dump from a table with 10 columns, but the new
table has one of the columns dropped.. well restoring from the dump
causes errors.
If you are runing binary log and do a
FLUSH LOGS
mysqldump --opt --skip-lock-tables MyISAM table names
FLUSH LOGS
mysqldump --opt --single-transaction INNODB table names
You have a recoverable state with the combination of the mysqldump file
and the binary log file that was started by the 1st
Mysql seminar organizer's should answer.
Mathias
Selon asteddy <[EMAIL PROTECTED]>:
> Thank you, but why has mysql made seminars wich must be seen with a non-free
> software with a 14 days trial? Is there nothing else to see it?
> Asteddy
>
> >Hi,
> >there is link "take the free trial" on webex
Thank you, but why has mysql made seminars wich must be seen with a non-free
software with a 14 days trial? Is there nothing else to see it?
Asteddy
>Hi,
>there is link "take the free trial" on webex site. haven't you seen the seconf
>button ?
>
>Mathias
>
>Selon asteddy <[EMAIL PROTECTED]>:
>
>
I'm not clear on best practice to use on a database containing both
MyISAM and InnoDB tables. For the MyISAM tables, it seems better to use
mysqldump --opt, thus getting the --lock-tables option, but for the
InnoDB the --single-transaction is preferred. Since they are mutually
exclusive, is t
Hello.
SQL 99 allows action Granularity FOR EACH STATEMENT, and it is default.
But FOR EACH ROW is more common and it seems MySQL supports only second.
When Granualarity FOR EACH STATEMENT trigger action occurs only once, when
FOR EACH ROW - once for each row (3 times in your case).
P
Hi,
there is link "take the free trial" on webex site. haven't you seen the seconf
button ?
Mathias
Selon asteddy <[EMAIL PROTECTED]>:
> Hello,
> I have found Mysql Performance Tuning Seminar available for download, but I
> don't know how to see it. I have found something like Webex website, but
Hello,
I have found Mysql Performance Tuning Seminar available for download, but I
don't know how to see it. I have found something like Webex website, but I
don't see any software to download there. Can you help me please?
Why is there nothing specified about that type of file on the download p
Hi,
One of our servers has a 30GB+ ibdata1 file. We just switched on per
table tablespaces and have begun moving tables out into their own files.
But I still need to reduce the 30GB+ down to a more reasonable level to
free up disk space. This is essential.
The only references I can find for
If that works for MySQL, the official documentation doesn't show it:
http://dev.mysql.com/doc/mysql/en/create-trigger.html
I don't have a copy of the 5.0+ source or I could check the
sql/sql_yacc.yy file to see if the syntax is supported. Anyone else able
to help out here?
Shawn Green
Database
yes there is :
http://www.postgresql.org/docs/7.4/interactive/sql-createtrigger.html
FOR EACH ROW
FOR EACH STATEMENT
This specifies whether the trigger procedure should be fired once
for every row affected by the trigger event, or just once per SQL
statement. If neither is specified, F
Hi,
the syntax for creating a triggers is :
CREATE TRIGGER trigger_name trigger_time trigger_event
ON tbl_name FOR EACH ROW trigger_stmt
Is there any other possibilities than "FOR EACH ROW" ?
If I do :
CREATE TABLE test(foo varchar(5));
CREATE TRIGGER trigger_name AFTER INSERT
ON test FO
"'Yemi Obembe" <[EMAIL PROTECTED]> wrote on 17/06/2005 09:40:39:
> Hi all,
> just want to know if there is a specific number of concorent users
> dat can query from a mysql databasee at d same time.
MySQL has a configurable limit to the number of simultaneous connections
that it can support. Se
Hi all,
just want to know if there is a specific number of concorent users dat can
query from a mysql databasee at d same time.
-
A passion till tomorrow,
Opeyemi Obembe | ng.clawz.com
-
Yahoo! Sports
Rekind
Hello.
MySQL on 64-bit AMD rises lots of questions. There is an Opteron HOWTO
at:
http://hashmysql.org/index.php?title=Opteron_HOWTO
I can't give any advice except sending to the list the output of SHOW
STATUS and SHOW PROCESSLIST statements performed when MySQL uses a lot
of memory.
Hello.
Putting this variables into configuration file works for me. Have you
tried slave_net_timeout? Please send the output of SHOW SLAVE STATUS
statement.
[EMAIL PROTECTED] wrote:
> Hallo
> I have some problems loading data from Master. I am using the circular
> replication procedur
Hello.
See:
http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html
Miguel Burgos O. wrote:
> I install the last version of mysql and got this
>
> $mysqlhotcopy test
> File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
>
> What happened ?
>
> Best r
huang leo 写道:
> hi,everyone,
> I just did a test to find out the MySQL4.1.12 max connections on
> FreeBSD 5.4 Release and FreeBSD 4.11 Release. The first test, the
> MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because I have 1GB
> memory. The second test, I setted the MAXSSIZ=1GB, and the MAXDSIZ
hi,everyone,
I just did a test to find out the MySQL4.1.12 max connections on FreeBSD
5.4 Release and FreeBSD 4.11 Release.
The first test, the MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because
I have 1GB memory. The second test, I setted the MAXSSIZ=1GB, and the
MAXDSIZ is also 1GB. The
49 matches
Mail list logo
