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 I
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
Fo
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
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:
> http://dev.mysql.com/doc/mysql/en/Forcin
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
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.
-Men
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,
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]
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
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 o
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 /usr/local/libexe
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 par
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: libCrun.s
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 ) +
DATE_FOR
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 -
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
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... D
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 t
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:
mysqlad
[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]
[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
"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.
>
> Any
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 strings.
[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 des
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "mysql"
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 is worth a tho
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
ne
"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
>
[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 sta
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` i
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:
Sent: Thursd
"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
[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 previo
[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 mys
[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 proce
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:
Sent: Thursday, December 30, 2004 1:13 PM
Subject: Re: Fw: installing mysql / error
> "Davi
[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
"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 denie
"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
> o
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 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 bef
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 tr
[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
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
[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
WHERE
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 t
"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
> d
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 fi
> 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 al
[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 exp
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
[P
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]
[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
han
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.
mor
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 t
sorry
--
-- -- -- --
Sayusi Ando
-- -- -- --
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
55 matches
Mail list logo
