"Juan E Suris" <[EMAIL PROTECTED]> wrote:
> I need to do something similar to replace, but can't figure out how to do it.
>
> Here's my table:
> user varchar(15) PRI
> cnt int(11)
>
> I want to increment cnt for user if it exists, else insert a row with cnt=1. I tried
> the following, but mysql
Thanks for the reply!! IndeedI am using version 3.23.58. I can
stop pounding my head against the wall now. Thanks again!!
*** REPLY SEPARATOR ***
On 2/19/2004 at 2:10 AM Jeremy March wrote:
>http://www.mysql.com/doc/en/UPDATE.html
>
>I believe multi-table updates weren
http://www.mysql.com/doc/en/UPDATE.html
I believe multi-table updates weren't supported until MySQL version
4.04. Are you using a version earlier than this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am truly frustrated with what should be a simple update. Any help to
enlighten this newbie is appreciated.
[TABLE A] tdmr_dmr
dmr_customer_code
dmr_job_number_code
[TABLE B] tjl_job_list
jl_customer_code
jl_jobnumber
In Table A, the dmr_customer_code fie
Hai MySQLians!!!
I have established the Successful Connection to MySQL from COBOL.
Now from COBOL I can able to query the MySQL and get back the
result sets using C APIs under MySQL 4.0.17-max both in windows
and Linux. Note that my Client is in Windows platform...
Its not enough for my applicat
I need to do something similar to replace, but can't figure out how to do it.
Here's my table:
user varchar(15) PRI
cnt int(11)
I want to increment cnt for user if it exists, else insert a row with cnt=1. I tried
the following, but mysql complains that I can't use the same table in the update
I don't have any insight into your problem but I want to take exception with
your assertion that no other commercial products work on Linux. In fact, DB2
works on Linux and has for some time. Here's a link to information about
this product: http://www-306.ibm.com/software/data/db2/udb/
If you nose
J. Allen Crider wrote:
I have just decided to try to learn something about MySQL after several
years of working with Oracle and wanted to transfer the data I have in
an Oracle 9i database to a new MySQL database. Since this is strictly
for personal use, I can't justify the cost of SQLPorter, an
Better list? This is the best list on the internet! :-)
Well, there is a "better" list - [EMAIL PROTECTED], but you have to buy a
support contract to post :-)
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
I have just decided to try to learn something about MySQL after several
years of working with Oracle and wanted to transfer the data I have in
an Oracle 9i database to a new MySQL database. Since this is strictly
for personal use, I can't justify the cost of SQLPorter, and none of the
other co
Hi!
Eric B. wrote:
Hi,
I'm trying to implement the proper indexing for my DB, and am having some
challenges. I was hoping someone could lend me a hand.
If I have 5 fields in the DB that I am indexing (field1, field2, field3,
field4, and field5), I know I can create an index:
Key Index1( field1,
Hi,
I'm trying to implement the proper indexing for my DB, and am having some
challenges. I was hoping someone could lend me a hand.
If I have 5 fields in the DB that I am indexing (field1, field2, field3,
field4, and field5), I know I can create an index:
Key Index1( field1, field2, field3, fie
N¬ë,j°jËkj{zºÞw
«k©oz»"¢z
¦ºxj×úèThanks for reply.
- Original Message -
From: "Ludwig Pummer" <[EMAIL PROTECTED]>
To: "Oscar Yen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 8:39 AM
Subject: Re: Similar simple query slow down dramatically, by
Go here http://www.php.net/manual/en/function.mysql-field-type.php in the
PHP manual and you will find in example 1 how to get all the information
about a table. You can then pare it down just to get the information you
want.
Respectfully,
Ligaya Turmelle
""Luiz Rafael Culik Guimaraes"" <[EMAIL
I am pretty new myself but can't you do it with a join? Like SELECT AVG(avg)
FROM table_a, table_b GROUP BY id_field.
Respectfully,
Ligaya Turmelle
""John McCaskey"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
First of all I am using mysql 4.0.18 and I am not free to upgrade to 4.
You can set it as an alias using AS .
Respectfully,
Ligaya Turmelle
"James E Hicks III" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Isn't there a way to prefix (or postfix) a tables column names in the
results
> of a select. For example I have a table named from_address. This t
I'm trying to build MySQL 4.0.18 for Linux x86 2.4.24 from source without
support for extra charsets. Lets say I need only latin1.
My configure:
FLAGS="-O3 -march=pentium4 -mcpu=pentium4 -fomit-frame-pointer" CXX=gcc
CXXFLAGS="-O3 -march=pentium4 -mcpu=pentium4 -felide-constructors
-fno-exceptio
I have a, possibly not so unusual problem, with dates. The standard MySQL datatime
accounts for
all dates starting between the year and inclusive.
The problem I'm having is that I have a client who wants to build a database for an
art-history
collection. We'd like to be able to date
- Original Message -
From: [EMAIL PROTECTED]
Date: Wednesday, February 18, 2004 3:49 pm
Subject: Re: Can't connect using C API
> Do you fail with a user who has a password?
>
I don't know. I don't have any users with
passwords. I did resolve my problem, though. If
you didn't see th
Oscar Yen wrote:
create table a (
imgid int not null,
parent int,
imgtype char(3),
img longtext,
primary key (imgid),
key searchkey (parent, imgid)
) type = innodb;
T1) select imgid, parent from a where parent = 10;
returns 3357 rows in 0.08 sec.
T2) select imgid, parent, imgtype fr
Simon Green wrote:
Is it just not the case that InnoDB table have to do more as they have more
functionality and so take more time?
Not exactly.
InnoDB does indeed support transactions, uses the ultimate in
concurrency control (multiversioning) and provides foreign key constraints.
That said
yes it does. we use a bigint(20) for example.
[EMAIL PROTECTED] wrote:
Hi,
I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath
--
Jeff Mathis, Ph.D.
At 02:06 PM 2/17/2004, you wrote:
Speaking of MySQL database security, what are some key things to keep in
mind, other than changing the root password?
Thanks,
Eve
Eve,
You're not paranoid if they're really out to get you.
Here are some links you might find interesting.
http://www.mysql
lee wrote:
Anyone know when 4.1.x is scheduled for going "Production?" The website says
it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to
have the improved subqueries, etc. in 4.1.x.
I would guess 4.1.1 is roughly as good on the old features as the latest 4.0.
However, I wo
Adam Goldstein wrote:
What about a baseline of benchmerks for common, recent hardware using
the sql-bench tools?
I can't find anything like that- It would be nice to know how my
setup/server compares to other servers of the same or similar
ability.
You can try mysqlsyseval along with some othe
Hi,
I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
Isn't there a way to prefix (or postfix) a tables column names in the results
of a select. For example I have a table named from_address. This table has
the column names line1,line2,line3,line4,line5. When I do a select query on
from_address I want all columns to return as from_line1, from_line2
Hello all:
I am looking into the Replication issues that surface
in a Failover scenario (Master goes down and Slave is
pressed into service).
I understand that it is critical for the Master and
Slave databases to mirror each other for Replication
to work. I am trying to ensure that this integrit
Hi Ronan,
> > > > 21 threads are idle.
> > >
> > > But, what could make so many threads get idle?
> >
> > Connecting, but don't doing anything.
> >
> > > Shouldn´t the queries just be executed, return the results and
> > > be closed?
> >
> > If you don't close your connection, what do you expect?
Martijn,
> > > 21 threads are idle.
> >
> > But, what could make so many threads get idle?
>
> Connecting, but don't doing anything.
>
> > Shouldn´t the queries just be executed, return the results and
> > be closed?
>
> If you don't close your connection, what do you expect?
>
> > Does this mean
Hi,
> > > I executed a SHOW PROCCESSLIST command and
> > > it returned me 39 rows which 21 of than show "Sleep"
> > > in the column "Command".
> > >
> > > What does this tell me?
> >
> > 21 threads are idle.
>
> But, what could make so many threads get idle?
Connecting, but don't doing anything.
Hi Jeremy,
> On Wed, Feb 18, 2004 at 04:26:21PM +0100, Martijn Tonies wrote:
> > Hi,
> >
> > Does anyone know what the possible values for column
> > "Command" are when doing a SHOW PROCESSLIST?
>
> A table in Chapter 1 of High Performance MySQL[*]
Thanks!
With regards,
Martijn Tonies
Database
What about a baseline of benchmerks for common, recent hardware using
the sql-bench tools?
I can't find anything like that- It would be nice to know how my
setup/server compares to other servers of the same or similar
ability.
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Feb 16,
Jeremy,
> On Wed, Feb 18, 2004 at 04:01:57PM -0300, Ronan Lucio wrote:
> > Hi All,
> >
> > I executed a SHOW PROCCESSLIST command and
> > it returned me 39 rows which 21 of than show "Sleep"
> > in the column "Command".
> >
> > What does this tell me?
>
> 21 threads are idle.
But, what could make
On Wed, Feb 18, 2004 at 04:01:57PM -0300, Ronan Lucio wrote:
> Hi All,
>
> I executed a SHOW PROCCESSLIST command and
> it returned me 39 rows which 21 of than show "Sleep"
> in the column "Command".
>
> What does this tell me?
21 threads are idle.
--
Jeremy D. Zawodny | Perl, Web, MySQL,
Kind of what I was thinking of. How can I generate a unique identifier?
-Nate
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 2:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Temporary table issues. Do I need persistent connections
with ph
Even with persistent connections, you can't use a temporary table on
a later HTTP connection (Web request), because you don't know that
your new HTTP connection will get the same MySQL connection that you
used before.
It should work to use a temporary table in a series of queries to get
data t
Hi All,
I executed a SHOW PROCCESSLIST command and
it returned me 39 rows which 21 of than show "Sleep"
in the column "Command".
What does this tell me?
Thank´s,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Anyone know when 4.1.x is scheduled for going "Production?" The website says
it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to
have the improved subqueries, etc. in 4.1.x.
> From http://www.mysql.com/doc/en/News-4.0.x.html
>
> # C.2 Changes in release 4.1.x (Alpha)
> *
I have a php page which displays quite a bit of dynamically calculated
data which I need to be sortable using different SQL statements.
Currently to display this data, a user browses to the page, the page
checks for a cookie, if the cookie doesn't exist it includes some php to
generate a temporary
Try :
SELECT * From table WHERE `address` = ''
Or
SELECT * From table WHERE `address` IS NULL
-Ursprüngliche Nachricht-
Von: Caroline Jen [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. Februar 2004 20:17
An: [EMAIL PROTECTED]
Betreff: How To Write This SQL Statement
Please help.
Thanks all.. that worked perfectly!
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 12:17 PM
To: Morgan, Andrew R.
Cc: [EMAIL PROTECTED]
Subject: Re: Installation Problem - PLEASE HELP
Alex Greg wrote:
>>Hi all. I am trying to inst
Alex Greg wrote:
Hi all. I am trying to install mySql on Solaris 2.6. I am getting the
following error during 'make':
ld: fatal: library -lz: not found
ld: fatal: File processing errors. No output written to
.libs/libmysqlclient.so.10.0.0
make[2]: *** [libmysqlclient.la] Error 1
make[2]: Leavin
On Wed, Feb 18, 2004 at 11:12:19AM -0600, Chris Fossenier wrote:
> I am planning a server upgrade and would like to update MySQL in the
> process. The preferred plan is to:
>
> 1. Upgrade the server Operating System.
> 2. Copy the MySQL files to the new storage system.
> 3. Install MySQL 4.0.18 a
Hi Rhino
> If your table name is bar and it is in a database named foo, the following
> commands will show you the columns in that table:
>
> describe foo.bar;
>
> -OR-
>
> show columns from foo.bar;
>
> If you try either command on a table that does not exist, you get an error
> message. Therefo
On Wed, Feb 18, 2004 at 04:26:21PM +0100, Martijn Tonies wrote:
> Hi,
>
> Does anyone know what the possible values for column
> "Command" are when doing a SHOW PROCESSLIST?
A table in Chapter 1 of High Performance MySQL[*]
Binlog Dump
Change user
Connect
Connect Out
Create DB
Debug
Delayed_inse
First of all I am using mysql 4.0.18 and I am not free to upgrade to 4.1
or 5.0.
I have two tables:
table_a, and table_b these two tables have the same structure:
CREATE table_a (
id_field mediumint(8) unsigned NOT NULL,
avg float default NULL
)
What I want to do is get the comb
I am planning a server upgrade and would like to update MySQL in the
process. The preferred plan is to:
1. Upgrade the server Operating System.
2. Copy the MySQL files to the new storage system.
3. Install MySQL 4.0.18 and point it to the old MySQL directory
4. Start 4.0.18 and have no problems.
If your table name is bar and it is in a database named foo, the following
commands will show you the columns in that table:
describe foo.bar;
-OR-
show columns from foo.bar;
If you try either command on a table that does not exist, you get an error
message. Therefore, the query only returns th
My confusion, I thought that was what you were asking for.
>> Original Message <<
On 2/18/04, 10:01:24 AM, Martijn Tonies <[EMAIL PROTECTED]> wrote
regarding Re: Possible values in "COMMAND" for SHOW PROCESSLIST:
> Hi,
> Are you sure about this? According to
>
Hi,
Are you sure about this? According to
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
these are the values of "State"
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> Checking tab
Do you fail with a user who has a password?
>> Original Message <<
On 2/17/04, 3:11:44 PM, Cira Account <[EMAIL PROTECTED]> wrote regarding Can't
connect using C API:
> I apologize if the listings below are badly
> formatted. I am posting this from a webmail cl
Checking table
Closing tables
connect out
Copying to tmp table on disk
Creating tmp table
Deleting tmp table
Deleting from main table
Deleting from reference tables
Flushing tables
Killed
Sending data
Sorting for group
Sorting for order
Opening tables
Removing duplicates
Reopen table
Repair
I added "/tmp/mysql.sock" as the Unix socket and it worked.
Thanks...Stephen
- Original Message -
From: Sasha Pachev <[EMAIL PROTECTED]>
Date: Tuesday, February 17, 2004 7:12 pm
Subject: Re: Can't connect using C API
>
> Error 261 on QNX means "connection refused". Try specifying the
Dear Friends
as subject. is this possible
if yes, how to get the field names returned
Regards
Luiz
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004
--
MySQL General Mailing Li
Hi,
Does anyone know what the possible values for column
"Command" are when doing a SHOW PROCESSLIST?
All I'm getting so far, is "Query", "Killed" and "Sleep".
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
h
I think mysqldump -x --default-character-set="latin1" > dump.xml should
put the character encoding into the resulting xml file. The first line
of dump.xml should be
but all that mysqldump puts is
David Dickson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
> Hi all. I am trying to install mySql on Solaris 2.6. I am getting the
following error during 'make':
>
> ld: fatal: library -lz: not found
> ld: fatal: File processing errors. No output written to
.libs/libmysqlclient.so.10.0.0
> make[2]: *** [libmysqlclient.la] Error 1
> make[2]: Leaving direct
Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error
during 'make':
ld: fatal: library -lz: not found
ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0
make[2]: *** [libmysqlclient.la] Error 1
make[2]: Leaving directory `/vir
Is it just not the case that InnoDB table have to do more as they have more
functionality and so take more time?
Simon
- Original Message -
From: "Jiří Matějka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 10:38 AM
Subject: Speed of MyISAM vs. InnoDB
>
"Jiri Matejka" <[EMAIL PROTECTED]> wrote:
> Now I found one more "strange" thing - if I use show tables to get table
> properties, then if table is MyISAM the number of rows is correct and if it
> is InnoDB number of rows is around 2000 lower... And the innodb table looks
> 8 times bigger than myis
From: "Jiri Matejka" <[EMAIL PROTECTED]>
> Now I found one more "strange" thing - if I use show tables to get table
> properties, then if table is MyISAM the number of rows is correct and if
it
> is InnoDB number of rows is around 2000 lower... And the innodb table
looks
> 8 times bigger than myisa
Now I found one more "strange" thing - if I use show tables to get table
properties, then if table is MyISAM the number of rows is correct and if it
is InnoDB number of rows is around 2000 lower... And the innodb table looks
8 times bigger than myisam table (field data_length in show table status
q
Alaios <[EMAIL PROTECTED]> wrote:
> Hi there. I am trying to create a table using the
> mysql control center but i am taking the error. Unable
> to locate syntax.txt Please locate the file.
> Any sugestion?
Find where syntax.txt is located and set up path to this file in the General
Configuration
Unfortunately it persists also for real queries. Eg. query like "select
field1 from table1 where field3=xx" and InnoDB is cca 10times slower than
MyISAM.
I wonder whether there is not some error or problem in my.ini settings, I
use following settings:
innodb_additional_mem_pool_size 1048576
innodb
Craig Robinson wrote:
Hi,
I intend to use MySQL for a database application, and I am not sure
whether to use MyISAM or InnoDB tables. There will be a very large
amount of (mainly numerical) data. The relations between the tables will
be reasonably simple. Which table type would you recommend?
The
COUNT(*) is a special case for MyISAM. However, you'll find that
anything that has a WHERE clause that takes advantage of an index is
pretty quick for both MyISAM and InnoDB tables.
For instance:
SELECT COUNT(*) FROM table;
Is slow as all buggery on InnoDB, but:
SELECT COUNT(id) FROM table WH
On Tue, 2004-02-17 at 17:08, Ross O wrote:
> [EMAIL PROTECTED] root]# rpm -qvl MySQL-server-4.0.18-0
> -rwxr-xr-x1 rootroot 5575 Feb 12
> 09:02 /etc/init.d/mysql
> -rw-r--r--1 rootroot 657 Feb 12
> 09:02 /etc/logrotate.d/mysql
> -rwxr-xr-x1 rootroot
Hi!
I got a table, champions, looking like this:
id class winner_1 winner_2 year
-
0 hd carl mattias 1957
1 hs daniel
I think count(*) is a special case: MyISAM holds a record count which it
can access instantly, InnoDB has to count rows. Does the time difference
persist for real queries?
Alec
Jiří Matějka <[EMAIL PROTECTED]> wrote on 18/02/2004 10:38:13:
> Hi all,
> I'm using mysql 4.0.17 and I ha
Hi,
I intend to use MySQL for a database application, and I am not sure
whether to use MyISAM or InnoDB tables. There will be a very large
amount of (mainly numerical) data. The relations between the tables will
be reasonably simple. Which table type would you recommend? Also, I find
InnoDB tables
Hi!
On Feb 17, Jeremy Zawodny wrote:
> On Tue, Feb 17, 2004 at 01:18:45PM -0800, lee wrote:
> > We are trying to do some capacity planning, and we need to know how MySQL
> > allocates the the filespace in the directories set by the tmpdir
> > configuration parameter.
> >
> > The manual simply sta
I hope this helps.
What table format are you using?
When did data loss happen eg. after power loss?
Yes do use the MySQL tools to repair the tables.
Also you could run the bin logs back in to MySQL so all
sql changes are run on the table again.
The other thing to think about is locking tables
Hi Andre
should be GRANT
hth
steve
Steenveld, A. wrote:
I try to grand some rights by using GRAND but for some unclear reason to me I
can't get it to work.
Here is what I type
mysql -u root -p
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connec
"Steenveld, A." <[EMAIL PROTECTED]> wrote:
> I try to grand some rights by using GRAND but for some unclear reason to
> me I
> can't get it to work.
>
> Here is what I type
>
> mysql -u root -p
> Enter password: **
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL conn
on 02/18/2004 02:43 AM, Steenveld, A. at [EMAIL PROTECTED] wrote:
> mysql> GRAND ALL ON *.* TO [EMAIL PROTECTED];
I think you mean GRANT <- notice the 'T' not 'D' ?
--
-
Scott HanedaTel: 415.898.2602
http
> I try to grand some rights by using GRAND
You want GRANT, not GRAND.
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I try to grand some rights by using GRAND but for some unclear reason to me I
can't get it to work.
Here is what I type
mysql -u root -p
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 126 to server version: 4.0.18-max
...
mysql> GRAND
Hi all,
I'm using mysql 4.0.17 and I have this problem with speed of innodb
database:
I have simple command like select count(*) from table1, or select field1,
field2 from table1. The table1 and has more than cca 10.000 rows (most of
the fields are integer, only several varchars and several memo
alright, then I´ll probably go for mysqldump, thanks
/Jonas
> Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> > Hello, I am runing mysql5.x and have just started fiddeling with how I
should back up my innodb databases. I started reading about ibbackup and
think it suits me. But the problem is I cant f
Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> Hello, I am runing mysql5.x and have just started fiddeling with how I should back
> up my innodb databases. I started reading about ibbackup and think it suits me. But
> the problem is I cant find it ;) Does ibbackup come with mysql or should I download
N¬™ë,j°jËkj{zºÞw…«k‰©oz»"¢z
‰¦ºx†jטúèDear all,
I have asked the question days before, but no one seems interested in it
Considering table imgstore, defined as
create table a (
imgid int not null,
parent int,
imgtype char(3),
img longtext,
primary key (imgid),
key searchke
Good Morning!
Sasha Pachev wrote:
Keith Thompson wrote:
I've got a query that's not using an index and I don't understand why.
Here's a stripped down version of what the tables look like:
create table t1 (
id int(10) unsigned not null auto_increment,
x1 date not null,
... 8 other small, fixed fi
Hello, I am runing mysql5.x and have just started fiddeling with how I should back up
my innodb databases. I started reading about ibbackup and think it suits me. But the
problem is I cant find it ;) Does ibbackup come with mysql or should I download it
separatly from somewhere else? Anyone usin
84 matches
Mail list logo