hay rob
i used unicode with mysql 3.23.39
i never activated any support for my unicode data
true dos will convert it into alian characters .
so what u do is
inzert ur unicode data into longtext fields if u want to make them full text
if not keep it in blob fields
i ve been workin with the thing
At 12:44 AM 6/7/2003 -0400, Becoming Digital wrote:
"Personally, I prefer Apache over IIS (or PWS, as the case may be), even in a
WinXP environment."
Joining the Linux/Apache bandwagon is one of my goals. I even got Linux
installed on my computer a couple months ago. But I've been so overwhelmed,
Hi Jude,
I think what you want to know is described very nicely in the MySQL
documentation. look for GRANT and REVOKE.
There are also two reports on devshed which I believe are an excellent source.
There is really nothing to add. Print them off read them carefully on your
way home and tomorrro
Hi All ,
When I run the sql query :
select a.group_id as "Select", a.group_name as "Group Name",
date_format(a.group_created_date,"%M %e, %Y %H:%i") as "Created Date",
date_format(a.last_modification_date,"%M %e, %Y %H:%i") as "Last Modified",
a.learning_style as "Style" ,
count(c.group_id) as "
I believe this thread (from only three days ago) will answer your question.
http://lists.mysql.com/list.php?1:mss:141551:200306:kkmidpclnclgkpjgpgkd
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Dylan Pham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi,
I am new and am wodering if anyone can point out how
to make AUTO_INCREMENT readjust the numbers so that
when you delete a row it will go back to using the
next number after the last row in the table?
Thank you.
Hai
__
Do you Yahoo!?
Yahoo! Calendar - Free onli
Personally, I prefer Apache over IIS (or PWS, as the case may be), even in a
WinXP environment. Certain aspects of my work require that I use just such a
configuration on a regular basis and, while not as stable as Linux/BSD might be,
I think it's better than whatever MS supplies with the operatin
At 09:55 PM 6/6/2003 -0400, Becoming Digital wrote:
"Rather than let discussion here stray too far from strictly MySQL issues, try
subscribing to the PHP-DB mailing list ([EMAIL PROTECTED]) and
re-posting there. We'd all be happy to help you. :)"
Thanks. I just e-mailed that address with "subscri
Try using 'max_allowed_packet=16M' instead of your current value. You may also
find help by reviewing the below.
http://www.mysql.com/doc/en/Packet_too_large.html
Is there a reason you are including the BLOBs in the database instead of just
linking via it? I know it's generally considered better
You'll need some knowledge of a scripting language (I like PHP or PERL) to make
these items work smoothly. With them, you can easily accomplish the tasks at
hand.
Rather than let discussion here stray too far from strictly MySQL issues, try
subscribing to the PHP-DB mailing list ([EMAIL PROTECTED
On Fri, Jun 06, 2003 at 09:03:04PM -0400, Becoming Digital wrote:
> just suppress the error with @.
>
Oh yes, I forgot about that one.
But the other discussion was more fun!
Regards,
Mark
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
Thanks Paul!
Much appreciated. I'm sure this will be of help to others, particularly
because to WinXP Perl neophytes like myself, you only get to find out
mysqlhotcopy.pl won't work because of the "getpwuid" function after you
go through solving how to get DBI.pm installed (which turned out to be
just suppress the error with @.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Mark Rages" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 06 June, 2003 17:15
Subject: SQL no-op?
I need a placeholder statement that does nothing.
Is there
At 10:34 +1000 6/7/03, Murray Wells wrote:
Hi All,
Apologies if this has been done to death previously, but would it be
sensible to indicate in the MySQL documentation that the Perl
mysqlhotcopy script only appears to work on the Linux platform? (Or,
more accurately, doesn't work on the WinXP plat
Hi All,
Apologies if this has been done to death previously, but would it be
sensible to indicate in the MySQL documentation that the Perl
mysqlhotcopy script only appears to work on the Linux platform? (Or,
more accurately, doesn't work on the WinXP platform, I have no idea
about other platforms)
I joined this list some time ago, but I still haven't had time to really
start learning MySQL yet. I just wanted to ask a couple questions while
they're fresh in my mind:
1. Can you point me to some good examples of online MySQL-driven tables
that offer visitors sortable columns and rows - espe
Yes there is, that's what Paul was referring to regarding InnoDB...it has a
table space made up of multiple files on the disk and the tables reside
within the tablespace. Thus the tables are not bound by the file system's
maximum file size.
Details are in the MySQL manual in the table types secti
Hi,
Thanks for the fast response. I wonder there is a
'tablespace' notion in mysql just like the one in
Oracle. One can keep adding datafile from different
disk to the same tablespace and don't have to worry
about how the data is stored in the files.
Thanks again.
--- Paul DuBois <[EMAIL PROTE
Hi,
Thanks for the fast response. I wonder there is a
'tablespace' notion in mysql just like the one in
Oracle. One can keep adding datafile from different
disk to the same tablespace and don't have to worry
about how the data is stored in the files.
Thanks again.
--- Paul DuBois <[EMAI
At 18:05 -0500 6/6/03, Paul DuBois wrote:
At 15:59 -0700 6/6/03, Titu Kim wrote:
2. How can i add another file to a table if the .MYD
file grows too large?
Once the file size reaches its maximum, that's as far as you can go.
I should add to this that one way to obtain an effective larger
"file" siz
At 17:59 -0500 6/6/03, Pete Harlan wrote:
On Fri, Jun 06, 2003 at 05:19:20PM -0500, Paul DuBois wrote:
At 15:11 -0700 6/6/03, Jeremy Zawodny wrote:
>On Fri, Jun 06, 2003 at 04:15:29PM -0500, Mark Rages wrote:
>> I need a placeholder statement that does nothing.
>>
>> Is there something more el
At 15:59 -0700 6/6/03, Titu Kim wrote:
Hi I am new to Mysql. I have the following newbie
questions.
1. How can i find/set the file size of for my .MYI and
.MYD file?
You can find the sizes using ls on Unix or dir on Windows.
You don't set the sizes. Let the server manage the files.
2. How can i ad
On Fri, Jun 06, 2003 at 09:28:47AM -0700, Ben Goswami wrote:
> Hi,
>
> Any one knows if MySQL implemented the feature which is equivalent
> to Oracle's "Connect by Prior" clause. This is needed for
> retrieving 'Tree' result set from a table like :
Search the manual for CONNECT BY and you'll see
On Fri, Jun 06, 2003 at 05:19:20PM -0500, Paul DuBois wrote:
> At 15:11 -0700 6/6/03, Jeremy Zawodny wrote:
> >On Fri, Jun 06, 2003 at 04:15:29PM -0500, Mark Rages wrote:
> >> I need a placeholder statement that does nothing.
> >>
> >> Is there something more elegant than
> >> SELECT FROM ... WHERE
Hi I am new to Mysql. I have the following newbie
questions.
1. How can i find/set the file size of for my .MYI and
.MYD file?
2. How can i add another file to a table if the .MYD
file grows too large?
3. How to configure mysql client to access two mysql
database on two machines with each datab
On Fri, Jun 06, 2003 at 02:06:18PM -0500, Paul DuBois wrote:
> >Why can't I set ft_min_word_len? According to the
> >docs, this is available in 4.0. Do I have to use some
> >other syntax?
>
> Set it at server startup time.
And make sure to rebuild any affected indexes.
--
Jeremy D. Zawodny
On Fri, Jun 06, 2003 at 05:19:20PM -0500, Paul DuBois wrote:
> At 15:11 -0700 6/6/03, Jeremy Zawodny wrote:
> >On Fri, Jun 06, 2003 at 04:15:29PM -0500, Mark Rages wrote:
> >> I need a placeholder statement that does nothing.
> >>
> >> Is there something more elegant than
> >> SELECT FROM ... WH
At 15:11 -0700 6/6/03, Jeremy Zawodny wrote:
On Fri, Jun 06, 2003 at 04:15:29PM -0500, Mark Rages wrote:
I need a placeholder statement that does nothing.
Is there something more elegant than
SELECT FROM ... WHERE 0=1; ?
I need this because PHP throws an error when an empty statement
(or just
On Fri, Jun 06, 2003 at 04:15:29PM -0500, Mark Rages wrote:
> I need a placeholder statement that does nothing.
>
> Is there something more elegant than
> SELECT FROM ... WHERE 0=1; ?
>
> I need this because PHP throws an error when an empty statement
> (or just a ';') is passed to MySQL.
SELEC
On Fri, Jun 06, 2003 at 01:33:10AM -0700, Gustavo A. Baratto wrote:
> Hail Jeremy!!
>
> my kernel is new as releng5_0 (release + security patches). I saw your
> Yahoo! patch in the source with 4.0.13.
Hmm. I don't have a 5.0 box handy [yet] to test it on here. I'll try
to do that sometime in t
At 17:28 -0400 6/6/03, Alex Pilson wrote:
At 4:22 PM -0500 6/6/03, Paul DuBois wrote:
At 17:17 -0400 6/6/03, Alex Pilson wrote:
I have an old table that has about 2000 records and hasn't been
modified. I realized it was missing a create_date. Do anyone know
or have any slick SQL code to extract o
Thanks much, permissions. I did an rpm install of this package and it
appears some permissions were not or are not preserved by rpm. Well, live
and learn. I did the first step with chmod 0004 /var/lib/mysql, it's that
second one I'm not certain of. the user mysql exists and I gave it a
password
Heikki Tuuri wrote:
Cube,
- Original Message -
From: "cube" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, June 06, 2003 11:05 PM
Subject: distributed transaction management in MySQL
Hello to everybody from new user :)
My question is:
Does MySQL supports distrib
At 4:22 PM -0500 6/6/03, Paul DuBois wrote:
At 17:17 -0400 6/6/03, Alex Pilson wrote:
I have an old table that has about 2000 records and hasn't been
modified. I realized it was missing a create_date. Do anyone know
or have any slick SQL code to extract out the date from the
timestamp field and
At 17:17 -0400 6/6/03, Alex Pilson wrote:
I have an old table that has about 2000 records and hasn't been
modified. I realized it was missing a create_date. Do anyone know or
have any slick SQL code to extract out the date from the timestamp
field and update and insert the date into the create_d
Cube,
- Original Message -
From: "cube" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, June 06, 2003 11:05 PM
Subject: distributed transaction management in MySQL
> Hello to everybody from new user :)
>
> My question is:
> Does MySQL supports distributed transactio
I have an old table that has about 2000 records and hasn't been
modified. I realized it was missing a create_date. Do anyone know or
have any slick SQL code to extract out the date from the timestamp
field and update and insert the date into the create_date field?
Thanks!
--
<--
I need a placeholder statement that does nothing.
Is there something more elegant than
SELECT FROM ... WHERE 0=1; ?
I need this because PHP throws an error when an empty statement
(or just a ';') is passed to MySQL.
Regards,
Mark
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archiv
Hello --
I am having trouble inserting binary data that is larger than 16
megabytes into a MySQL database table (binary data such as pdf's, gif's,
jpeg's, etc). Can someone take a look at what I am doing and give me
any suggestions.
If I do insert binary data larger than 16 megabytes I get the f
At 16:58 -0400 6/6/03, Vivian Wang wrote:
I have three files which are .frm, .MYD and .MYI.
How I can use those three files become one table again?
Thanks.
They already are one table. You don't need to do anything.
MySQL implements each MyISAM table using three files.
This is normal.
--
Paul DuBoi
It is almost safe, but not entirely, since another user could slip in a row
with your number in the split second between your Select ... and your
Insert. That is the case for blocking the Select ... Insert sequence as one
logical unit of work so the target table is locked from Select through
Insert
I have three files which are .frm, .MYD and .MYI.
How I can use those three files become one table again?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am having a nightmare of a time with transactions in my application.
I need to wrap updates to may unrelated tables in a single transaction.
I am developing in Kylix so I needed to customize the DataSetProvider
component to not automatically launch a transaction for every update
(thus precludin
Aah, I stand corrected. Friday afternoon is not my best day to be
answering questions on here. ;)
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 1:59 PM
To: [EMAIL PROTECTED]
Subject: RE: Help with Date
You can always catch the Duplicate Key error and respond accordingly in
your PHP script.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 1:41 PM
To: MySQL List
Cc: PHP eMail List
Subject: Duplicate records
On 6 Jun 2003 at 13:43, Mike Hillyer wrote:
> SELECT StartDate FROM Events
> WHERE 0 <= TO_DAYS(NOW()) - TO_DAYS(StartDate) <= 30;
I don't think that's doing what you think it is. In math notation <=
can be chained that way, but not in most programming languages.
0 <= x <= 30
is equivalen
Hello Steve,
Do a select on the record before you insert it. If the record does not exist in the
database (i.e. mysql_num_rows () == 0) than it is safe to do the insert.
John
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 3:41 PM
To: MySQL L
On 6 Jun 2003 at 20:34, Trevor Sather wrote:
> mysql> SELECT StartDate FROM Events
> -> WHERE TO_DAYS(NOW()) - TO_DAYS(StartDate) <= 30;
> ++
> | StartDate |
> ++
> | 2004122600 |
> | 2003072100 |
> | 2003080600 |
> | 2003092600 |
> | 200305
Thanks very much (to all who replied) -- this looks good!
Best wishes
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 06 June 2003 20:46
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Help with Date Range Query
At 20:34 +0100 6/6/03, Trevor Sather wrote:
At 20:34 +0100 6/6/03, Trevor Sather wrote:
Hello,
Any idea why the following doesn't work? It's taken from the MySQL manual
which says it should return records in the last 30 days. As you can see,
I'm getting records spanning some 19 months from last May to December
2004...
The example probably
Because now - a future date is a negative number, and therefore < 30.
Trevor Sather wrote:
Hello,
Any idea why the following doesn't work? It's taken from the MySQL manual
which says it should return records in the last 30 days. As you can see,
I'm getting records spanning some 19 months from
Well, when I do this query:
select to_days(now()) - to_days('2004122600');
I get -569, which is much less than 30, any date in the future will be
negative.
You may want to do this if you are looking for this style of query:
SELECT StartDate FROM Events
WHERE 0 <= TO_DAYS(NOW()) - TO_DAYS(S
Hello.
I am adding a record to a MySQL Database using PHP. I have the records
listed by the field: $id_num.
I want the DB to be updated only with new id numbers, and return an error if
there is a duplicate number already in the DB.
Here is the code I am using:
edit', 'delete', '$id_num', '$titl
/var/lib/mysql must be world searchable:
/var/lib/mysql/ must be writeable by the user mysql.
/var/lib/mysql.sock will be created when mysqld starts, and must be
world writable.
jude dashiell wrote:
Here's the output I get only as a user to mysql but not logging in as
root:
Script started on Fri
Hello,
Any idea why the following doesn't work? It's taken from the MySQL manual
which says it should return records in the last 30 days. As you can see,
I'm getting records spanning some 19 months from last May to December
2004...
mysql> SELECT StartDate FROM Events
-> WHERE TO_DAYS(NOW())
At 18:52 -0500 6/5/03, Mark Rages wrote:
According to the docs, single update statements are atomic.
That's correct.
So why doesn't this work?
mysql> create table t (num INT, UNIQUE (num));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into t values ('1');
Query OK, 1 row affected (0.00 sec)
At 14:30 +0100 6/5/03, Moj Bordel wrote:
Hello,
I'm not really sure (I'm by no means an expert) but
shouldn't this be possible?
UPDATE test set i_test=item.i_itemID WHERE
test.i_ID=item.i_itemID;
I'm getting this reply:
"MySQL said:
Unknown table 'item' in where clause"
while of course table 'items
At 21:46 -0400 6/5/03, Richard Adler wrote:
I just loaded mySql on windows98.
I try to run it and I get the following messages:
C:\mysql\bin>mysqld --standalone --console
030605 19:10:46 InnoDB: Started
C:\MYSQL\BIN\MYSQLD.EXE: ready for connections.
Version: '4.0.13-max-debug' socket: '' port:
Why can't I set ft_min_word_len? According to the
docs, this is available in 4.0. Do I have to use some
other syntax?
Set it at server startup time.
mysql> select version();
+---+
| version() |
+---+
| 4.0.12|
+---+
mysql>
Hi All,
I know I'm re-posting but there must be someone out there who can
explain. Please Help. Thanks
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Ow Mun Heng
Sent: Thursday, June 05, 2003 9:47 AM
To: [EMAIL PROTECTED]
Why can't I set ft_min_word_len? According to the
docs, this is available in 4.0. Do I have to use some
other syntax?
mysql> select version();
+---+
| version() |
+---+
| 4.0.12|
+---+
mysql> set ft_min_word_len=3;
ERROR 1
I just loaded mySql on windows98.
I try to run it and I get the following messages:
C:\mysql\bin>mysqld --standalone --console
030605 19:10:46 InnoDB: Started
C:\MYSQL\BIN\MYSQLD.EXE: ready for connections.
Version: '4.0.13-max-debug' socket: '' port: 3306
I do not get a prompt back. I assume
I am using mysql 3.23.54 and am trying to repair the index, using
myisamchk -o tablename.MY and am getting the following error:
- recovering (with keycache) MyISAM-table 'msg.MYI'
Data records: 498802
myisamchk: Error writing file 'msg.TMD' (Errcode: 28)
myisamchk: error: 28 when writing to datafi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark Rages wrote:
> On Thu, Jun 05, 2003 at 09:06:43PM -0400, O'K Web Design wrote:
>
>>Hi
>>
>>You are not defining num so you are adding 1 to 0 to get 1 and you
>>already have that record. Sounds like you need an autoincrement field.
>>Mike
>
>
Using InnoDB on a large table (> 100,000,000 rows)...
Trying to get a count that should equal about 25,000,000.
Wasn't using that much memory.
Database crashes
Any idea?
030605 19:38:27 InnoDB: Assertion failure in thread 45068 in file
row0sel.c line 1977
InnoDB: Failing assertion: len == DAT
-->-Original Message-
-->From: Alec Smith [mailto:[EMAIL PROTECTED] On Behalf Of Alec
-->Smith
-->Sent: Friday, June 06, 2003 11:24 AM
-->To: [EMAIL PROTECTED]
-->Subject: Lost connection to MySQL server during query
-->
-->Hi -
-->
-->[Perhaps not exactly the right list, but [EMAIL PROTE
Hi Heikki,
Thank you for confirming what I was also thinking about. I realised that when
specifying datadir=/usr/local/mysql that the server doesnt start up.
Knowing this I also realised that I still have some need to learn ;-).
I already have some more questions, but I will go back to studies
Hi -
[Perhaps not exactly the right list, but [EMAIL PROTECTED] doesn't
seem to be too active, so I'm hoping someone here might be able to offer
some insight.]
I'm getting the below error when trying to connect to a MySQL 4.0.12
server on RedHat 9 using a Perl script:
DBI connect('mailers:192.16
Carlos,
- Original Message -
From: ""Carlos Proal"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, June 06, 2003 4:04 AM
Subject: start innodb without transactions
>
> Hi all
> Is there any way to start mysql/innodb skipping transactions ?, i had a
> crash and i ca
I'm guessing blob data? ~1500MB / 400rows = ~3.75MB /row
On Fri, 6 Jun 2003, Jeremy Zawodny wrote:
> On Fri, Jun 06, 2003 at 09:36:08AM +0200, H M Kunzmann wrote:
> >
> > Hi all.
> >
> > I am running RH9.0 with MySQL 4.0.13
> >
> > I am trying to create a fulltext index on a 1.5GB table with
John,
what do
SHOW CREATE TABLE user_new;
and
explain select count(*) from user_new where list_code = 18;
and
CHECK TABLE user_new; (this may last hours and will also print to the
.err log)
say?
Which MySQL version you are running and on what Linux distro?
Best regards,
Heikki Tuuri
On Fri, Jun 06, 2003 at 11:32:25AM -0500, Sam Jumper wrote:
> What steps can be taken to speed up queries that show state="copy to tmp
> table" in show processlist? I am running MySql on a dual Xeon system
> running Windows 2000 server with 10 10K rpm drives in 5 raid 0 arrays
> and plenty of ram
On Thu, Jun 05, 2003 at 09:06:43PM -0400, O'K Web Design wrote:
> Hi
>
> You are not defining num so you are adding 1 to 0 to get 1 and you
> already have that record. Sounds like you need an autoincrement field.
> Mike
I don't need an autoincrement field. In my actual application, the num
On Fri, Jun 06, 2003 at 09:36:08AM +0200, H M Kunzmann wrote:
>
> Hi all.
>
> I am running RH9.0 with MySQL 4.0.13
>
> I am trying to create a fulltext index on a 1.5GB table with 400
> records.
I'm curious. What's the structure for your 1.5GB table with only 400
records look like?
Jeremy
--
Here's the output I get only as a user to mysql but not logging in as
root:
Script started on Fri Jun 6 14:09:06 2003
[EMAIL PROTECTED]:~$ mysql -u das dashielljt -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
[EMAIL
Hi Francisco,
please login to your mysql server and do this:
SHOW GRANTS FOR username;
Thats probably the fastes way to troubleshoot this issue.
If you really have 2 entries for the same user than t depends on 2 things
which one takes precedence 1) which entry is mor specific or 2) which orde
Hi all
Is there any way to start mysql/innodb skipping transactions ?, i had a
crash and i cant get the database to work.
i tried the force_recovery option level 3:
# 3 (SRV_FORCE_NO_TRX_UNDO) do not run transaction rollbacks after recovery;
this way i can get it to work, but as the manual said i
Hi
You are not defining num so you are adding 1 to 0 to get 1 and you
already have that record. Sounds like you need an autoincrement field.
Mike
- Original Message -
From: "Mark Rages" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: June 5, 2003 7:52 PM
Subject: I thought single
Using InnoDB on a large table (> 100,000,000 rows)...
Trying to get a count that should equal about 25,000,000.
Wasn't using that much memory.
Database crashes
Any idea?
030605 19:38:27 InnoDB: Assertion failure in thread 45068 in file
row0sel.c line 1977
InnoDB: Failing assertion: len == DAT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Simpson, Ken wrote:
> Mark,
>
>
>
>>I'm using InnoDB tables, which are reputed to be ACID compliant.
>>Same problem.
>>
>>I guess I will follow your suggestion and just drop the UNIQUE
>>constraint since it appears to be evaluated after each row is
>
Hi:
Thanx for the response. But yes the "ZEUS.OLYMPUS.LOCAL" host is in the
mysql.user database for the user root. There are 2 entries for the root
user, one for [EMAIL PROTECTED] and one fore [EMAIL PROTECTED] and
they both have the same global privileges set to ALL. I think that I
have to add th
Mark,
> I'm using InnoDB tables, which are reputed to be ACID compliant.
> Same problem.
>
> I guess I will follow your suggestion and just drop the UNIQUE
> constraint since it appears to be evaluated after each row is
> UPDATEd and not after the UPDATE completes.
>
> I'll check out how Postg
:-) didn't pay enough attention
Thanks
PaT!
-Messaggio originale-
Da: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Inviato: venerdì 6 giugno 2003 19.08
A: [EMAIL PROTECTED]
Cc: PaT!
Oggetto: Re: UPDATE doesn't work
On 6 Jun 2003 at 19:00, PaT! wrote:
> mysql> UPDATE ordini SET prezzo = p
Hi
> mysql> SELECT prezzo, totale FROM ordini WHERE numordine=1157;
> mysql> UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
> WHERE numordine>1385 AND dataord<'2003-06-01';
You are selecting data for numordine = 1157, but are updating all records
that have
numordine > 1385. 1157
* PaT!
[...]
> I need to update some values in two fields 'prezzo' and 'totale' These
> are the values before the UPDATE
>
> mysql> SELECT prezzo, totale FROM ordini WHERE numordine=1157;
> +++
> | prezzo | totale |
> +++
> | 6.795 | 6.795 |
> | 13.835 | 13.835 |
>
On 6 Jun 2003 at 19:00, PaT! wrote:
> mysql> UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
> WHERE numordine>1385 AND dataord<'2003-06-01'; Query OK, 1649 rows
> affected (0.10 sec) Rows matched: 1650 Changed: 1649 Warnings: 0
>
> These are the values after the UPDATE
>
> mysq
On Fri, Jun 06, 2003 at 01:07:43PM +0200, Jon Haugsand wrote:
> * Mark Rages
> > According to the docs, single update statements are atomic.
>
> I would not say that your problem is with atomicity, but with
> consistency. It is expected that a transaction oriented database
> should follow the ACI
Hi
I'm running MySQL 4.0.13
MS Windows XP Prof
I've this problem:
A db with a table called 'ordini'
mysql> desc ordini;
+-+---+--+-++---
-+
| Field | Type | Null | Key | Default| Extra
|
+-+---+
So you have no redundancy? 5 arrays of raid 0 (2 disks each) = lose a
disk and your pooched..
suggestion:
reconfigure to raid 0+1 (more than 2 disks a set) for added perf ?
On Fri, 6 Jun 2003, Sam Jumper wrote:
> What steps can be taken to speed up queries that show state="copy to tmp
> table"
According to the docs, single update statements are atomic.
So why doesn't this work?
mysql> create table t (num INT, UNIQUE (num));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into t values ('1');
Query OK, 1 row affected (0.00 sec)
mysql> insert into t values ('2');
Query OK, 1 row aff
What steps can be taken to speed up queries that show state="copy to tmp
table" in show processlist? I am running MySql on a dual Xeon system
running Windows 2000 server with 10 10K rpm drives in 5 raid 0 arrays
and plenty of ram that isn't being utilized.
Sam
Hi,
Any one knows if MySQL implemented the feature which is equivalent to
Oracle's "Connect by Prior"
clause. This is needed for retrieving 'Tree' result set from a table like :
thanks
BG
- Original Message -
From: "Juan Carlos Escobar Gzz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sen
Documentation for MySQL Connector/J, the MySQL JDBC driver, is now
available on the MySQL AB web site in HTML format:
http://www.mysql.com/documentation/connector-j/
Links to the document also are available on the main Connector/J page,
and the main documentation page:
http://www.mysql.com/product
Francisco Castellon schrieb:
Hello list:
Just finished installing mySQL on a Linux Debian system and I have a
question about how the 2 root users that are set up by default. When I
look at my user table there is a root user allowed to log in from
"localhost" and also another root user but this on
Hi!
I have executed this instruction:
$sess = mysql_db_query("$db","select * from session where ID = '$session'");
$brow = mysql_result($sess,0,browser);
Why display this message:?
Warning: Unable to jump to row 0 on MySQL result index 4 in
What is my error?
T
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan Hinz wrote:
> Okan,
>
>
>>I want to enable UTF8 support for mysql.Thats why I have installed
mysql 4.1
>>on a Win2K server and set the appropriate character set parameter at
my.ini
>>file. As the mysql service starts, I get the error that mysql
Okan,
> I want to enable UTF8 support for mysql.Thats why I have installed mysql 4.1
> on a Win2K server and set the appropriate character set parameter at my.ini
> file. As the mysql service starts, I get the error that mysql can not find
> the utf8.xml file.
> mysqld-opt: File 'D:\mysql\share\c
Hello list:
Just finished installing mySQL on a Linux Debian system and I have a
question about how the 2 root users that are set up by default. When I
look at my user table there is a root user allowed to log in from
"localhost" and also another root user but this one is only allowed to
log in f
I got mysql working for root and got a password for mysql set by root as
well. I got into the tutorial and managed to populate the pet table with
the load command and the insert command. The my.cnf file only has
user=dashielljt in it and I'd like to know how to arrange things so that
users can ac
# [EMAIL PROTECTED] / 2003-06-06 09:21:32 -0400:
> Heikki Tuuri wrote:
>
> >InnoDB is totally C, MySQL half C++ and half C, with a few hundred lines of
> >x86 Assembler.
> Oh? I thought that MySQL ran on Mac OSX as well as various Intel platforms.
the parts that are written in assembler are
1 - 100 of 194 matches
Mail list logo
