Hello,
I am trying to develop a back-up procedure for our MySQL database.
The database is housed on our production Web server. My thought is to
simply make a slave on our file server that is backed up. I use InnoDB
type tables and my application uses transactions. I am wondering how
Hello,
I am trying to develop a back-up procedure for our MySQL database.
The database is housed on our production Web server. My thought is to
simply make a slave on our file server that is backed up. I use InnoDB
type tables and my application uses transactions. I am wondering how
Sorry to bother the list with the mundane, but I have searched the
entire MySQL manual and can't find the answer. Is there a way to output
the table description (using DESCRIBE) into an OUTFILE like you can for
SELECT query statements? Thanks! Aaron
I've had simmilar problems.
I had something like this...
String blah = myResultSet.getString(BLAHBLAH);
if(!myResultSet.wasNull()){
if(blah.equals(something)){ ...boom nullPointer exception
I'm not sure why the null value wasn't caught by wasNull(). Anyway I
worked around it by adding an
I actually posted this yesterday, but I think it got lost with the whole
Oracle debacle. If anyone has experienced this your feedback would be
greatlt appreciated. best regards, Aaron
Occasionally with MyODBC, MySQL and Access I am getting an error when
trying to close a window stating 'This
Occasionally with MyODBC, MySQL and Access I am getting an error when
trying to close a window stating 'This action will reset the current
code in break mode. Do you want to stop the running code-Yes/No'. It
becomes impossible to close the window because it wont allow me to
select Yes. The
...uhm...yeah right. I also heard Larry Ellison was going to give all
his money away to help starving children in Afghanistan as well.
-Original Message-
From: MadProfessor [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 3:48 PM
To: [EMAIL PROTECTED]
Subject: Impact of Free
MySQL can do the whole job. The client doesn't need to do the
encryption. Just use the password() function in your select and
updates.
--Aaron
Java examples:
String insertStatementStr = INSERT into users VALUES
(?,?,?,?,PASSWORD(?),?,?, ?, ?);
ResultSet myResultSet = stmt.executeQuery(SELECT
I would think an add on to Apache Xerces would be perfect for this--and
not difficult. Has anyone from MySQL contacted members of the Apache XML
project about this? It would be great if this was done in a high
profile open source environment. An XML wrapper API for MySQL would fit
a huge whole
Hello,
In my application I would like to update a MySQL record where one
column
is the largest value. Do I have to create a separate SELECT sql query
statement
to get that value and then update it? Or, is there a function that
allows me to specify it as part of my WHERE clause. I scanned
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:12 PM
To: Rutledge, Aaron
Cc: Mysql List (E-mail)
Subject: Re: LIKE work around??
Work-around? LIKE should work just fine...
mysql select * from fruits where fruit_name like '%banana%';
On Thu, 7 Feb
MySQL doesn't support LIKE does it? I got an error when I tried. =20
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Original
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
result set returned that contains everything that starts with banana.
Any way to do this? I think I would use LIKE in other types of
databases, but I was
MySQL doesn't support LIKE does it? I got an error when I tried.
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Original
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:12 PM
To: Rutledge, Aaron
Cc: Mysql List (E-mail)
Subject: Re: LIKE work around??
Work-around? LIKE should work just fine...
mysql select * from fruits where fruit_name like '%banana%';
On Thu, 7 Feb
: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:43 AM
To: Rutledge, Aaron
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Aaron,
-Original Message-
From: Rutledge, Aaron [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Tuesday, January 15, 2002 7:13
The added complexity frightens me a little. It seems a little
black-boxish to me right now. I am sure it is only a matter of getting
use to and working with the architecture. The idea of a separate
table-handler in the RDBMS seems very foreign when you come from the
Oracle world. However, I
Woah...
Heikki Tuuri wrote:
With some work, yes. innodb_table_monitor prints the internal schema of
InnoDB. There are fewer column types inside InnoDB than in MySQL. For
example, a DATE column will appear as an integer.
Now I am confused again. Do you only have access to column types
PROTECTED]
Subject: Re: innoDB confusion
Aaron,
Rutledge, Aaron wrote in message ...
Woah...
Heikki Tuuri wrote:
With some work, yes. innodb_table_monitor prints the internal schema
of
InnoDB. There are fewer column types inside InnoDB than in MySQL. For
example, a DATE column will appear
Hello, I am new to this list and MySQL. I am very excited about this
open source community. I can definitely see MySQL becoming to database
servers, what Apache has become to web servers.
I am currently developing a mission critical manufacturing web
application in Java and I am leaning
20 matches
Mail list logo