Hi All,
I can't seem to find any documentation or opinions that would help me decide
if it is better to run mysqld-max-nt over the non-max server.
Opinions and pointers to supporting docs would be very welcome (especially
pointer to docs).
Thanks to All in advance.
Allen
Does MySQL support update from other table?
I run this query and get error:
UPDATE TableA SET Division=TableB.Division
FROM TableB
WHERE TableA.Code=TableB.Code
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Hi Mike,
Simple; you don't. :-) Someone please correct me if I'm wrong.
BTW, this isn't a Windows specific question, so I'm sending it to the
General list too.
Regards,
Matt
- Original Message -
From: "Mike Karplus"
Sent: Friday, October 24, 2003 5:04 PM
Subject: selecting from two di
Hi,
I've just installed MySQL on my PC but do not know which program to access
in order to use it. Does anyone knows ?
Regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jeremy, Prasad,
> On Mon, Oct 13, 2003 at 11:45:33PM -0600, Prasad Budim Ram wrote:
>> Is it possible to direct xml support for queryiing a SQL statement and
>> get the result in also in xml?
> Nope.
At least, you can start the MySQL client program with an option so
that it outputs XML:
shell>
Hi:
I am current measuring the performance of mysql. Is there a way of getting
memory consumed by mysql to process a query? Any suggestion is
highly aprreciated.
Best Regards
Chuang
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
oops, I found what was my mistake. I copied and paste a line to write the
command for you but I forgot to remove CASE :) so write your query like
this:
SELECT
CASE WHEN status IN('BR', 'VQ', 'RQ', 'NG' )
THEN
'binding'
WHEN status IN('NA', 'NG', 'RA')
END as action
FROM master_info WHERE
(( stat
> I didn't have your table so I tried to write the same command by one of my
> tables. my query which worked, is:
> SELECT CASE WHEN left( workorder, 1 )
> IN ( 'C', 'T' )
> THEN 'group1'
> WHEN left( workorder, 1 )
> IN ( '3', 'R' )
> THEN 'gorup2'
> ELSE
> 'group3'
> END FROM workfile;
I didn't have your table so I tried to write the same command by one of my
tables. my query which worked, is:
SELECT CASE WHEN left( workorder, 1 )
IN ( 'C', 'T' )
THEN 'group1'
WHEN left( workorder, 1 )
IN ( '3', 'R' )
THEN 'gorup2'
ELSE
'group3'
END FROM workfile;
- Original Mes
OS/FileSystem INODE limitation.
How many files can fit into a directory? 64K on Redhat if you modify
file-max
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: [EMAIL PROTECTED] [mailt
> SELECT
> CASE WHEN status IN('BR', 'VQ', 'RQ', 'NG' )
> THEN
> 'binding'
> CASE WHEN status IN('NA', 'NG', 'RA')
> END as action
> FROM master_info WHERE
> (( status IN ( 'BR', 'VQ', 'RQ', 'NG' )) OR
> ( status IN ( 'NA', 'NG', 'RA' )));
Sadly, that didn't work:
Your MySQL connection id is 2085
Does anyone know of any limitations on the number of underlying tables in a MERGE
table? Seems to be a topic of scant coverage in the books and online docs.
ANY help or ideas would be appreciated.
/Tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
*** 1. row ***
Master_Host: 10.2.12.224
Master_User: rep
Master_Port: 3306
Connect_retry: 60
Master_Log_File: ef224-bin.020
Read_Master_Log_Pos: 409223612
Relay_Log_File: ef242-relay-bin.016
Hector,
I migrated from Visual FoxPro too. VFP has different style to work with a
table. MySQL gives you some advantage which you don't have it in VFP. for
example, try to connect to the work server from home and run this query. it
will take 5 days to finish it, but still MySQL takes 3 min.s :)
SELECT
CASE WHEN status IN('BR', 'VQ', 'RQ', 'NG' )
THEN
'binding'
CASE WHEN status IN('NA', 'NG', 'RA')
END as action
FROM master_info WHERE
(( status IN ( 'BR', 'VQ', 'RQ', 'NG' )) OR
( status IN ( 'NA', 'NG', 'RA' )));
- Original Message -
From: "Chris Boget" <[EMAIL PROTECTED]>
To: "
Hi Hector,
Umm, it looks like you're simply doing a SELECT in the first query and
*populating a new table* in the second. Of course inserting 3.3 million
rows is going to take extra time! How can you even compare the 2 when
they're doing different things?
Matt
- Original Message -
From
As you are selecting all records (no where clause), it will scan the whole table every
time, I believe...
does anyone know if he added the other columns to his index, or had 4 seperate indexes
(one per column) would they be used in this operation?
>
> Ok, I've found the optimization chapter i
Dan Greene wrote:
Indexes are your friend. Perhaps your best friend (as far as databases go)
---
To give light on your question... you can index any field... if the entries are
distinct, it's called a 'unique index' which are the best kind to use. Otherwise you
have
Hi
We are pleased to announce the release of Rekall V2.1.0 stable for Linux and
Windows
Please note, the stable release of Rekall V2.1.0 is only available from
either http://www.totalrekall.co.uk and http://www.rygannon.com
What is Rekall?
Rekall is a programmable (using Python), database indepe
Error 'Can't create symlink './ffadult_recent/#sql-44b_e87.MYI' pointing
at '/var/lib/mysql/ff_recent/#sql-44b_e87.MYI' (Error 17)' on query
'ALTER TABLE recentmembers_8 add have_children tinyint unsigned not NULL
default 0'. Default database: 'ff_recent' | 0| 346296822
| 369493795
I've searched the archives and was unable to find anything that seemed
pertinent.
Earlier today I had to stop and start mysql. When I issued mysqladmin
shutdown, however, the process did not die cleanly (reason unknown), and I
ended up having to kill -9 mysqld and mysqld_safe.
When the DB came
I'm trying to do something like the following:
SELECT
CASE status
WHEN
IN ( 'BR', 'VQ', 'RQ', 'NG' )
THEN
'binding'
WHEN
IN ( 'NA', 'NG', 'RA' )
THEN
'approving'
END as action
FROM master_info WHERE
(( status IN ( 'BR', 'VQ', 'RQ', 'NG' )) OR
( status IN ( 'NA', 'NG', 'RA' )));
But this quer
First of all, you query is not correct and this is not a subselect query.
you can try this:
SELECT Salary, Level, Department FROM SalaryInfo ORDER BY Salary DESC LIMIT
1;
second of all, for subselect MySQL 4.1 can help you.
Mojtaba
- Original Message -
From: "Prashant Pai" <[EMAIL PROT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi guys , I'm sorry for this very OT post , but i guess that someone
in the list can help me . I've made contact with a sales representant of
mysql to purchase a mysql support contract , but the communication seems
to be a little slow ( my company is
I am working on a mysql-based search facility. In order to search for
connected phrases, it would be very convenient to have a "subtable"
structure to express a set of rows in which only one small column changes.
If I didn't have to worry about space, I might have a table like this:
create table
I am working on a Veritas backup solution where the data can exist on a
remote file system and the snapshot exist elsewhere. This could be used
in theory to attain your goal, with some additional code.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://fr
There is a project that was started to do this though. Do a google
search, on master thesis XML and MYSQL. Maybe they have some code that
can be contributed or you can use for a private branch.
In the mean time it's easy to generate XML on a simple DTD in side your
code.
- Dathan Vance Pattishall
www.cpan.org
or
www.rpmfind.net comes in a package.
Most perl distributions have this installed by default.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Daniel [mailto:[EMAIL PRO
You probably want to restructure your tables (if that's an option)
if it's a heirachal menu system (one parent only), then you'll need to put a
parent_id column, and then map each child to the parent.
then once you have your parent menu (158), you select * from menus where parent_id =
158
If
Hey all,
are people using mysql 4.1.0 of 4.1.1 on production servers yet, or should we
wait for a more stable release?
i know this is somewhat subjective to the use.
I have a major upgrade to my database system coming soon, and i want to
coordinate it with my server upgrade, so im trying to fig
hi Jeremy , thanks (again, tell me if it's to much=) for helping me.
i've got to admit here that i'm reaching the maximum of my linux skills.
i've used top,free,iostat and sar , without finding the answers i need.
for instance , on the master (dual P3 1Ghz , 1G ram, running only mysql,
with 353M
I have a table (menus) with the following fields:
TABLE: MENUS
id int(11)
url varchar(100)
items varchar(35)
An example row:
ID URL ITEMS
158 programs/graduate 21,22,23,24,25,26,27,28,160
I want to select the ITEMS and then do another sub
Hi,
I have a table SalaryInfo as below
Salary | Department | Level
50 | R&D| Director
3 | Maintenance| Groundsman
...
I want to know what level in each department makes the highest salary
and how much that salary is? Something like:
SELECT Salary, Level, Department FROM Sal
Indexes are your friend. Perhaps your best friend (as far as databases go)
---
To give light on your question... you can index any field... if the entries are
distinct, it's called a 'unique index' which are the best kind to use. Otherwise you
have a 'non-unique ind
Hi!
One thing that you have to remember is that FoxPro will always index
some fields, while MySQL
will only ever index the primary key field automatically.
Indexes can be on fields that are distinct or not distinct. The only
difference that exists is
the nature of the index, which is one of tho
Chris Nolan wrote:
Hi!
Given VFP's internals (I have to support FoxPro 2.6 apps, oh the pain
of it all!),
MySQL should be capable of much better performance, considering the
only thing FoxPro has in terms of a possible advantage is Rushmore.
Which indexes do you have on the tables in the query?
Hi!
Given VFP's internals (I have to support FoxPro 2.6 apps, oh the pain of
it all!),
MySQL should be capable of much better performance, considering the
only thing FoxPro has in terms of a possible advantage is Rushmore.
Which indexes do you have on the tables in the query?
Regards,
Chris
H
Hi all,
I'm migrating from Visual FoxPro (I'm a newbie).
On a daily basis I need to run this query on a table with a little more
than
5 million records.
+ MS Visual FoxPro 6.0
select tel, telefb, rutaentran, rutasalien, sum(minutos) as minutos from
traf_oper
group by 1, 2, 3, 4 into table ope
* [EMAIL PROTECTED]
[...]
>ERROR 1016: Can't open file: 'new_master.MRG'. (errno: 143)
>
> All table structures are identical.
Maybe not..? :)
> Am I missing a basic error numbers page in the online docs? I've found a
> few, but nothing comprehensive, like a page where I can enter an
> error
Simon Gentile <[EMAIL PROTECTED]> wrote:
> in version 4.1 states it supports subqueries like
>
> SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM
> t2);
>
> it doesn't support 'IN'
>
> [Dissertation] ERROR 1235: This version of MySQL
> doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
Hi Chris,
> I'm not the almighty Heikki, but I might be able to fill you in to some
> extent.
:-)
> Your first and third questions I cannot answer with certainty, but I'm
> pretty
> sure the answer is "no". Regarding the first one, I'm not too sure as to
> why you'd need
> it. Looking at the out
Heikki,
Thanks for clarifying, and as you see, I'm new to MySQL (came from Oracle).
I'll read all the docs first (I'm doing it right now). ;)
We're evaluating MySQL (InnoDB) on NetWare65, we'll move all our Oracle
servers (also, on NetWare) to it, and then start testing.
Currently we have only
Hi!
I'm not the almighty Heikki, but I might be able to fill you in to some
extent.
Your first and third questions I cannot answer with certainty, but I'm
pretty
sure the answer is "no". Regarding the first one, I'm not too sure as to
why you'd need
it. Looking at the output of SHOW VARIABLES
Eduardo,
- Alkuperäinen viesti -
Lähettäjä: "Eduardo D Piovesam" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Lähetetty: Friday, October 24, 2003 6:17 PM
Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
> Hello Heikki, thanks
Hello Heikki, thanks for your reply.
It was just my curiosity, with the MyISAM concept it's good for the OS,
because it'll cache only the tables most useds, and not "all" the tablespace
file.
And how to administer the multiple tablespace support? I'm worried in the
space unused by some tables, ex
> Use 'localhost' as the host unless you are specifying the
> grant to be
> for users on another machine.
> '%' stands for all machines except 'localhost'.
I know. And the is exactly what I want.
>
> Datatal AB - Gauffin, Jonas wrote:
>
> >I get access denied (from mysql.exe and myodbc) whe
Hi Heikki,
As you know - I'm a transaction zealot :-)
Is there a way to get a signal back to the client when a
transaction has started? Or perhaps something like
@@trancount in MSSQL?
Is there a way to turn ON/OFF auto-commit?
And, are metadata operations under transaction control?
With regar
Eduardo,
to make the user interface simple, I decided to take the table per file
approach. Each .ibd file is internally a 'tablespace'.
The simple approach I chose is similar to how MyISAM now works. I thought it
would be nice for current MySQL users.
In Oracle, one can store several tables into
Use 'localhost' as the host unless you are specifying the grant to be
for users on another machine.
'%' stands for all machines except 'localhost'.
Datatal AB - Gauffin, Jonas wrote:
I get access denied (from mysql.exe and myodbc) when specifying no host or % as host in the grant statement.
Chris,
1. Peter Zaitsev ran some tests which suggested that multiple .ibd files are
not slower than one ibdata file. But it will depend on the OS version. Some
OS'es may have bad fsync() implementation, which can cause slowdown with a
large number of files.
2. Clustering? If you mean the fact tha
All,
the VACUUM in PostgreSQL removes delete-marked records from the database.
In InnoDB, the VACUUM is called the purge. In InnoDB purge happens
automatically in the background, the user does not need to explicitly run
VACUUM, like in PostgreSQL. Also in Oracle purge is automatic.
The way to co
Chris,
for MyISAM and InnoDB, ALTER TABLE normally locks the table to be altered in
a read-only mode.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyI
Hi,
I have mysql 4.0 installed on redhat 9.0.I want to install mysql 4.1 and
keep 4.0 as it is.I get the follownig message whent I try to install 4.1
mysql_install_db : line 166:0:command not found.
Installing privilege tables
mysqld :ERROR :unknown option --log-bin # required for replication
I get access denied (from mysql.exe and myodbc) when specifying no host or % as host
in the grant statement.
> -Ursprungligt meddelande-
> Från: gerald_clark [mailto:[EMAIL PROTECTED]
> Skickat: den 24 oktober 2003 15:11
> Till: Datatal AB - Gauffin, Jonas
> Kopia: [EMAIL PROTECTED]
> Äm
You would be better off getting a good MySQL book, a good Perl book,
and a good Latex book.
Spend a week or two reading, try the examples in the books, and
integrate what you have learned.
Then ask questions.
You want a very specific answer to a question you can't even express yet.
Abner Gersh
Hi,
I've recently set up a new linux box and installed MySQL 4 (for the
record, Knoppix/Debian and the 'unstable' MySQL 4 package). I've had no
problems connecting using phpMyAdmin, but when I try to connect remotely
using MySQL Control Center or SQLyog (from Windows) I get the same error
(near en
What do you mean by ' doesn't work ' ?
Have you tried connecting from another machine?
Datatal AB - Gauffin, Jonas wrote:
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%'
IDENTIFIED BY ''; FLUSH PRIVILEGES;
yes. no diffrence. Specifying '%' or no host doesn't work for me.
--
MySQL
Error 143 suggests that you have conflicting table definitions.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 7:08 AM
To: [EMAIL PROTECTED]
Subject: MERGE tables error
I've created several merge tables from the command prompt. All se
I've created several merge tables from the command prompt. All seems well,
the .frm and .MRG files are created. The contents of the .MRG files are
accurate.
I flushed the tables (even restarted MySQL).
I can see the newly created merge tables, but when I try to run a DESCRIBE or
a SELECT
"Louie Miranda" <[EMAIL PROTECTED]> wrote:
> Hi, i have this form that goes directly.. to a database. I have some
> clients who dont use english. If they enter on a form a special
> russion or chinese character will mysql translate it properly?
If you use a Web form, you should try to transform t
Dale Hans <[EMAIL PROTECTED]> wrote:
> I have a field in the table, call it 'stuff', and it contains a list
> of values that are comma separated. i.e. 'Books,DVDs,Video
> Tapes,CDs'
>
> I want to SELECT out all records that have an item. I know IN works
> the other way, so is there something
"suwandy" <[EMAIL PROTECTED]> wrote:
>
> i'm currently learning mysql and interesting to
> constraint, relational and check function.
>
> could anyone give some example please ?
CHECK clause is parsed but it doesn't do anything.
Info about FOREIGN KEY CONSTRAINTS you can find at:
http:
Timotius Alfa <[EMAIL PROTECTED]> wrote:
>
> How to save binary files to mysql ? I want to save *.exe whole in a binary files,
> after that I want to save it to mysql. thanks
>
You can store binary data in the BLOB columns:
http://www.mysql.com/doc/en/BLOB.html
--
For technical sup
Hi!
On Oct 23, Matt W wrote:
> Hi Sergei,
>
> More full-text questions from me since I just noticed your code and doc
> changes. :-)
>
> What does this new WITH QUERY EXPANSION syntax do? More relevant
> results? More flexible? Faster? Is it for NLQ, boolean, or both (since
> both ft_[nlq | bool
I would like to announce the 2nd edition of
The Definitive Guide to MySQL
by Michael Kofler
apress 2004
The book covers many aspects of MySQL application development, including
- installation (Windows, Linux)
- GUIs (MySQL Control Center, phpMyAdmin)
- database design
- SQL
- security
- ad
David Ritter <[EMAIL PROTECTED]> wrote:
>
> I think I have found a bug in the MySQL 4.1.1 C Binding API with inserting
> NULL values using the bind API. Can someone please send me an address that
> I can send a test case to the MySQL development staff so they can take a
> look at it?
>
> Alterna
Dear list,
I currently have the task to write an adapter for MySQL (for SapDB as well
btw) that should track changes on certain tables.
I know that this question has been asked several times before but
unfortunately didn't find no suitable answer:
Is it possible to monitor/ audit changes in certai
On Mon, Oct 13, 2003 at 11:45:33PM -0600, Prasad Budim Ram wrote:
> Is it possible to direct xml support for queryiing a SQL statement and
> get the result in also in xml?
Nope.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
Hello :P
Only one question. A friend translated the 6 chapter of mysql manual to
spanish. And I want know if this translate is posible or have any
problem with the mysql licence or mysql manual licence.
The translate is here:
http://amauta.ourproject.org/contrib/
Well.
--
| .---. |
Hello!
I get this error from my MySQL-database:
Error: 1016 Can't open file: 'tablename.MYI.
(errno: 145).
I know what to do to fix this, but I need to know what causes this error.
If anyone know, please respond.
Best regards, Marius R
-
this should work:
select NAME, sum(if(IF_PURCHASED='true',COUNT,0)),
sum(if(IF_PURCHASED='false', COUNT,0)) from TABLENAME group by NAME;
eva
-Original Message-
From: cengiz "taţhan [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 9:29 AM
To: [EMAIL PROTECTED]
Subject: Can I do
Please help, where do I download DBI module binaries
thanks
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
Does anyone have a list of what affect ALTER TABLE has on each different type
of MySQL table?
If I have read correctly, ALTER TABLE locks MyISAM tables until completeion.
Am I right on this? How about InnoDB and BDB? If memory serves correctly,
HEAP doesn't support ALTER TABLE.
Regard
VACUUM is basically a workalike for:
ALTER TABLE TYPE=InnoDB;
There are various types of VACUUM commands as well. VACUUM FULL basically
locks the table and shrinks the on-disk table space. The normal "VACUUM"
(normal since 7.2 I think), does not lock the table (similar to REORGANISE
in some othe
Hi everybody;
I have a table like this;
|| NAME || IF_PURCHASED || COUNT ||
---
tom true5
tom false 7
tom false 3
sam true3
sam true4
sam false 2
Hi everybody;
I have a table like this;
|| NAME || IF_PURCHASED || COUNT ||
---
tom true5
tom false 7
tom false 3
sam true3
sam true4
sam false 2
On Thu, Oct 16, 2003 at 05:13:58PM -0300, Leonardo Rodrigues wrote:
> Hello all,
>
> The referencial integrity control don´t apply to a simple table, do
> it?
What's a "simple" table?
> My DB is growing, and growing, and I´m very concerned about my host
> limitions of disk usage. So...
You shou
On Fri, Oct 24, 2003 at 04:00:07AM +0200, Benjamin KRIEF wrote:
> >
> > Is your bottleneck CPU, I/O, or lock contention?
> >
> > Is your slave running on worse hardware than your master?
>
> my bottleneck is CPU , definitely. the load can go up to 35 in peak hours.
> no swapping occurs , my key ef
On Fri, Oct 24, 2003 at 05:04:28PM +1000, Chris wrote:
> They gave up on it eh?
>
> Was that more because of the legal problems that happened, or due
> to BDB and InnoDB continuing to improve and provide better solutions?
Leagal issues, probably.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Lin
79 matches
Mail list logo
