sorry
--
-- -- -- --
Sayusi Ando
-- -- -- --
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu December 30 2004 10:02 pm, [EMAIL PROTECTED] wrote:
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please click on
the following link:
http://lists.mysql.com/s/mysql/41d3ee5569b3c2f7/mabiddulph=netxp.com.au
This confirmation serves two
Hi,
I'd like to insert binary data from a series of image files into a blob
column using a sql statement. I have working examples from jsps / java
but I'd like to write a sql script to do the same.
I've had a look at the load data infile commands but they only seem to
relate to text data.
[snip]
atomically from my applications point of view means:
I have a snapshot of my data (due to InnoDB this does not change
hiddenly during
my session). I send a query to the database. I get the result / changed
data.
And everything between sending and the receiving the result I expect to
be
is there a utility like mysqlbinlog but instead processes the query log?
I would like to reprocess the queries from the query log.
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to think of SQL that will let me show a one to many relationship
as a single row in a result set. They say a picture is worth a thousand
words so let me draw that picture.
Event_IDEvent_Nameetc.
1 Concert
2 Art Exhibit
3 Spelling Bee
[snip]
When I upload some data into my mysql database, the file ibdata1 is growing.
Usually I export contents of files into database. That's our requirement.
When I remove the same data from tables, there is no change in ibdata size.
I.e. it is not getting reduced with the deletions. But if I
There is one record in the Events table for each event that an organization
is promoting. For each event, there could be 0 to 'n' files that give more
information about the event, such as pictures, audio clips, or whatever. I
want to display all the information about the event, including all
Hello,
I tried to install mysql-max-4.1.8-pc-solaris2.9-i386
on v20z with Solaris 9 04/04.
I get the following error message:
ld.so.1: ./bin/mysqld: fatal: libCrun.so.1: version `SUNW_1.4' not found
(required by file ./bin/mysqld)
ld.so.1: ./bin/mysqld: fatal: libCrun.so.1: open failed: No such
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
07:59:35 AM:
[snip]
atomically from my applications point of view means:
I have a snapshot of my data (due to InnoDB this does not change
hiddenly during
my session). I send a query to the database. I get the result / changed
data.
And
Our copy of MySQL (4.0.15'-Max') is on a Linux Mandrake 9.x server. We
installed it from an RPM (actually an MDK, which is functionally the same
thing) and are running MySQL as a service.
Would it be possible to run a second copy of MySQL, ideally the latest
4.1.x, on our server in parallel with
[EMAIL PROTECTED] schrieb:
I snipped the discussion down to the SQL-statements with some
explanational text. I hope it does not break reading.
[snip]
UPDATE table1
INNER JOIN table2 ON table2.ID_table1=table1.ID
SET table2.value=table2.value-IF(table1.condition=7,1,0),
table1.condition=8
First of all, thanks for the mailing list for giving details about myisamchk.we
used them but we got some errors which I have reported in 'myisamchk errors'
mail to mysql.
At present we are working in mysql 3.23.32 ,windows xp os.
Are there any system tables that store mysql related info.(like
[snip]
I hope I am not so naive that Kai and I are the only two who sees a
problem with this behavior. Some of you may think this is a feature
but I do not like it because that means that calculational errors will
occur simply by inverting column positions (putting one before the
other) within a
We loaded a new server with Windows XP professional, and mysql server 4.1. We
can't get Mysql to run. After installing mysql and trying to execute it we get
the following message:
ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using password:
NO)
Any ideas on what we can
Jay Blanchard schrieb:
[snip]
I hope I am not so naive that Kai and I are the only two who sees a
problem with this behavior. Some of you may think this is a feature
but I do not like it because that means that calculational errors will
occur simply by inverting column positions (putting one
Kevin A. Burton wrote:
This is a bug.
Feature.
I have all the slave configuration in /etc/my.cnf commented out.
However the machine was ONCE a slave and so data/master.info exists.
I commented out all the /etc/my.cnf settings WRT master-* yet when I
restart the box it STILL insists on starting
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
11:43:43 AM:
[snip]
I hope I am not so naive that Kai and I are the only two who sees a
problem with this behavior. Some of you may think this is a feature
but I do not like it because that means that calculational errors will
occur
David Katz [EMAIL PROTECTED] wrote on 12/30/2004 12:34:31 PM:
We loaded a new server with Windows XP professional, and mysql
server 4.1. We can't get Mysql to run. After installing mysql and
trying to execute it we get the following message:
ERROR 1045 (28000): Access denied for user
[snip]
So the question is not, if a multi table update should be implemented
serialized. The answer is clear: yes it should.
The question is, on which data the subsequent updates should work.
[/snip]
It should work on the data specified in the update query. Each set
statement is isolated and the
I'm going to the dos window on the server and typing mysql to kick it off.
That's when I get the error.
- Original Message -
From: [EMAIL PROTECTED]
To: David Katz [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday, December 30, 2004 1:13 PM
Subject: Re: Fw: installing mysql /
[snip]
I understand that is the behavior of the assignment operator. That's why
I used it. ;-) I expected the results to be 19 and 6 not 19 and 20.
This is just another example of the serialization of evaluation that
occurs while processing a single row of data. I have the opinion that
while
[snip]
We loaded a new server with Windows XP professional, and mysql server 4.1.
We can't get Mysql to run. After installing mysql and trying to execute it
we get the following message:
ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using
password: NO)
[/snip]
Try starting
[snip]
We loaded a new server with Windows XP professional, and mysql server 4.1.
We can't get Mysql to run. After installing mysql and trying to execute it
we get the following message:
ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using
password: NO)
[/snip]
Ignore my
David Katz [EMAIL PROTECTED] wrote on 12/30/2004 01:32:41 PM:
I'm going to the dos window on the server and typing mysql to kick it
off.
That's when I get the error.
OK, mysql is the client that comes with the server. What you attempted
to do was to login as nobody and you said you weren't
When I try 'mysql -u root' I get the same error, except root is in the
place of ODBC
ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
password: NO)
- Original Message -
From: Tom Crimmins [EMAIL PROTECTED]
To: David Katz [EMAIL PROTECTED]
Cc:
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'wish_list_id`
[snip]
When I try 'mysql -u root' I get the same error, except root is in the
place of ODBC
ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
password: NO)
[/snip]
In that case, you may have a password set for root. To reset the password,
shutdown the mysql server. Then
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
01:32:20 PM:
[snip]
I understand that is the behavior of the assignment operator. That's why
I used it. ;-) I expected the results to be 19 and 6 not 19 and 20.
This is just another example of the serialization of evaluation that
occurs
Don Stefani wrote:
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Thursday, December 30, 2004 9:03 AM
Subject: Need help with SELECT
I am trying to think of SQL that will let me show a one to many
relationship
as a single row in a result set. They say a picture
[snip]
... a bunch of stuff
[/snip]
It alomost sounds as if you're coming from a M$ campwhat you
describe are VIEWS.
Anyhow, the ANSI SQL standards specify some of the behaviors we have
been talking about. Many DB manufacturers use the standards and
implement other features like you
How should I handle encodings and output to web pages?
I'm inserting some POST variables from a PHP script directly into a
MySQL database. (I have magic quotes turned on, so quotes already taken
care of.)
There's the possibility that there could be some UTF-8 bytes in the
POST variable
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004
03:50:24 PM:
[snip]
... a bunch of stuff
[/snip]
It alomost sounds as if you're coming from a M$ campwhat you
describe are VIEWS.
In a way it is, an internally generated view of the source/destination
tables.
Anyhow, the
[snip]
Anyhow, it has been a good discussion. No bugs were uprooted and
everyone's understanding may have risen a notch. After a couple of
decades using SQL I still find interesting topics to discuss.
Yes, I too have enjoyed this conversation. Thank you for thinking out
loud with me on such an
[snip]
...tons o' stuff...
[/snip]
BTW...Happy New Year!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've been struggling with this problem for the last few days. I've
enlisted the help of some colleagues on the NYLUG (NY Linux User's
Group) list but finally we figured this is the best place to look for
some help.
We have a server running SLES 9.0 (SuSE Linux Enterprise Server 9.0) and:
Spenser, the bug report was a direct hit in the sense that it spoke
about the problem I am having, but it was actually wrong and the
suggested FLUSH TABLES workaround did not work.
On my servers (4.0.13-nt running on Windows 2000 Pro) FLUSH TABLES had
no effect at all on the Update_time.
I quit
Kevin A. Burton wrote:
The ANALYZE TABLE entry in the manual doesn't say anything about
performance optimization.
How do I get optimum performance out of ANALYZE TABLE?
Can I just set the same variables as I would with REPAIR TABLE?
key_buffer_size
sort_buffer_size
myisam_sort_buffer_size
Also...
Dale Blount wrote:
Hello,
I've been fighting this problem for a while, and now it's time to ask
the experts. Please also CC me on this, I'm only on the list as a
digest.
Dale:
Enable the log-long-format and log-slow-queries on your server, and see if you
have some hogs that lock your table for a
Russ wrote:
I just set up mysql and found it running as root. I want to change it to run
as mysql. I know I need an entry under [mysqld] in my.cnf. I also know the db
directories and files need peermission changes but I'm confused on that. I
use SuSE 9.1 and the datadir is:
/var/lib/mysql ls
shaun thornburgh wrote:
Hi,
The following query returns the amount of hours a user has been booked
for on a particular day.
SELECT (SUM(((DATE_FORMAT(B.Booking_End_Date, %k) * 60 ) +
DATE_FORMAT(B.Booking_End_Date, %i)) -
((DATE_FORMAT(B.Booking_Start_Date, %k) * 60 ) +
Bernhard v. Fromberg wrote:
Hello,
I tried to install mysql-max-4.1.8-pc-solaris2.9-i386
on v20z with Solaris 9 04/04.
I get the following error message:
ld.so.1: ./bin/mysqld: fatal: libCrun.so.1: version `SUNW_1.4' not found
(required by file ./bin/mysqld)
ld.so.1: ./bin/mysqld: fatal:
Rhino wrote:
Our copy of MySQL (4.0.15'-Max') is on a Linux Mandrake 9.x server. We
installed it from an RPM (actually an MDK, which is functionally the same
thing) and are running MySQL as a service.
Would it be possible to run a second copy of MySQL, ideally the latest
4.1.x, on our server in
Hi Bernhard,
Check the binary to see the path name it is requiring. ie. ldd
/usr/local/libexec/mysqld, I'm running an earlier version (4.0.20) and not
running max so I probably don't require the libCrun library, it is in my
/usr/lib as well, but the output is :
bash-2.05$ ldd
It looks like your tablespace is corrupt. Check this doc out:
http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
On Thu, 30 Dec 2004 17:21:40 -0500, jsf [EMAIL PROTECTED] wrote:
I've been struggling with this problem for the last few days. I've
enlisted the help of some colleagues on
If you can use mysqldump to export the data from 3.23 with the -Q
switch to quote all db, table, and column names.
On Thu, 30 Dec 2004 11:31:42 -0800, Don Stefani [EMAIL PROTECTED] wrote:
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an
Having a hard time finding a server/host who supports MYSQL 4.1.3 or
above.
Does anyone know and can recommend a host who offers this?
Thanks,
Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Don't mean to start a discussion whatsoever, I love php, but one thing i
can't do in php is Response.Redirect(page.asp) .
Apart from that no complains so far :)
* Happy New Year *
Pedro Almeida.
-Mensagem original-
De: Tony Di Croce [mailto:[EMAIL PROTECTED]
I am fairly new to PHP,
Sorry, wrong list!
-Mensagem original-
De: mail.pmpa [mailto:[EMAIL PROTECTED]
Don't mean to start a discussion whatsoever, I love php, but one thing i
can't do in php is Response.Redirect(page.asp) .
Apart from that no complains so far :)
* Happy New Year *
Pedro Almeida.
Hi,
RE:
I believe this is what you are looking for:
ALTER TABLE Images MODIFY Imcreatedat datetime NOT NULL default '-00-00
00:00:00' AFTER Imccdtemp;
Thanks, Tom for the clue.
Yes, this is what I tried, but it did not work. Seems like modify does
not accept the AFTER part.
I tried it
Thanks Eric,
We already tried levels 1, 3 and 5...
no soap. I'm on the verge of thinking it's a bug.
:-(
J.
On Fri, 31 Dec 2004 00:06:28 +, Eric Bergen [EMAIL PROTECTED] wrote:
It looks like your tablespace is corrupt. Check this doc out:
Joshua,
please show what the FIRST InnoDB error in the .err log was. The first error
is always the important thing to report.
Please follow these instructions:
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html
and follow instructions on how to resolve the stack trace. Resolved
Bruce,
5.0.3 is the next in line. I am not sure whether 4.0.9 comes after that.
You should consider buying a MySQL support contract. MySQL Gold and Platinum
Premier Support customers are entitled to custom builds:
http://www.mysql.com/support/premier.html
Best regards,
Heikki Tuuri
Innobase Oy
Sorry about that. You are correct using AFTER or FIRST with ALTER TABLE ...
MODIFY is not supported until version 4.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
Hi,
RE:
I believe this is what you are looking for:
ALTER TABLE Images MODIFY
55 matches
Mail list logo