Laercio Xisto Braga Cavalcanti wrote:
Hi all,
I'm using mysql 3.23.54 under RedHat9 trying to update a field named
pac_fone in a table named paciente with the value of a field named
ita_fone from a table named italica as follows:
update paciente
SET pac_fone= (select ita_f
On May 21, 2004, at 9:14 PM, David Blomstrom wrote:
--- Hassan Schroeder <[EMAIL PROTECTED]> wrote:
"If "Cowboy State" has a semantic meaning, like
"nickname", you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
seman
David Blomstrom wrote:
You mean I can make up a name for a "semantic tag,"
designating every nicknname or every
emphasized word , for example?
Yep, XML lets you create your own DTD/schema -- though sometimes it
makes sense to use (or leverage) an existing one.
And is this something that can only b
--- Hassan Schroeder <[EMAIL PROTECTED]> wrote:
"If "Cowboy State" has a semantic meaning, like
"nickname", you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
semantic tag for it, like `Cowboy
State, (reinforced ...
--- Hassan Schroeder <[EMAIL PROTECTED]> wrote:
"If "Cowboy State" has a semantic meaning, like
"nickname", you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
semantic tag for it, like `Cowboy
State, (reinforced ...
On 05/21/04 20:40 Laercio Xisto Braga Cavalcanti spoke:
Hi all,
I'm using mysql 3.23.54 under RedHat9 trying to update a field named
pac_fone in a table named paciente with the value of a field named
ita_fone from a table named italica as follows:
Try more quotes and get the select to work:
select
David Blomstrom wrote:
Some time ago, I posted a question about using HTML in
MySQL tables.
Someone suggested this is a bad strategy, asking what
I would do if I later decided to change the italicized
words to bold, for example.
I'm just trying to figure out what the options are, as
well as deter
Some time ago, I posted a question about using HTML in
MySQL tables. For example, if I put the following in a
table cell...
Cowboy State (reinforced by logo depicting
cowboy on bucking bronco), Big Wyoming
It will be displayed as...
Cowboy State (reinforced by logo depicting cowboy on
bucking br
> Luis - you're quite polite so I'll assume that you are ignorant rather
th
> an prejudiced.
>
> You have a university email so I'll also assume you're a student who
wants > to learn.
>
> So here's your lesson for today: Don't judge people by their cover, or
by > their color, or by their name, or b
Hi all,
I'm using mysql 3.23.54 under RedHat9 trying to update a field named
pac_fone in a table named paciente with the value of a field named
ita_fone from a table named italica as follows:
update paciente
SET pac_fone= (select ita_fone
fromitalica
Luis - you're quite polite so I'll assume that you are ignorant rather than prejudiced.
You have a university email so I'll also assume you're a student who wants to learn.
So here's your lesson for today: Don't judge people by their cover, or by their color,
or by their name, or by their servic
On Fri, May 21, 2004 at 05:18:09PM -0600, Sasha Pachev wrote:
>
> It looks like FreeBSD was using only one CPU from your numbers. Try the
> test with only 1 thread and a lot of iterations to avoid the influence of
> overhead. I know very little about FreeBSD, but one thing I would check is
> if
Chris Elsworth wrote:
Forenote: I have no wish to start an OS debate.
Hello,
I'm in the fortunate position of having a dual 2.8GHz Xeon with 4G of
ram and 4 10k SCSI disks (configured in RAID-10) to deploy as a new
MySQL server.
Since I'm a numbers freak, I've been running super-smack on it for the
--- [EMAIL PROTECTED] wrote:
> What I was saying was - everything slows down when
> it gets bigger. However, a lot of work has been put
> into database engines to keep them going fast even
> when they get big, whereas file systems slow down
> considerably when they get bigger.
>
> It's not the st
> now the really interesting part is: all other (or at least
> a lot of other) accented european characters are being
> displayed correctly _only_ german umlauts are allways shown
> as question marks.
>
> does anybody care to explain and give me a hint on what
> to do. i am completely confused.
>
Forenote: I have no wish to start an OS debate.
Hello,
I'm in the fortunate position of having a dual 2.8GHz Xeon with 4G of
ram and 4 10k SCSI disks (configured in RAID-10) to deploy as a new
MySQL server.
Since I'm a numbers freak, I've been running super-smack on it for the
last few days to s
Greg Willits wrote:
Greg Willits wrote:
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote:
Greg Willits wrote:
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket
I only sporadically use newsgroups and choose to use the program 40tude
when I do. I greatly appreciate this group and wish to remain subscribed
but am receiving ALL of the posts as emails. How do I change my preferences
on this board so that I only receive posts when I launch 40tude and
downlo
Thanx Chris. That was it. To save space, I went ahead and dropped the two
separate indexes because they were no longer needed. The only fulltext
search performed on this database includes both fields.
Thanx again,
Robb
On Fri, 21 May 2004 13:42:21 -0700, Chris wrote:
> What query are you using t
What query are you using to search?
With the FullText indexes you have only two match options are possible:
MATCH(specs) AGAINST . . .
and
MATCH(manufacturer) AGAINST . . .
If you're trying to search both at the same time you need a FULLTEXT
index of (specs,manufacturer)
Chris
Robb Kerr wrote:
G
Got a problem with my fulltext searches. Here is the structure of the table
as displayed in MySQLyog...
Column Information For - robeson_robesondb.robeson_inv
--
Field Type NullKey Default Extra Privileges
Conveyor:
Serial
10
11
Support
SerialCost
1100
1150
10001200
10001250
Accessory
SerialCost
150
175
10001100
10001200
Desired Result
SerialSupportCostAccessoryCost
10250
Greg Willits wrote:
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote:
Greg Willits wrote:
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket name in /tmp.
They
Kevin Cowley wrote:
Don't tell me - you upgraded a PIII server to a PIV server?
The cache on the PIV is les than half the size of a PIII.
We've hit this problem with our own apps that by the way they operate cache
a lot of data. A PIII 1.4GHz will match a 2.4 GHz PIV.
Yes, MySQL code is written wit
Jim Nachlin wrote:
Hi List,
Is there a way to copy a user in the database's mysql database, so that
it will have the same permissions (GRANTs) within the database? Or does
one have to create a different user and then manually modify the
permissions to match the first?
Warning - untested, but yo
In the last episode (May 21), Greg Willits said:
> Anyone know of some large sample data sets available for free or < $100?
>
> "Large" = maybe 1KB per row or so, 1,000,000 - 5,000,000 records or
> so, something on the order of a couple hundred megabytes.
>
> "Sample Data" = I don't really care w
Greg Willits wrote:
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote:
Greg Willits wrote:
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket name in /tmp.
They
Anyone know of some large sample data sets available for free or < $100?
"Large" = maybe 1KB per row or so, 1,000,000 - 5,000,000 records or so,
something on the order of a couple hundred megabytes.
"Sample Data" = I don't really care what it is (text based though, no
need for BLOB), just someth
Scott Haneda writes:
>My trouble is that the data file could be 100,000 lines in length, I have a
>few options:
Scott,
I have a 30 million record dataset that I load into MySQL every couple
of months. To do this propitiously I use the 'LOAD DATA INFILE' syntax.
>From your description it shou
Hi List,
Is there a way to copy a user in the database's mysql database, so that
it will have the same permissions (GRANTs) within the database? Or does
one have to create a different user and then manually modify the
permissions to match the first?
Thanks,
Jim
--
MySQL General Mailing List
Fo
Hello list,
I'm not sure this is the correc t list I'm writing to, but I hope so. If
not: sorry.
My problem: I'm writing a DB application (with MySQL, of cause) which
uses the new MySQL 5.0 stored procedured. Unfortunately I couldn't find
any samples or documentation for this topic. The procedure
What I was saying was - everything slows down when it gets bigger. However, a lot of
work has been put into database engines to keep them going fast even when they get
big, whereas file systems slow down considerably when they get bigger.
It's not the storing of the link that's the issue. That's
At 15:14 -0300 5/21/04, Renato Cramer wrote:
I'm using MySQL 4.1.0 and InnoDB tables.
I need set autocommit=0 and want do via option file.
I know what "SET AUTOCOMMIT=0" works fine, however I prefer by the option
file.
Is possible?
In 4.1.0, no. You'll be able to do this in 4.1.2. See the descript
Abubakr wrote:
> I am trying to copy a file stored in longblob column of a table to a
longblod column of another table, can any one tell me what kind of
insert statement should i use for that purpose.
You should be able to insert into your upload table with a select from
your testing table. Thi
At 8:24 -0700 5/21/04, Ron Gilbert wrote:
When you connect to a MySQL server remotely (from the C API, in my
case), is your MySQL password sent in clear text?
No.
I've looked but I can find an answer to this question in the
docs...maybe I'm missing it.
http://dev.mysql.com/doc/mysql/en/Security_a
Sounds like a tmp drive issue to me. Maybe you had reiserfs on your old tmp
partition and now you have ext3 or something like that.
Donny
> -Original Message-
> From: Charles, Tony (Exchange) [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 21, 2004 12:47 PM
> To: [EMAIL PROTECTED]
> Subjec
At 14:34 -0300 5/21/04, Renato Cramer wrote:
Hi All,
I already looking for Autocommit within my.ini at documentation and archives
of the list, and not found.
Anybody can help me?
What is it that you want to accomplish?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.m
Don't tell me - you upgraded a PIII server to a PIV server?
The cache on the PIV is les than half the size of a PIII.
We've hit this problem with our own apps that by the way they operate cache
a lot of data. A PIII 1.4GHz will match a 2.4 GHz PIV.
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct li
Hi all,
Just bought a new server, which was supposed to improve the performance of our app.
The new machine has the same OS (Redhat 8), same MySQL (4.0.18), and same my.cnf.
The problem is that this (frequently run) query, actually runs 41% slower!
select * from LEG L, LEG_DETAIL D, DEAL
Hi All,
I already looking for Autocommit within my.ini at documentation and archives
of the list, and not found.
Anybody can help me?
Thanks in advance,
Renato Cramer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
"Leonardo Francalanci" <[EMAIL PROTECTED]> wrote:
>> Test it on 4.1.2 and let me know if these queries will crash MySQL server.
>
> Mmh, I'm afraid I will have to wait for binaries...
> When do you think 4.1.2 binaries will be available?
>
Probably it will be out next week.
--
For technical s
H Bartel wrote:
I have the following tables which look like this:
table tartist
++--+--+---+---+
| id | name | info | image | genre |
++--+--+---+---+
table programm
++--+---++
| id | date | stage | artist |
++--+---++
On May 21, 2004, at 5:19 AM, Victor Medina wrote:
| On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
|
|> What level of Encryption does MySQL have? I cannot find much
security
|> information from mysql.com.
||
| http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
|
Any level of SSL pr
I think we all have missed the opportunity to discuss horizontal scaling
when it comes to links vs. blobs. If you store links in the data then you
gain the ability to use edge caches, secondary file servers, web farms,
file farms, network storage and all of those other high-capacity file
services
Thank you all for your reply, it works perfectly.
Gael
Victor Pendleton <[EMAIL PROTECTED]> wrote on 21/05/2004 16.55.23:
> One option:
>
> UPDATE table_name
> SET col_name = REPLACE(col_name, 'host.domain.com', 'host2.domain.com')
> WHERE
>
> -Original Message-
> From: [EMAIL PROTECT
When you connect to a MySQL server remotely (from the C API, in my
case), is your MySQL password sent in clear text?
I've looked but I can find an answer to this question in the
docs...maybe I'm missing it.
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
> Test it on 4.1.2 and let me know if these queries will crash MySQL server.
Mmh, I'm afraid I will have to wait for binaries...
When do you think 4.1.2 binaries will be available?
Thank you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
> I've xml contents in a column of one table. Inside that xml content, I've
> sometime an hardcoded link which I needs to change automatically (lets
> say:
> from host.domain.com/dev to host2.domain.com)
>
> I'm searching how to build the sql statement to do it but I don't
> understand
> how to do
One option:
UPDATE table_name
SET col_name = REPLACE(col_name, 'host.domain.com', 'host2.domain.com')
WHERE
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 5/21/04 9:23 AM
Subject: question on data manipulation
Hi All
I've xml contents in a column of one tab
Hi,
Signal 11 can also indicate hardawre problems on BSD. Also FreeBSD
might get you more answers quickly as there are more of us running
FreeBSD with MYSQL for some reason. We runn FreBSD w MySQL/Linux
threads on 4.9 and 5.2 and both work just fine.
Ken
- Original Message -
From: "RV
Andrew McHorney <[EMAIL PROTECTED]> wrote on 21/05/2004 15:32:56:
> Hello
>
> I just installed version 4.0 using the installer. Is there supposed to be
a
> icon on the desktop for starting up MySQL. If so, what is the name of the
> executable?
>
> I have nothing in my programs list or on m
"Leonardo Francalanci" <[EMAIL PROTECTED]> wrote:
>> > v4.1.2? Where can I get it?
>> >
>>
>> You can install it from development source tree:
>> http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html
>>
>> or wait when binaries will be available.
>
> I'll wait for binaries...
>
Hi All
I've xml contents in a column of one table. Inside that xml content, I've
sometime an hardcoded link which I needs to change automatically (lets
say:
from host.domain.com/dev to host2.domain.com)
I'm searching how to build the sql statement to do it but I don't
understand
how to do t
Hello
I just installed version 4.0 using the installer. Is there supposed to be a
icon on the desktop for starting up MySQL. If so, what is the name of the
executable?
I have nothing in my programs list or on my desktop.
Thanks,
Andrew
--
MySQL General Mailing List
For list archives: http://lis
As a preventive maintenance and the handle fragmentation running a nightly
mysqltablecheck may prove to be beneficial.
-Original Message-
From: Jude Insley
To: [EMAIL PROTECTED]
Sent: 5/21/04 7:10 AM
Subject: RE: Index cardinality lost
> After what action are you indexes becoming invalid
Hi,
I have a problem with selecting / ordering by different criteria from
different tables. Maybe this doesn't even work, or there is a much
better way?
I have the following tables which look like this:
table tartist
++--+--+---+---+
| id | name | info | image | genre |
+
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> > If you check wait_timeout value using mysql command-line client, it
> > takes value for 'wait_timeout' from 'interactive_timeout' variable
> > which is 28800 by default.
>
> thanks, now i see.
> this behaviour is rather strange, isn't it? why are
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Willits wrote:
| On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
|
|> What level of Encryption does MySQL have? I cannot find much security
|> information from mysql.com.
|
|
| http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
|
| -
> After what action are you indexes becoming invalid? Are you running nightly
> maintenance? What is the table type?
We are not running nightly maintenance but we do run the INSERT DELAYED as
a batch during the night. The loss of cardinality seems to happen after a
number of days but we have no
hi,
i am trying to get german umlauts into my database.
shouldnt be that hard...
i am working on a linux machine with the following
settings
suse 9.0
MySQL-server-4.1.1-1
MySQL-client-4.1.1-0
#> locale
LANG=de_DE.UTF-8
LC_CTYPE="de_DE.UTF-8"
LC_NUMERIC="de_DE.UTF-8"
LC_TIME="de_DE.UTF-8"
LC_COLLATE
After what action are you indexes becoming invalid? Are you running nightly
maintenance? What is the table type?
-Original Message-
From: Jude Insley
To: [EMAIL PROTECTED]
Sent: 5/21/04 6:00 AM
Subject: Index cardinality lost
We have a set of tables which are losing the cardinality on th
We have a set of tables which are losing the cardinality on the first part
of the primary key. A simple CHECK TABLE or ANALYZE table restores the
cardinality. We are running MySQL 4.0.18 on Solaris 8.
*** 1. row ***
Table: UserSessions
Non
"adrian Greeman" <[EMAIL PROTECTED]> wrote:
> There is a particular form of SQL query you can use I believe when you
> are adding data to a table and want to include an ID number from another
> lookup table but you only know the name reference and not the ID
>
> eg it might be an "author" table wi
hi,
I am trying to copy a file stored in longblob column of a table to a longblod
column of another table, can any one tell me what kind of insert statement should i
use for that purpose. 2ndly can any one tell me any built in function in mysql to
download a file from longblob column to your
hi everybody,
Just a note of a problem I found - to see whether worth reporting this
as a bug, or suggest that someone mention it in the manual.
In short: *when replication fails because 'max_packet_size' is too
small, that failure can corrupt the relay logs*. So even when you fix
the max_packe
Adrian,
You may try this:
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
Best Regards,
Jonathan Chiu
OOCL Logistics
Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai
TEL: 852 . 2990 0174
FAX: 852 . 28249017
-
> > v4.1.2? Where can I get it?
> >
>
> You can install it from development source tree:
> http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html
>
> or wait when binaries will be available.
I'll wait for binaries...
At the moment even a query like
(SELECT * FROM REGULAR_copy) U
On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
What level of Encryption does MySQL have? I cannot find much security
information from mysql.com.
http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
-- greg willits
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
> If you check wait_timeout value using mysql command-line client, it
> takes value for 'wait_timeout' from 'interactive_timeout' variable
> which is 28800 by default.
thanks, now i see.
this behaviour is rather strange, isn't it? why are there two different
variables then? i thought that wait_tim
There is a particular form of SQL query you can use I believe when you
are adding data to a table and want to include an ID number from another
lookup table but you only know the name reference and not the ID
eg it might be an "author" table with an author_id and author_name and
you want to enter
"Leonardo Francalanci" <[EMAIL PROTECTED]> wrote:
>> I tested it on with my test data for others PARTITIONED_*_*
>> tables on v4.1.2 and SELECT worked well.
>
> v4.1.2? Where can I get it?
>
You can install it from development source tree:
http://dev.mysql.com/doc/mysql/en/Installing_so
Dear Sir,
What level of Encryption does MySQL have? I cannot find much security
information from mysql.com.
Thanks,
Joseph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> I tested it on with my test data for others PARTITIONED_*_*
> tables on v4.1.2 and SELECT worked well.
v4.1.2? Where can I get it?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Any functions like "filter" ADO function in PHP? Thanks!
74 matches
Mail list logo
